Ms Access
Not what you're looking for?
Please answer the following questions below.
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)
a. Which field in the Employee table should be the primary key and why?
b. Which field in the Project table should be the primary key and 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?
Purchase this Solution
Solution Summary
This posting contains the solution to the given problems.
Solution Preview
Please answer the following questions below.
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)
a. Which field in the Employee table should ...
Purchase this Solution
Free BrainMass Quizzes
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
Basic Networking Questions
This quiz consists of some basic networking questions.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.