Transcript Document

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
I got a question about this
create the appropriate primary keys and foreign keys. Your
assignment - in answering I
must design a relational database following the rules to
compared to the database that
achieve third normal form. If you want me to look at your
has a donor table, a drive table
design before you implement, please send it to me with a
and a donation table.
comment in the subject.
We will look at a very simple version of payroll. Your payroll
has to carry the following information: