Create the database and insert the data in the tables using either SQLServer, MySQL, or Oracle

Show all necessary SQL statements to create the tables and insert the data in the tables. Choose the appropriate data types (i.e., domains) for the attributes.

Transcribed Image Text:

CID CALLID CNAME CCREDIT Field Name COURSE Data Type AutoNumber Short Text Short Text Number Description (Optional) primary key + + + + + CID CALLID MIS 101 2 MIS 301 3 MIS 441 4 CS 155 5 MIS 451 COURSE CNAME Intro. to Info. Systems Sytems Analysis Database Management Programming in C++ Client/Server Systems CCREDIT T C 3 3 3 3 3 TERMID TDESC STATUS Field Name TERM Data Type AutoNumber Short Text Short Text Description (Optional) primary key X + + + + + + TERMID TDESC Fall 2001 2 Spring 2002 3 Summer 2002 4 Fall 2002 5 Spring 2003 6 Summer 2003 TERM STATUS CLOSED CLOSED CLOSED CLOSED CLOSED OPEN Field Name LOCID BLDG_CODE ROOM CAPACITY LOCATION Data Type AutoNumber Short Text Short Text Number Description (Optional) primary key D + + + + + + + + + + + + LOCID BLDG_CODE CR 2 CR 3 CR 4 CR 5 BUS 6 BUS 7 BUS 8 BUS 9 BUS 10 11 12 LIB 13 LIB BUS BUS LOCATION ROOM 101 202 103 105 105 404 421 211 424 402 433 217 222 CAPACITY 150 40 35 35 42 35 35 55 1 1 1 2 1 Click to Add FRANKID FRANKDESC FRANKID ADJ ASSO ASST FULL INST FID FLNAME FFNAME FMI LOCID Field Name FPHONE FRANKID FPIN FID FACULTYIMAGE FRANK Field Name - FRANKDESC- Adjunct Associate Assistant Full Instructor FLNAME. Cox 2 Blanchard 3 Williams 4 Sheng 5 Brown FFNAME Kim John Jerry Laura Phillip Short Text Short Text R F Data Type M E FACULTY AutoNumber Short Text Short Text Short Text Number Short Text Short Text Number Short Text FMI Data Type FACULTY LOCID Description (Optional) primary key Description (Optional) primary key foreign key foreign key FPHONE 9 (715) 555-1234 ASSO 10 (715) 555-9087 FULL 12 (715) 555-5412 ASST 11 (715) 555-6409 INST 13 (715) 555-6082 ASSO FRANKID FPIN - FACULTYIMA. 1181 cox.jpg 1075 blanchard.jpg 8531 williams.jpg 1690 sheng.jpg $899 brown.jpg www... 508 SID SLNAME SFNAME SMI SADD SCITY SSTATE SZIP SPHONE SDOB SCLASS SPIN FID 2 Umato 5 Sanche Connely CSECID CID TERMID SECNUM FID DAY TIME LOCID Field Name M D MAXENRL CURRENRL Daniel J Amanda Ruben A Michael 5 SMI DI Field Name 144 STUDENT Data Type AutoNumber Short Text Short Text Short Text Short Text Short Text Short Text Short Text Short Text Date/Time Short Text Number Number MADD Cance Drive 1716 Summ 1790 Samantha Court 1818 Silver Street STUDENT SCITY STATE WI WI Boomer Eau Claire WI WI Eau Claire W W Ek Mound AutoNumber Number Number Number Number Short Text Date/Time Number Number Number STIP 54701 COURSE_SECTION Data Type 5475 SA 547 Description (Optional) primary key foreign key SPHONE SOOB SCLASS (783) 595-97 7/14/10 (755-2345 // (741-19 (705-400 (755- (725-444 12/4/19 // 11/200 primary key foreign key foreign key foreign key SPIN foreign key 12:30 3001 Description (Optional) 341 4400 9100 FID 1 + + + + + + + + + + + CSECID 1 2 3 4 5 6 7 8 9 10 11 12 13 CID ▾ 1 1 1 2 2 3 3 4 5 5 1 2 3 TERMID ▾ SECNUM ▾ 4 4 4 4 5 5 5 5 5 5 6 6 6 1 2 3 1 2 1 2 1 1 2 1 1 1 COURSE SECTION FID DAY 2 MWF 3 TTH 3 M 4 TTH 4 TTH 1 MWF 1 MW 5 TTH 2 MWF 2 TH 1 M-F M-F M-F TIME 10:00:00 AM 9:30:00 AM 6:00:00 PM 11:00:00 AM 2:00:00 PM 9:00:00 AM 5:00:00 PM 8:00:00 AM 2:00:00 PM 6:00:00 PM 8:00:00 AM 8:00:00 AM 9:00:00 AM LOCID 1 7 2 6 6 5 5 3 5 5 1 6 5 MAXENRL ▾ 140 35 35 35 35 30 30 35 35 35 50 35 35 CURRENRL Click ▾ 135 35 32 35 35 25 28 10 32 35 35 35 29 BEB SID SID CSECID GRADE 1 1 1 2 2 2 2 3 3 3 4 4 5 5 5 5 6 6 ENROLLMENT CSECID Field Name 1 A 4 A 6 B 9 B 1 C 5 B 6 A 9 B 1 C 12 13 11 12 1 B 5 C 9C 13 11 12 GRADE ENROLLMENT Data Type Number Number Short Text Description (Optional) primary key/foreign key primary key/foreign key CID CALLID CNAME CCREDIT Field Name COURSE Data Type AutoNumber Short Text Short Text Number Description (Optional) primary key + + + + + CID CALLID MIS 101 2 MIS 301 3 MIS 441 4 CS 155 5 MIS 451 COURSE CNAME Intro. to Info. Systems Sytems Analysis Database Management Programming in C++ Client/Server Systems CCREDIT T C 3 3 3 3 3 TERMID TDESC STATUS Field Name TERM Data Type AutoNumber Short Text Short Text Description (Optional) primary key X + + + + + + TERMID TDESC Fall 2001 2 Spring 2002 3 Summer 2002 4 Fall 2002 5 Spring 2003 6 Summer 2003 TERM STATUS CLOSED CLOSED CLOSED CLOSED CLOSED OPEN Field Name LOCID BLDG_CODE ROOM CAPACITY LOCATION Data Type AutoNumber Short Text Short Text Number Description (Optional) primary key D + + + + + + + + + + + + LOCID BLDG_CODE CR 2 CR 3 CR 4 CR 5 BUS 6 BUS 7 BUS 8 BUS 9 BUS 10 11 12 LIB 13 LIB BUS BUS LOCATION ROOM 101 202 103 105 105 404 421 211 424 402 433 217 222 CAPACITY 150 40 35 35 42 35 35 55 1 1 1 2 1 Click to Add FRANKID FRANKDESC FRANKID ADJ ASSO ASST FULL INST FID FLNAME FFNAME FMI LOCID Field Name FPHONE FRANKID FPIN FID FACULTYIMAGE FRANK Field Name - FRANKDESC- Adjunct Associate Assistant Full Instructor FLNAME. Cox 2 Blanchard 3 Williams 4 Sheng 5 Brown FFNAME Kim John Jerry Laura Phillip Short Text Short Text R F Data Type M E FACULTY AutoNumber Short Text Short Text Short Text Number Short Text Short Text Number Short Text FMI Data Type FACULTY LOCID Description (Optional) primary key Description (Optional) primary key foreign key foreign key FPHONE 9 (715) 555-1234 ASSO 10 (715) 555-9087 FULL 12 (715) 555-5412 ASST 11 (715) 555-6409 INST 13 (715) 555-6082 ASSO FRANKID FPIN - FACULTYIMA. 1181 cox.jpg 1075 blanchard.jpg 8531 williams.jpg 1690 sheng.jpg $899 brown.jpg www... 508 SID SLNAME SFNAME SMI SADD SCITY SSTATE SZIP SPHONE SDOB SCLASS SPIN FID 2 Umato 5 Sanche Connely CSECID CID TERMID SECNUM FID DAY TIME LOCID Field Name M D MAXENRL CURRENRL Daniel J Amanda Ruben A Michael 5 SMI DI Field Name 144 STUDENT Data Type AutoNumber Short Text Short Text Short Text Short Text Short Text Short Text Short Text Short Text Date/Time Short Text Number Number MADD Cance Drive 1716 Summ 1790 Samantha Court 1818 Silver Street STUDENT SCITY STATE WI WI Boomer Eau Claire WI WI Eau Claire W W Ek Mound AutoNumber Number Number Number Number Short Text Date/Time Number Number Number STIP 54701 COURSE_SECTION Data Type 5475 SA 547 Description (Optional) primary key foreign key SPHONE SOOB SCLASS (783) 595-97 7/14/10 (755-2345 // (741-19 (705-400 (755- (725-444 12/4/19 // 11/200 primary key foreign key foreign key foreign key SPIN foreign key 12:30 3001 Description (Optional) 341 4400 9100 FID 1 + + + + + + + + + + + CSECID 1 2 3 4 5 6 7 8 9 10 11 12 13 CID ▾ 1 1 1 2 2 3 3 4 5 5 1 2 3 TERMID ▾ SECNUM ▾ 4 4 4 4 5 5 5 5 5 5 6 6 6 1 2 3 1 2 1 2 1 1 2 1 1 1 COURSE SECTION FID DAY 2 MWF 3 TTH 3 M 4 TTH 4 TTH 1 MWF 1 MW 5 TTH 2 MWF 2 TH 1 M-F M-F M-F TIME 10:00:00 AM 9:30:00 AM 6:00:00 PM 11:00:00 AM 2:00:00 PM 9:00:00 AM 5:00:00 PM 8:00:00 AM 2:00:00 PM 6:00:00 PM 8:00:00 AM 8:00:00 AM 9:00:00 AM LOCID 1 7 2 6 6 5 5 3 5 5 1 6 5 MAXENRL ▾ 140 35 35 35 35 30 30 35 35 35 50 35 35 CURRENRL Click ▾ 135 35 32 35 35 25 28 10 32 35 35 35 29 BEB SID SID CSECID GRADE 1 1 1 2 2 2 2 3 3 3 4 4 5 5 5 5 6 6 ENROLLMENT CSECID Field Name 1 A 4 A 6 B 9 B 1 C 5 B 6 A 9 B 1 C 12 13 11 12 1 B 5 C 9C 13 11 12 GRADE ENROLLMENT Data Type Number Number Short Text Description (Optional) primary key/foreign key primary key/foreign key

Answer rating: 100% (QA)

ORACLE SQL Develop... View the full answer