insert into t_course values('inls256', '256 Database Systems 1 (3). Haas, Hemminger. Prerequisites: INLS 50 and INLS 162. A study of the relational database model including entity relationship theory, design, normalization techniques, and SQL. ', 'Database Systems I', 'IS', 3); insert into t_course values('inls258', '258 Database Systems 11 (3). Chaffin, Haas. Prerequisite: INLS 256. Advanced study of database systems. Topics include database design, administration, current issues in development and use, object databases, and distributed databases. ', 'Database Systems II', 'IS', 3); insert into t_course values('inls259', '259 Web Databases (3). Chaffin. Prerequisites: INLS 181 or equivalent, INLS 256 or equivalent and programming experience. Explores concepts and practice surrounding the implementation and delivery of Web enabled databases. Students will gain experience with and evaluate PC and Unix Web database platforms. ', 'Web Databases', 'IS', 3); insert into t_course values('inls165', '165 Records Management (3). Southern. Introduces the principles of records center design, records analysis and appraisal, filing systems, reprographics and forms, reports and correspondence management. Legal issues and the security of records are also covered. ', 'Records Management', 'LS', 3); insert into t_course values('inls349', '349 Seminar in Rare Book Collections (3). McNamara. A study of the nature and importance of rare book collections; problems of acquisition, organization, and service. ', 'Seminar in Rare Book Collections', 'LS', 3); set linesize 80; col cid format a8; col description format a25 word_wrapped; col name format a15 word_wrapped; col interest_area heading 'interest|area' format a10; col credit format 99; /* describe t_course; */ insert into t_class values('123456', 'spring', '2001', 'inls256', '001'); insert into t_class values('123457', 'spring', '2001', 'inls256', '002'); insert into t_class values('123458', 'spring', '2001', 'inls258', '001'); insert into t_class values('123459', 'spring', '2001', 'inls258', '002'); insert into t_class values('123460', 'spring', '2001', 'inls259', '001'); insert into t_class values('123461', 'spring', '2001', 'inls349', '001'); insert into t_class values('123462', 'fall', '2002', 'inls256', '001'); insert into t_class values('123463', 'fall', '2002', 'inls256', '002'); insert into t_class values('123464', 'fall', '2002', 'inls258', '001'); insert into t_class values('123465', 'fall', '2002', 'inls258', '002'); insert into t_class values('123466', 'fall', '2002', 'inls259', '001'); insert into t_class values('123467', 'fall', '2002', 'inls165', '001'); insert into t_class values('123468', 'fall', '2002', 'inls349', '001'); set linesize 80; col clid format 999999; col semester format a10; col year format a10; col course_id heading 'course|id' format a10; col section format 009; /* describe t_class; */ /*###################################################### insert into class table*/ /* @h:/homework/inls258/finalproject/insert-class-location.txt*/ INSERT INTO t_class_time_stamp(cl_id, stime, etime, bldg_name, room, day) VALUES (123456, to_date('15:30','HH24:MI'),to_date('16:45','HH24:MI'),'Manning', '117','Monday'); INSERT INTO t_class_time_stamp(cl_id, stime, etime, bldg_name, room, day) VALUES (123456, to_date('15:30','HH24:MI'),to_date('16:45','HH24:MI'),'Manning', '307','Wednesday'); INSERT INTO t_class_time_stamp(cl_id, stime, etime, bldg_name, room, day) VALUES (123457,to_date('8:30','HH24:MI'), to_date('9:45','HH24:MI'),'Manning', '214','Tuesday'); INSERT INTO t_class_time_stamp(cl_id, stime, etime, bldg_name, room, day) VALUES (123457,to_date('8:30','HH24:MI'), to_date('9:45','HH24:MI'),'Manning', '214','Thursday'); INSERT INTO t_class_time_stamp(cl_id, stime, etime, bldg_name, room, day) VALUES (123458,to_date('12:30','HH24:MI'), to_date('13:45','HH24:MI'),'Manning', '214','Monday'); INSERT INTO t_class_time_stamp(cl_id, stime, etime, bldg_name, room, day) VALUES (123459,to_date('13:30','HH24:MI'),to_date('14:45','HH24:MI'),'Manning', '304','Wednesday'); INSERT INTO t_class_time_stamp(cl_id, stime, etime, bldg_name, room, day) VALUES (123459,to_date('13:30','HH24:MI'),to_date('14:45','HH24:MI'),'Manning', '117','Tuesday'); INSERT INTO t_class_time_stamp(cl_id, stime, etime, bldg_name, room, day) VALUES (123460,to_date('15:30','HH24:MI'),to_date('16:45','HH24:MI'),'Manning', '208','Thursday'); INSERT INTO t_class_time_stamp(cl_id, stime, etime, bldg_name, room, day) VALUES (123461,to_date('8:30','HH24:MI'), to_date('9:45','HH24:MI'), 'Manning', '307','Tuesday'); INSERT INTO t_class_time_stamp(cl_id, stime, etime, bldg_name, room, day) VALUES (123462, to_date('15:30','HH24:MI'), to_date('16:45','HH24:MI'),'Manning', '304','Wednesday'); INSERT INTO t_class_time_stamp(cl_id, stime, etime, bldg_name, room, day) VALUES (123463,to_date('10:30','HH24:MI'), to_date('11:45','HH24:MI'),'Manning', '117', 'Tuesday'); INSERT INTO t_class_time_stamp(cl_id, stime, etime, bldg_name, room, day) VALUES (123463,to_date('10:30','HH24:MI'), to_date('11:45','HH24:MI'),'Manning', '208', 'Thursday'); INSERT INTO t_class_time_stamp(cl_id, stime, etime, bldg_name, room, day) VALUES (123464,to_date('12:30','HH24:MI'), to_date('13:45','HH24:MI'),'Manning', '307', 'Wednesday'); INSERT INTO t_class_time_stamp(cl_id, stime, etime, bldg_name, room, day) VALUES (123465,to_date('15:30','HH24:MI'), to_date('16:45','HH24:MI'),'Manning', '215', 'Thursday'); INSERT INTO t_class_time_stamp(cl_id, stime, etime, bldg_name, room, day) VALUES (123466,to_date('18:30','HH24:MI'), to_date('20:45','HH24:MI'),'Manning', '208','Tuesday'); INSERT INTO t_class_time_stamp(cl_id, stime, etime, bldg_name, room, day) VALUES (123467,to_date('18:30','HH24:MI'), to_date('20:45','HH24:MI'),'Manning', '307','Wednesday'); INSERT INTO t_class_time_stamp(cl_id, stime, etime, bldg_name, room, day) VALUES (123468,to_date('14:30','HH24:MI'),to_date('17:45','HH24:MI'),'Connor 2345', '3025', 'Thursday'); /* #####################################################insert into faculty talbe*/ /* @h:/homework/inls258/finalproject/insert-faculty.txt*/ insert into t_faculty values(800000001, 'Joanne', 'Gard', 'Marshall','3434 Mason Farm Road', 'Chapel Hill', 'NC', 'USA', '27519','9199253625', '9199625854', 120000, 'Manning','111', to_date('1999-02-01','yyyy-mm-dd'), to_date('1999-02-01','yyyy-mm-dd'), 'National Science Foundation',to_date('1999-02-01','yyyy-mm-dd'), '', 'Full', '5'); insert into t_faculty values(800000002, 'David', '', 'Carr','333 Manning Drive', 'Durham', 'NC', 'USA', '27111','9191254551', '9191252252', '80000', 'Manning','205', to_date('2000-05-01','yyyy-mm-dd'), to_date('2000-05-01','yyyy-mm-dd'), 'National Special Library Association',to_date('2000-05-01','yyyy-mm-dd'), '','Full', '5'); insert into t_faculty values('800000003', 'Greg', '', 'Newby','343 Riverside Road', 'Chapel Hill', 'NC', 'USA', '27519','9191522252', '9194552552', '80000', 'Manning','308', to_date('1999-04-01','yyyy-mm-dd'), to_date('1999-04-01','yyyy-mm-dd'), 'National Science Foundation',to_date('1999-04-01','yyyy-mm-dd'), '','Full', '5'); insert into t_faculty values('800000004', 'Paul', '', 'Solomon','34343 Blueridge Road', 'Raleigh', 'NC', 'USA', '27519','9198858585', '9191452522', '100000', 'Manning','265', to_date('1999-06-01','yyyy-mm-dd'), to_date('1999-06-01','yyyy-mm-dd'), 'National Science Foundation',to_date('1999-06-01','yyyy-mm-dd'), '','Full', '5'); insert into t_faculty values('800000005', 'Bradley', 'M.', 'Hemminger','2233 Pinegate Circle', 'Chapel Hill', 'NC', 'USA', '27519','9191522252', '9194552552', '80000', 'Manning','308', to_date('1999-04-01','yyyy-mm-dd'), to_date('1999-04-01','yyyy-mm-dd'), 'National Science Foundation',to_date('1999-04-01','yyyy-mm-dd'), '','Full', '5'); insert into t_faculty values('800000006', 'Paul', '', 'Jones','222 Branson Street', 'Raleigh', 'NC', 'USA', '27519','9198858585', '9191452522', '100000', 'Manning','265', to_date('1999-06-01','yyyy-mm-dd'), to_date('1999-06-01','yyyy-mm-dd'), 'National Science Foundation',to_date('1999-06-01','yyyy-mm-dd'), '','Full', '5'); insert into t_faculty values('800000007', 'Robert', 'M.', 'Losee','333 Jordon Lake Side', 'Durham', 'NC', 'USA', '27519','9194885854', '9194788558', '60000', 'Manning','145', to_date('1999-12-01','yyyy-mm-dd'), to_date('1999-12-01','yyyy-mm-dd'), 'National Science Foundation',to_date('1999-12-01','yyyy-mm-dd'), '','Full', '5'); insert into t_faculty values('800000008', 'Kristin', '', 'Chaffin','4111 Mapel Avenue', 'Raleigh', 'NC', 'USA', '27454','919458652', '9192563325', '80000', 'Manning','205', to_date('1999-07-01','yyyy-mm-dd'), to_date('1999-07-01','yyyy-mm-dd'), 'National Science Foundation',to_date('1999-07-01','yyyy-mm-dd'),'','Adjunct', '5'); insert into t_faculty values('800000009', 'Jonghoon', '', 'Lee','785 Lake river road', 'Durham', 'NC', 'USA', '27519','9194885854', '9194788558', '60000', 'Manning','145', to_date('1999-12-01','yyyy-mm-dd'), to_date('1999-12-01','yyyy-mm-dd'), 'National Science Foundation',to_date('1999-12-01','yyyy-mm-dd'), '','Adjunct', '5'); set linesize 80; col FID format 999999999; col fname format a10; col mname format a3; col lname format a10; col address format a20 word_wrapped; col city format 9.9; col state format a10; col country format a5; col code format a5 col h_phone format a15; col o_phone format a15; col salary format 999999.99 col bldg format a15; col room format 9999; col grants format a20; col status format a10; col app_length format 99; /* describe t_faculty; */ /* ################################################# insert into financial aid talbe */ /* @h:/homework/inls258/finalproject/insert-financial-aid.txt */ insert into t_financial_aid values('12345', 'Graduate School Fellowship', 'Graduate School', 'GPA>3.5, for Ph.D student only', '9.0'); insert into t_financial_aid values('12346', 'Margaret Ellen Kalp Fellowship for Doctoral Study', 'SILS', 'GPA>3.5, for Ph.D student only', '9.0'); insert into t_financial_aid values('12347', 'Louis Round Wilson Fellowship', 'SILS', 'GPA>3.5, for Ph.D student only', '9.0'); insert into t_financial_aid values('12348', 'Graduate Assistantships', 'SILS', 'GPA>3.5, available to master''s students and Ph.D students', '9.0'); insert into t_financial_aid values('12349', 'Teaching Assistantships', 'SILS', 'GPA>3.5, available to master''s students and Ph.D students', '9.0'); set linesize 80; col FinId format 99999 col award format a25 word_wrapped; col source format a15; col criteria format a15 word_wrapped; col credithrs format 9.9 /* describe t_financial_aid; */ /* #######################################################University table */ INSERT INTO t_university (UnivID, u_name, city, state, country) VALUES (1,'UNC-CH','Chapel Hill', 'NC', 'USA'); INSERT INTO t_university (UnivID, u_name, city, state, country) VALUES (2,'Duke University','Durham', 'NC', 'USA'); INSERT INTO t_university (UnivID, u_name, city, state, country) VALUES (3,'Tianjin Univeristy','Tian Jin', '', 'P.R.China'); INSERT INTO t_university (UnivID, u_name, city, state, country) VALUES (4,'Brazil Univeristy','St. Paul', '', 'Brazil'); INSERT INTO t_university (UnivID, u_name, city, state, country) VALUES (5,'UC-Berkeley','Berkeley', 'CA', 'USA'); /* describe t_university; */ /* t_interest table */ INSERT INTO t_interest(IID, description, int_type) VALUES (1, 'LS', 'LS'); INSERT INTO t_interest(IID, description, int_type) VALUES (2, 'Academic Libraries', 'LS'); INSERT INTO t_interest(IID, description, int_type) VALUES (3, 'Academic Libraries: Reference', 'LS'); INSERT INTO t_interest(IID, description, int_type) VALUES (4, 'Academic Libraries: Cataloging', 'LS'); INSERT INTO t_interest(IID, description, int_type) VALUES (5, 'Academic Libraries: Collection', 'LS'); INSERT INTO t_interest(IID, description, int_type) VALUES (6, 'Academic Libraries: Administration', 'LS'); INSERT INTO t_interest(IID, description, int_type) VALUES (7, 'Academic Libraries: Systems', 'LS'); INSERT INTO t_interest(IID, description, int_type) VALUES (8, 'Archives and Cultural Heritage Info Management', 'LS'); INSERT INTO t_interest(IID, description, int_type) VALUES (9, 'Public Libraries', 'LS'); INSERT INTO t_interest(IID, description, int_type) VALUES (10, 'Public Libraries: Children', 'LS'); INSERT INTO t_interest(IID, description, int_type) VALUES (11, 'Public Libraries: Young Adult', 'LS'); INSERT INTO t_interest(IID, description, int_type) VALUES (12, 'Public Libraries: Adult', 'LS'); INSERT INTO t_interest(IID, description, int_type) VALUES (13, 'School Libraries', 'LS'); INSERT INTO t_interest(IID, description, int_type) VALUES (14, 'Special Libraries', 'LS'); INSERT INTO t_interest(IID, description, int_type) VALUES (15, 'Special Libraries: Corporation', 'LS'); INSERT INTO t_interest(IID, description, int_type) VALUES (16, 'Special Libraries: Medical', 'LS'); INSERT INTO t_interest(IID, description, int_type) VALUES (17, 'Special Libraries: Law', 'LS'); INSERT INTO t_interest(IID, description, int_type) VALUES (18, 'Special Libraries: Government', 'LS'); INSERT INTO t_interest(IID, description, int_type) VALUES (19, 'Library Automation', 'LS'); INSERT INTO t_interest(IID, description, int_type) VALUES (20, 'IS', 'IS'); INSERT INTO t_interest(IID, description, int_type) VALUES (21, 'Computer Human Interaction Design', 'IS'); INSERT INTO t_interest(IID, description, int_type) VALUES (22, 'Database and Information Retrieval Systems', 'IS'); INSERT INTO t_interest(IID, description, int_type) VALUES (23, 'Human Information Behavior', 'IS'); INSERT INTO t_interest(IID, description, int_type) VALUES (24, 'Management of Information System', 'IS'); INSERT INTO t_interest(IID, description, int_type) VALUES (25, 'Networking and Internet Technologies', 'IS'); INSERT INTO t_interest(IID, description, int_type) VALUES (26, 'Organization of Information/Information Architecture', 'IS'); INSERT INTO t_interest(IID, description, int_type) VALUES (27, 'User Support', 'IS'); INSERT INTO t_interest(IID, description, int_type) VALUES (28, 'Other', 'IS'); /* t_full_faculty table */ INSERT INTO t_full_faculty (full_fid, prev_review, next_review, tenure, rank, lst_leave, nxt_leave) VALUES (800000001, to_date('1998/08/01','YYYY/MM/DD'),to_date ('2003/08/01','YYYY/MM/DD'), 'Y', 'Professor',to_date('1999/05/03','YYYY/MM/DD'), to_date('2000/09/05','YYYY/MM/DD') ); INSERT INTO t_full_faculty (full_fid, prev_review, next_review, tenure, rank, lst_leave, nxt_leave) VALUES (800000002, to_date('1998/09/11','YYYY/MM/DD'),to_date ('2004/09/12','YYYY/MM/DD'), 'Y', 'Professor',to_date('2000/06/23','YYYY/MM/DD'), to_date('2001/10/05','YYYY/MM/DD') ); INSERT INTO t_full_faculty (full_fid, prev_review, next_review, tenure, rank, lst_leave, nxt_leave) VALUES (800000003, to_date('1999/10/21','YYYY/MM/DD'),to_date ('2004/10/21','YYYY/MM/DD'), 'Y', 'Associate Professor',to_date('2000/09/14','YYYY/MM/DD'), to_date('2001/09/08','YYYY/MM/DD') ); INSERT INTO t_full_faculty (full_fid, prev_review, next_review, tenure, rank, lst_leave, nxt_leave) VALUES (800000004, to_date('2000/12/01','YYYY/MM/DD'),to_date ('2005/12/01','YYYY/MM/DD'), 'Y', 'Associate Professor',to_date('2001/11/07','YYYY/MM/DD'), to_date('2002/05/11','YYYY/MM/DD') ); INSERT INTO t_full_faculty (full_fid, prev_review, next_review, tenure, rank, lst_leave, nxt_leave) VALUES (800000005, to_date('1999/05/01','YYYY/MM/DD'),to_date ('2003/05/01','YYYY/MM/DD'), 'Y', 'Instructor', to_date('1999/11/23','YYYY/MM/DD'), to_date('2000/09/05','YYYY/MM/DD') ); INSERT INTO t_full_faculty (full_fid, prev_review, next_review, tenure, rank, lst_leave, nxt_leave) VALUES (800000006, to_date('1999/04/15','YYYY/MM/DD'),to_date ('2004/08/01','YYYY/MM/DD'), 'Y', 'Assistant Professor',to_date('2000/06/03','YYYY/MM/DD'), to_date('2001/09/05','YYYY/MM/DD') ); INSERT INTO t_full_faculty (full_fid, prev_review, next_review, tenure, rank, lst_leave, nxt_leave) VALUES (800000007, to_date('1998/10/11','YYYY/MM/DD'),to_date ('2004/10/11','YYYY/MM/DD'), 'Y', 'Lecturer',to_date('2000/11/15','YYYY/MM/DD'), to_date('2000/11/15','YYYY/MM/DD') ); /* describe t_full_faculty; */ /* Applicant table */ /* t_attends table */ /* IS/Ls Interest */ /* Enrolled Student table */ /* financial_aid_student table */ /* t_enroll_student_class */ /* e_email table */ INSERT INTO t_applicant (PID, fname, mname, lname, p_address, p_city, p_state, p_code,p_country, c_address, c_city, c_state, c_code,c_country, bdate,h_phone, w_phone, residency, ethnic, gre_verbal, gre_quant, gre_analytical, sex, toefl, status, comments) VALUES (applicant_seq.NEXTVAL, 'Sonya','','Zhao','Chengdu NOrmal College', 'Chengdu', 'Sichuan','611930','P.R.China', '214-C', 'Chapel Hill', 'NC', '27514-2341', 'USA', to_date('12/23/1967','MM/DD/YYYY'), '01186285242423', '01186285242423', 'N', 'Asian', 635,654,632,'F', 600, 'Enrolled', ''); INSERT INTO t_attends (Univ_ID, App_ID, gpa,degree, major, st_date,end_date ) VALUES (3, applicant_seq.CURRVAL, 3.54, 'B.A.','Journalism', to_date('09/01/1994','MM/DD/YYYY' ), to_date ('07/04/1998','MM/DD/YYYY' )); INSERT INTO t_app_interest(AID, IID) VALUES (applicant_seq.CURRVAL, 21); INSERT INTO t_enrolled_student(PID, studyarea, program, sem_enrolled, advisor) VALUES (applicant_seq.CURRVAL, 'IS','MSIS','Spring','800000001' ); INSERT INTO t_financial_aid_student (fin_ID, stu_ID) VALUES (12345, 700000001); INSERT INTO t_financial_aid_student (fin_ID, stu_ID) VALUES (12346, 700000001); INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123456,700000001) ; INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123457,700000001) ; INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123458,700000001) ; INSERT INTO t_app_email(APPID, EMAIL) VALUES (applicant_seq.CURRVAL,'zhaol@yahoo.com'); INSERT INTO t_app_email(APPID, EMAIL) VALUES (applicant_seq.CURRVAL,'zhaol@email.unc.edu'); INSERT INTO t_applicant (PID, fname, mname, lname, p_address, p_city, p_state, p_code,p_country, c_address, c_city, c_state, c_code,c_country, bdate,h_phone, w_phone, residency, ethnic, gre_verbal, gre_quant, gre_analytical, sex, toefl, status, comments) VALUES (applicant_seq.NEXTVAL, 'Sunny','','Zhou','WanXin Cun 4-18', 'Tianjin', '','600012','P.R.China', 'Pinegate', 'Chapel Hill', 'NC', '27514-2343', 'USA', to_date('10/21/1976','MM/DD/YYYY'), '011862275432257', '011862275432257', 'N', 'Asian', 665,674,732,'F', 620, 'Enrolled', ''); INSERT INTO t_attends (Univ_ID, App_ID, gpa,degree, major, st_date,end_date ) VALUES (3, applicant_seq.CURRVAL, 3.78, 'B.A.','English', to_date('09/01/1992','MM/DD/YYYY' ), to_date ('07/03/1996','MM/DD/YYYY' )); INSERT INTO t_app_interest(AID, IID) VALUES (applicant_seq.CURRVAL, 25); INSERT INTO t_enrolled_student( PID, studyarea, program, sem_enrolled, advisor) VALUES (applicant_seq.CURRVAL, 'IS','MSIS','Fall','800000002' ); INSERT INTO t_financial_aid_student (fin_ID, stu_ID) VALUES (12347, 700000002); INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123456,700000002) ; INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123457,700000002) ; INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123459,700000002) ; INSERT INTO t_app_email(APPID, EMAIL) VALUES (applicant_seq.CURRVAL,'zhoul@yahoo.com'); INSERT INTO t_app_email(APPID, EMAIL) VALUES (applicant_seq.CURRVAL,'zhoul@email.unc.edu'); INSERT INTO t_applicant (PID, fname, mname, lname, p_address, p_city, p_state, p_code,p_country, c_address, c_city, c_state, c_code,c_country, bdate,h_phone, w_phone, residency, ethnic, gre_verbal, gre_quant, gre_analytical, sex, toefl, status, comments) VALUES (applicant_seq.NEXTVAL, 'Helen','','Wen','Fulin Postal Office', 'Fulin', 'Sichuan','624754','P.R.China', '321-D', 'Chapel Hill', 'NC', '27514-2341', 'USA', to_date('08/23/1974','MM/DD/YYYY'), '011862723458765', '011862723458765', 'N', 'Asian', 645,650,634,'F', 610, 'Enrolled', ''); INSERT INTO t_attends (Univ_ID, App_ID, gpa,degree, major, st_date,end_date ) VALUES (3, applicant_seq.CURRVAL, 3.75, 'B.S.','Computer', to_date('09/01/1991','MM/DD/YYYY' ), to_date ('07/05/1995','MM/DD/YYYY' )); INSERT INTO t_app_interest(AID, IID) VALUES (applicant_seq.CURRVAL, 22); INSERT INTO t_enrolled_student(PID, studyarea, program, sem_enrolled, advisor) VALUES (applicant_seq.CURRVAL, 'IS','Ph.D.','Fall','800000002' ); INSERT INTO t_financial_aid_student (fin_ID, stu_ID) VALUES (12347, 700000003); INSERT INTO t_financial_aid_student (fin_ID, stu_ID) VALUES (12348, 700000003); INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123457,700000003) ; INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123458,700000003) ; INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123460,700000003) ; INSERT INTO t_app_email(APPID, EMAIL) VALUES (applicant_seq.CURRVAL,'wen@yahoo.com'); INSERT INTO t_app_email(APPID, EMAIL) VALUES (applicant_seq.CURRVAL,'wen@email.unc.edu'); INSERT INTO t_applicant (PID, fname, mname, lname, p_address, p_city, p_state, p_code,p_country, c_address, c_city, c_state, c_code,c_country, bdate,h_phone, w_phone, residency, ethnic, gre_verbal, gre_quant, gre_analytical, sex, toefl, status, comments) VALUES (applicant_seq.NEXTVAL, 'Sean','R','Boots','#150 office street', 'midsea', 'midsea','643783','Trinidad', 'fox road Apt.45', 'Chapel Hill', 'NC', '27514-2751', 'USA', to_date('09/08/74','MM/DD/YYYY'), '01156423634324', '01156423634324', 'N', 'African American', 600,530,589,'M', 578, 'Enrolled', ''); INSERT INTO t_attends (Univ_ID, App_ID, gpa,degree, major, st_date,end_date ) VALUES (1, applicant_seq.CURRVAL, 3.56, 'B.S.','Library Science', to_date('08/21/1995','MM/DD/YYYY' ), to_date ('05/15/1999','MM/DD/YYYY' )); INSERT INTO t_app_interest(AID, IID) VALUES (applicant_seq.CURRVAL, 22); INSERT INTO t_enrolled_student(PID, studyarea, program, sem_enrolled, advisor) VALUES (applicant_seq.CURRVAL, 'IS','MSIS','Fall','800000003' ); INSERT INTO t_financial_aid_student (fin_ID, stu_ID) VALUES (12349, 700000004); INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123460,700000004) ; INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123461,700000004) ; INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123462,700000004) ; INSERT INTO t_app_email(APPID, EMAIL) VALUES (applicant_seq.CURRVAL,'sean@yahoo.com'); INSERT INTO t_app_email(APPID, EMAIL) VALUES (applicant_seq.CURRVAL,'sean@email.unc.edu'); INSERT INTO t_applicant (PID, fname, mname, lname, p_address, p_city, p_state, p_code,p_country, c_address, c_city, c_state, c_code,c_country, bdate,h_phone, w_phone, residency, ethnic, gre_verbal, gre_quant, gre_analytical, sex, toefl, status, comments) VALUES (applicant_seq.NEXTVAL, 'Andrew','M','Phip','UNC-CH', 'Chapel Hill', 'NC','27514','USA', '114 Road', 'Chapel Hill', 'NC', '27514-2334', 'USA', to_date('10/21/1970','MM/DD/YYYY'), '9196534564', '9196534564', 'Y', 'Eastern European', 615,604,622,'M', '', 'Enrolled', ''); INSERT INTO t_attends (Univ_ID, App_ID, gpa,degree, major, st_date,end_date ) VALUES (1, applicant_seq.CURRVAL, 3.67, 'B.A.','Business', to_date('08/21/1994','MM/DD/YYYY' ), to_date ('05/15/1999','MM/DD/YYYY' )); INSERT INTO t_app_interest(AID, IID) VALUES (applicant_seq.CURRVAL, 24); INSERT INTO t_enrolled_student(PID, studyarea, program, sem_enrolled, advisor) VALUES (applicant_seq.CURRVAL, 'IS','MSIS','Spring','800000004' ); INSERT INTO t_financial_aid_student (fin_ID, stu_ID) VALUES (12346, 700000005); INSERT INTO t_financial_aid_student (fin_ID, stu_ID) VALUES (12347, 700000005); INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123463,700000005) ; INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123464,700000005) ; INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123465,700000005) ; INSERT INTO t_app_email(APPID, EMAIL) VALUES (applicant_seq.CURRVAL,'phip@yahoo.com'); INSERT INTO t_app_email(APPID, EMAIL) VALUES (applicant_seq.CURRVAL,'phip@email.unc.edu'); INSERT INTO t_applicant (PID, fname, mname, lname, p_address, p_city, p_state, p_code,p_country, c_address, c_city, c_state, c_code,c_country, bdate,h_phone, w_phone, residency, ethnic, gre_verbal, gre_quant, gre_analytical, sex, toefl, status, comments) VALUES (applicant_seq.NEXTVAL, 'Jeff','W','Hurbert','UNC-CH', 'Chapel Hill', 'NC','27514-3214','USA', 'Manning Dr.', 'Chapel Hill', 'NC', '27514-2341', 'USA', to_date('08/23/1957','MM/DD/YYYY'), '9196548712', '9196548712', 'Y', 'African American', 575,614,631,'M', '', 'Enrolled', ''); INSERT INTO t_attends (Univ_ID, App_ID, gpa,degree, major, st_date,end_date ) VALUES (1, applicant_seq.CURRVAL, 3.58, 'B.A.','Mass Medium', to_date('08/17/1993','MM/DD/YYYY' ), to_date ('05/21/1997','MM/DD/YYYY' )); INSERT INTO t_app_interest(AID, IID) VALUES (applicant_seq.CURRVAL, 3); INSERT INTO t_enrolled_student(PID, studyarea, program, sem_enrolled, advisor) VALUES (applicant_seq.CURRVAL,'LS','MSLS','Fall','800000005' ); INSERT INTO t_financial_aid_student (fin_ID, stu_ID) VALUES (12345, 700000006); INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123466,700000006) ; INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123467,700000006) ; INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123468,700000006) ; INSERT INTO t_app_email(APPID, EMAIL) VALUES (applicant_seq.CURRVAL,'hurbert@yahoo.com'); INSERT INTO t_applicant (PID, fname, mname, lname, p_address, p_city, p_state, p_code,p_country, c_address, c_city, c_state, c_code,c_country, bdate,h_phone, w_phone, residency, ethnic, gre_verbal, gre_quant, gre_analytical, sex, toefl, status, comments) VALUES (applicant_seq.NEXTVAL, 'Chelsea','K','Lee','Brazil University', 'Blue Sky', 'Blue Sky','524242','Brazil', '#654 RD.', 'Blue Sky', 'Yellow Sky', '534242', 'Brazil', to_date('10/20/1970','MM/DD/YYYY'), '01165635342', '01165635342', 'N', 'European', 575,594,612,'M', 609, 'Enrolled', ''); INSERT INTO t_attends (Univ_ID, App_ID, gpa,degree, major, st_date,end_date ) VALUES (4, applicant_seq.CURRVAL, 3.81, 'B.S.','Maths', to_date('09/10/1994','MM/DD/YYYY' ), to_date ('07/20/1998','MM/DD/YYYY' )); INSERT INTO t_app_interest(AID, IID) VALUES (applicant_seq.CURRVAL, 12); INSERT INTO t_enrolled_student(PID, studyarea, program, sem_enrolled, advisor) VALUES (applicant_seq.CURRVAL, 'LS','MSLS','Fall','800000005' ); INSERT INTO t_financial_aid_student (fin_ID, stu_ID) VALUES (12348, 700000007); INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123460,700000007) ; INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123461,700000007) ; INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123463,700000007) ; INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123464,700000007) ; INSERT INTO t_app_email(APPID, EMAIL) VALUES (applicant_seq.CURRVAL,'lee@yahoo.com'); INSERT INTO t_applicant (PID, fname, mname, lname, p_address, p_city, p_state, p_code,p_country, c_address, c_city, c_state, c_code,c_country, bdate,h_phone, w_phone, residency, ethnic, gre_verbal, gre_quant, gre_analytical, sex, toefl, status, comments) VALUES (applicant_seq.NEXTVAL, 'Tom','K','Cruise','UC Berkeley', 'Berkeley', 'CA','735352','USA', 'Rose Street', 'Chapel Hill', 'NC', '27453-6353', 'USA', to_date('05/20/1978','MM/DD/YYYY'), '6546324232', '6546324232', 'Y', 'European', 600,594,621,'M', '', 'Enrolled', ''); INSERT INTO t_attends (Univ_ID, App_ID, gpa,degree, major, st_date,end_date ) VALUES (5, applicant_seq.CURRVAL, 3.80, 'B.A.','Sociology', to_date('01/17/1994','MM/DD/YYYY' ), to_date ('12/15/1998','MM/DD/YYYY' )); INSERT INTO t_app_interest(AID, IID) VALUES (applicant_seq.CURRVAL, 13); INSERT INTO t_enrolled_student(PID, studyarea, program, sem_enrolled, advisor) VALUES (applicant_seq.CURRVAL, 'LS','MSLS','Fall','800000006' ); INSERT INTO t_financial_aid_student (fin_ID, stu_ID) VALUES (12349, 700000008); INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123457,700000008) ; INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123460,700000008) ; INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123462,700000008) ; INSERT INTO t_enroll_student_class(class_ID, stud_ID) VALUES (123465,700000008) ; INSERT INTO t_app_email(APPID, EMAIL) VALUES (applicant_seq.CURRVAL,'cruise@yahoo.com'); INSERT INTO t_applicant (PID, fname, mname, lname, p_address, p_city, p_state, p_code,p_country, c_address, c_city, c_state, c_code,c_country, bdate,h_phone, w_phone, residency, ethnic, gre_verbal, gre_quant, gre_analytical, sex, toefl, status, comments) VALUES (applicant_seq.NEXTVAL, 'Nancy','R','Wilson','CA University', 'Berkeley', 'CA','53332-7654','USA', 'Franklin Street', 'Washington D.C.', '', '36353-7353', 'USA', to_date('11/21/1987','MM/DD/YYYY'), '8346543212', '8346543212', 'Y', 'Eastern European', 615,454,432,'F', '', 'Denied', 'GRE grade is too low'); INSERT INTO t_attends (Univ_ID, App_ID, gpa,degree, major, st_date,end_date ) VALUES (5, applicant_seq.CURRVAL, 3.71, 'B.A.','History', to_date('08/20/1992','MM/DD/YYYY' ), to_date ('05/10/1996','MM/DD/YYYY' )); INSERT INTO t_app_email(APPID, EMAIL) VALUES (applicant_seq.CURRVAL,'wilson@yahoo.com'); INSERT INTO t_applicant (PID, fname, mname, lname, p_address, p_city, p_state, p_code,p_country, c_address, c_city, c_state, c_code,c_country, bdate,h_phone, w_phone, residency, ethnic, gre_verbal, gre_quant, gre_analytical, sex, toefl, status, comments) VALUES (applicant_seq.NEXTVAL, 'anity','J','tyriew','#574 Street', 'St.Paul', 'St.Paul','642432','Brazil', '#574 Street', 'St.Paul', 'St.Paul', '642432', 'Brazil', to_date('11/23/1967','MM/DD/YYYY'), '011653423456', '011653423456', 'N', 'European', 555,642,612,'M', 610, 'Deferred', 'Take one year off to do individual research'); INSERT INTO t_attends (Univ_ID, App_ID, gpa,degree, major, st_date,end_date ) VALUES (4, applicant_seq.CURRVAL, 3.70, 'B.A.','Information Science', to_date('09/25/1990','MM/DD/YYYY' ), to_date ('07/15/1994','MM/DD/YYYY' )); INSERT INTO t_app_email(APPID, EMAIL) VALUES (applicant_seq.CURRVAL,'tyriew@yahoo.com'); INSERT INTO t_applicant (PID, fname, mname, lname, p_address, p_city, p_state, p_code,p_country, c_address, c_city, c_state, c_code,c_country, bdate,h_phone, w_phone, residency, ethnic, gre_verbal, gre_quant, gre_analytical, sex, toefl, status, comments) VALUES (applicant_seq.NEXTVAL, 'Qi','','Chen','Tianjin University', 'Tianjin', 'Tianjin','615242','P.R.China', '224-D', 'Chapel Hill', 'NC', '27514-2341', 'USA', to_date('10/23/1972','MM/DD/YYYY'), '9196734567', '9196734567', 'N', 'Asian', 635,623,622,'F', 610, 'Withdrawn', 'Have already enrolled in Duke University'); INSERT INTO t_attends (Univ_ID, App_ID, gpa,degree, major, st_date,end_date ) VALUES (3, applicant_seq.CURRVAL, 3.75, 'B.S.','Chemistry', to_date('09/01/1989','MM/DD/YYYY' ), to_date ('07/04/1993','MM/DD/YYYY' )); INSERT INTO t_app_email(APPID, EMAIL) VALUES (applicant_seq.CURRVAL,'chen@yahoo.com'); INSERT INTO t_applicant (PID, fname, mname, lname, p_address, p_city, p_state, p_code,p_country, c_address, c_city, c_state, c_code,c_country, bdate,h_phone, w_phone, residency, ethnic, gre_verbal, gre_quant, gre_analytical, sex, toefl, status, comments) VALUES (applicant_seq.NEXTVAL, 'Tracy','L','Hamminger','Duke Unviersity', 'Durham', 'NC','28754-8756','USA', 'Mason Farm Rd.', 'Durham', 'NC', '27545-8741', 'USA', to_date('09/23/1974','MM/DD/YYYY'), '9196549876', '9196549876', 'Y', 'African American', 615,614,617,'F', '', 'Withdrawn', 'Got a job before the notification of admission'); INSERT INTO t_attends (Univ_ID, App_ID, gpa,degree, major, st_date,end_date ) VALUES (2, applicant_seq.CURRVAL, 3.67, 'B.S.','Physics', to_date('08/17/1989','MM/DD/YYYY' ), to_date ('05/21/1993','MM/DD/YYYY' )); INSERT INTO t_app_email(APPID, EMAIL) VALUES (applicant_seq.CURRVAL,'hamminger@yahoo.com'); /* describe t_applicant; */ /* describe t_attends; */ /* describe t_interest; */ /* describe t_app_interest; */ /* describe t_enrolled_student; */ /* describe t_financial_aid_student; */ /* describe t_enroll_student_class; */ /* describe t_app_email; */ /* t_faculty_teach_class table */ INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000001, 123456); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000002, 123457); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000003, 123458); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000004, 123459); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000005, 123460); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000006, 123461); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000007, 123462); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000008, 123463); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000009, 123464); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000001, 123465); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000002, 123466); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000003, 123467); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000004, 123468); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000005, 123456); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000002, 123456); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000004, 123457); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000005, 123458); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000006, 123459); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000007, 123460); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000008, 123461); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000009, 123463); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000002, 123464); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000008, 123456); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000004, 123458); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000003, 123460); INSERT INTO t_faculty_teach_class (f_ID, cl_id) VALUES (800000005, 123465); /* describe t_faculty_teach_class; */ /* select * from t_course; */ /* select * from t_class; */ /* select to_char(stime, 'HH24:MI'), to_char(etime, 'HH24:MI'), cl_id from t_class_time; */ /* select * from t_class_location; */ /* select * from t_class_day; */ /* select * from t_faculty; */ /* select * from t_financial_aid; */ /* select * from t_faculty_teach_class; */ /* select * from t_university; */ /* select * from t_full_faculty; */ /* select * from t_applicant; */ /* select * from t_attends; */ /* select * from t_interest; */ /* select * from t_app_interest; */ /* select * from t_enrolled_student; */ /* select * from t_financial_aid_student; */ /* select * from t_enroll_student_class; */ /* select * from t_app_email; */