Which field in the employee table should be the primary key

Reference no: EM13509084

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?

Reference no: EM13509084

Questions Cloud

How far did the car travel during this time : A car movig with an initial velocity of 29.6 m/s decrease to a velocity of 17.9 m/s over a time interval of 4.08 seconds. how far did the car travel during this time

What is mortgage redlining : What are two of the most important payment services provided by financial institutions? To what extent do these services efficiently provide benefits to the economy?

Prepare in good form a balance sheet for the year : Prepare in good form a balance sheet for the year ended December 31, 2011.

Find how many revolutions would the wheel have made : Over the course of a multi-stage 4280-km bicycle race, the front wheel of an athlete's bicycle makes 2.28 106 revolutions. How many revolutions would the wheel have made

Which field in the employee table should be the primary key : Which field in the Employee table should be the primary key? Why?

Why might a manager of a company using absorption costing : why might a manager of a company using absorption costing produce more units then can currently be sold?

Compute the activity rate for each of the activity cost pool : Using the ABC data, determine the total amount of overhead cost assigned to each product. (Do not round intermediate calculations. Round your answers to the nearest dollar amount.)

Increase in revenue reimbursement : Established in 1977, Krona Community Hospital is a 60-bed, acute care hospital located in the heart of Banconota County. With a staff of nearly 100 physicians and specialists, 400 employees, and 75 volunteers, they offer a full range of health ..

Find the max height of the rock during flight : a catapult launches a rock towards a hill 500m away. the rock lands on the hill 20m above the release point of the rock. find the max height of the rock during flight

User Account

All Pages