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:

Structures

Composite data type in programming that allows for the storage of different types of data.

Ordered Structures

Data structures that maintain their elements in a specific, organized sequence allowing for efficient access and modification.

Linked List

A data structure consisting of nodes where each node contains data and a reference to the next node in the sequence.

Constantly Changing List

A list or collection that is frequently updated or modified, often dynamically in response to different conditions.