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:

Information Technology (IT)

The use of computers, networks, and other physical devices to create, process, manage, and exchange data and information.

Demand and Supply

The economic model explaining the price and quantity of goods and services in a market based on the willingness of consumers to purchase and the quantity available for sale.

South Vietnam

South Vietnam was a country that existed from 1954 to 1975 in the southern part of Vietnam, known for its anti-communist government and its conflict with North Vietnam during the Vietnam War.

Kennedy's Assassination

The event on November 22, 1963, when President John F. Kennedy was killed by Lee Harvey Oswald in Dallas, Texas.