Programming
Assignment #2
COMPANY DB:
create table emp( eid number(9,0)
primary key, ename varchar2(30), age number(3,0), salary number(10,2)
);
create table dept( did number(2,0) primary key, dname varchar2(20),
budget number(10,2), managerid number(9,0), foreign key(managerid)
references emp(eid) );
create table works( eid number(9,0), did number(2,0), pct_time
number(3,0), primary key(eid,did), foreign key(eid) references emp,
foreign key(did) references dept );
ACTIVITIES:
- (10 points )Create the
Company DB in your Oracle Account
- (10 points )Populate
your Company DB using the Oracle Bulk loader
discussed in lab2 and the data
from Emp,
Works,
Dept
- (80 points )Solve all
eight questions of exercise 5.4 (page 176) from your
textbook
Submit a report that includes SQL commands for each of your eight
queries, the resulting table after executing each of your queries
and learning
experience/conclusions.