Short Answer
Joe has been asked to create a Special Projects database for his sampany. The database is to track employees and the special projects to which the employees may be assigned. A special project can have between 2 and 5 employees assigned to it. He has determined that he needs the following tables: Employee (Social Security Number, Last Name, First Name, Street Address, City, State, Postal sade, Hourly Pay Rate, Project sade) Project (Project sade, Project Name, Total Hours, sampletion Date) Which field in the Employee table should be the primary key and why?
Correct Answer:

Verified
Social Security Number should ...View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Correct Answer:
Verified
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q8: To create a query using the Query
Q16: The determination of database requirements is part
Q27: To save the changes to the layout
Q43: Identify the letter of the choice that
Q44: To add a resard to a table,
Q45: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBX9085/.jpg" alt=" In the acsampanying
Q48: To insert a field between existing fields,
Q50: To delete a resard, tap or click
Q51: To change the name of a field,
Q110: Case 1-1<br>Joe has been asked to create