Explore BrainMass
Share

Ms Access

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Please answer the following questions below.

Phil has been asked to create a database for his company. The database is to track employees and the projects on which the employees work. A project can have between 3 and 7 employees assigned to it. He has determined that he needs the following tables:

Employee (Social Security Number, Employee Name, Street Address, City, State, Postal Code, Date Hired, Hourly Pay Rate, Project Code)

Project (Project Code, Project Name, Completion Date)
a. Which field in the Employee table should be the primary key and why?
b. Which field in the Project table should be the primary key and why?

Now that Phil has created the tables and determined the primary and foreign keys, he needs to determine the data types for the fields in each table.
c. What data type should Phil use for the Hourly Pay Rate field? Why?
d. What data type should Phil use for the Social Security Number field? Why?

© BrainMass Inc. brainmass.com March 21, 2019, 10:31 pm ad1c9bdddf
https://brainmass.com/computer-science/security/project-code-project-name-completion-date-access-420522

Attachments

Solution Preview

Please answer the following questions below.

Phil has been asked to create a database for his company. The database is to track employees and the projects on which the employees work. A project can have between 3 and 7 employees assigned to it. He has determined that he needs the following tables:

Employee (Social Security Number, Employee Name, Street Address, City, State, Postal Code, Date Hired, Hourly Pay Rate, Project Code)

Project (Project Code, Project Name, Completion Date)
a. Which field in the Employee table should ...

Solution Summary

This posting contains the solution to the given problems.

$2.19