Phil Has Been Asked to Create a Database for His

question 26

Short Answer

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)Which field in the Employee table should be the primary key and why?

---

Definitions:

Change Colors

The process of altering the hues or shades of elements in a digital document, image, or interface to achieve a desired visual effect.

Combine Command

In computer software, the Combine Command is used to merge two or more sets of data or text into a single entity.

Compare

To compare means to analyze two or more objects, ideas, or data points to identify their similarities and differences.

Saved Versions

Copies of a file or document that are stored at different creation or modification times to enable version control and recovery.