Oracle Keys

1
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 taskDesign 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 pr
oject (each project should have a name)
Manager of the project (each project is
assigned a manager) Hours the employee worke
d on the project
I got a question about this assignment - in
answering I compared to the database that has a
donor table, a drive table and a donation table.
2
(No Transcript)
3
(No Transcript)
4
(No Transcript)
5
(No Transcript)
6
(No Transcript)
7
(No Transcript)
8
(No Transcript)
9
(No Transcript)
10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13
(No Transcript)
14
(No Transcript)
15
(No Transcript)
16
(No Transcript)