Case 1-1 Joe Has Been Asked to Create a Special Projects Database

question 110

Essay

Case 1-1
Joe has been asked to create a Special Projects database for his company.The database is to track employees and the special projects to which the employees may be assigned.A special project can have between 2 and 5 employees assigned to it.He has determined that he needs the following tables:
Employee (Social Security Number,Last Name,First Name,Street Address,City,State,
Postal Code,Hourly Pay Rate,Project Code)
Project (Project Code,Project Name,Total Hours,Completion Date)
-Which field in the Project table should be the primary key and why?

---

Definitions:

Gun Control Laws

Legislation aimed at regulating the sale, possession, and use of firearms in order to prevent gun violence and ensure public safety.

Equal Rights Amendment

A proposed amendment to the United States Constitution aimed at guaranteeing equal legal rights for all American citizens regardless of sex, initially introduced in Congress in 1923 and passed in 1972 but not ratified by enough states.

Title IX

A U.S. federal law passed in 1972 that prohibits gender discrimination in any education program or activity receiving federal financial assistance.

Franklin v. Gwinnett County

A Supreme Court case in 1992 that allowed for damages to be awarded in cases of sex discrimination in schools under Title IX.