Solved by Expert Tutors
Solved by Expert Tutors
Question

Phil has been asked to create a database for his company. The purpose

of 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? Why?
b. Which field in the Project table should be the primary key? 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?

Sign up to view the entire interaction

Step-by-step answer

sum

entesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus a

SOL_DBMS.docx
consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus effi nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie co

Subscribe to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Let our 24/7 Microsoft Office tutors help you get unstuck! Ask your first question.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes