Project IS

set feedback off cl screen set heading off /* Drop Table statements are used during the code debugging stage. Once code is correct, they are no longer needed. However, one can keep the statements for re-creating the initial tables later.*/ drop table TranDetail cascade constraints; drop table Book cascade constraints; drop table Tran cascade constraints; drop table BookType cascade constraints; drop table Student cascade constraints; purge recyclebin; Create table TranDetail (TranID number(4), Bcode varchar2(5), ReturnDate Date); insert into TranDetail values (1,'3330', to_date('3/5/2015 14:15:31','dd/mm/yyyy hh24:mi:ss')); insert into TranDetail values (1,'9440', to_date('3/6/2015 11:00:21','dd/mm/yyyy hh24:mi:ss')); insert into TranDetail values (2,'2220', to_date('3/8/2015 12:05:35','dd/mm/yyyy hh24:mi:ss')); insert into TranDetail values (2,'2510', to_date('3/9/2015 13:32:45','dd/mm/yyyy hh24:mi:ss')); insert into TranDetail values (3,'2740', to_date('3/9/2016 9:06:07','dd/mm/yyyy hh24:mi:ss')); insert into TranDetail values (4,'3330', to_date('3/8/2016 8:30:46','dd/mm/yyyy hh24:mi:ss')); insert into TranDetail values (4,'9440', to_date('3/8/2016 9:40:23','dd/mm/yyyy hh24:mi:ss')); insert into TranDetail values (5,'1510', to_date('4/5/2016 15:09:45','dd/mm/yyyy hh24:mi:ss')); insert into TranDetail values (5,'2220', to_date('4/6/2016 19:34:56','dd/mm/yyyy hh24:mi:ss')); insert into TranDetail values (5,'2510', to_date('4/7/2016 8:56:12','dd/mm/yyyy hh24:mi:ss')); insert into TranDetail values (6,'2510', to_date('5/6/2016 16:15:34','dd/mm/yyyy hh24:mi:ss')); insert into TranDetail values (7,'2740', to_date('5/5/2016 11:04:09','dd/mm/yyyy hh24:mi:ss')); Create table Book (Bookcode varchar2(5) primary key, Title varchar2(35), Type varchar2(20)); insert into Book values ('1510','True confessions','Mistery'); insert into Book values ('2220','The big','Drama'); insert into Book values ('2510','The little mermaid','Children'); insert into Book values ('2740','Backdraft','Action'); insert into Book values ('3330','Steve Jobs','Biograph'); insert into Book values ('9440','Other world','Science Fiction'); Create table Tran (TranID number(4) primary key, StudentId varchar2(10), TranDateAndTime date); insert into Tran values (1,'1002', to_date('3/4/2015 9:45:15','dd/mm/yyyy hh24:mi:ss')); insert into Tran values (2,'1003', to_date('3/5/2015 15:00:23','dd/mm/yyyy hh24:mi:ss')); insert into Tran values (3,'1003', to_date('3/6/2016 14:00:45','dd/mm/yyyy hh24:mi:ss')); insert into Tran values (4,'1004', to_date('3/7/2016 8:45:34','dd/mm/yyyy hh24:mi:ss')); insert into Tran values (5,'1005', to_date('4/2/2016 9:00:21','dd/mm/yyyy hh24:mi:ss')); insert into Tran values (6,'1001', to_date('5/2/2016 16:15:44','dd/mm/yyyy hh24:mi:ss')); insert into Tran values (7,'1003', to_date('5/4/2016 15:00:51','dd/mm/yyyy hh24:mi:ss')); create table Booktype (typename varchar2(25) primary key, avgscore number(4,2)); insert into Booktype values('Action',3.00); insert into Booktype values('Biography',2.50); insert into Booktype values('Children',4.00); insert into Booktype values('Drama',3.50); insert into Booktype values('Mistery',3.50); insert into Booktype values('Science Fiction',3.50); Create table Student (StudentId varchar2(10) primary key, Fname varchar2(20), LName varchar2(25), address varchar2(25), city varchar2(15), State char(2), Zip varchar2(5), Phone varchar2(12), RegDate Date); insert into Student values ('1001','Jerry','Seidmann','10 East Ave','Englewood','CO','80111','303-429-2778',to_date('30-3-2002','dd-mm-yyyy')); insert into Student values ('1002','Mary','Taylor','37 South Ave','Centennial','CO','80112','303-429-8990',to_date('2-4-2004','dd-mm-yyyy')); insert into Student values ('1003','Hugh','Ryan','68 Main St.','Denver','CO','80202','429-742-7243',to_date('1-5-1994','dd-mm-yyyy')); insert into Student values ('1004','Robert','Russell','98 Lakeside Dr.','Denver','CO','80217','720-643-7889',to_date('4-8-2014','dd-mm-yyyy')); insert into Student values ('1005','David','Stafford','80 River Rd.','Bloomfield','CO','80020','303-447-1435',to_date('5-8-2012','dd-mm-yyyy')); set feedback on commit; set heading on