Which field in the employee table should be the primary key

Assignment Help Other Subject
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

Reviews

Write a Review

Other Subject Questions & Answers

  Most effective way to communicate a message to you employees

As a manager, what factors do you consider when determining the most effective way to communicate a message to you employees? Does this change if you are preparing to communicate the same message to your superiors? Why?

  Describe the elements of scope for the project

As a project manager for Ducks Unlimited, you have just been tasked with planning the upcoming Keystone Conference where the organization’s long-term strategy for the next ten years will be fleshed-out.

  The federalists party

The Federalists party, as the party of the "outs" at the end of its existence

  Operate in internal and external environments

Organizations are said to operate in internal and external environments that affect the way managers’ plan, organize, lead and coordinate their activities.

  Question on sociological perspectives

The functionalist, conflict, and interactionist perspectives can all be employed in analyzing social institutions. What are the strengths and weaknesses in each perspective's analysis of those institutions?

  What method is most likely using

Professor Kingston tracks oxygen flow in their brains while they engage in online gambling. What method is most likely using.

  The current resources are being utilized effectively

In the under border control it was mentioned that most areas of the northern border are inaccessible to traditional patrols. Most of the focus is towards the south, potentially leaving the northern border much more vulnerable than other areas. Do you..

  Robust justifications for hiring new police officers

Include at least two (2) robust justifications for hiring new police officers. The justification should anticipate the key questions that the chief executive and council will likely ask.

  Performance between rich and poor children

Comparing school performance between rich and poor children, what is the main cause of the acheivement gap? Why do senior citizens with higher incomes rate their health in better terms than people with lower incomes? What three (3) demographic trends..

  Using the family structural theory

Using the family structural theory (see the textbook as a model, how can families created out of second marriages learn to function as one

  Interpreted inappropriately as causation

Example, how correlation might be interpreted inappropriately as causation, and the possible explanations for the correlation.

  Statutes that apply to health care

Why is it important for an administrator to understand the regulations and statutes that apply to health care?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd