Oracle Keys
First task: Go back to the oil company tables that you created and establish the
primary keys as you designed them. Establish foreign keys as well. Test your design by
doing some maintenance on your tables.
Second task:Design and develop a set of tables for a payroll system using the
criteria below. Set up the necessary tables for this database and populate them with data.
You need to create the appropriate primary keys and foreign keys. Your must design a
relational database following the rules to achieve third normal form. If you want me to
look at your design before you implement, please send it to me with a comment in the
subject.
We will look at a very simple version of payroll. Your payroll has to carry the following information:
- Employee #
- Employee Name
- Salary
- Tax percent withheld
- Medical withheld
- Other deductions withheld
- Projects the person is worked on (note there can be more than one project)
- Name of the project (each project should have a name)
- Manager of the project (each project is assigned a manager)
- Hours the employee worked on the project