Oracle Keys
I want you to establish a variety of constraints - below there are two tasks - I want you to
embed other constraints into either of them. You need to use the constraints check, not null and unique.
You also need to establish some appropriate indexes. The two tasks are simply to give you something
concrete to illustrate the constraints.
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. So then you can use these tables to add in and test some additional constraints.
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 (each time they worked on it)