Create the database and insert the data in the tables using either SQLServer, MySQL, or Oracle Show
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Related Book For
Database Systems Design Implementation and Management
ISBN: 978-1285196145
11th edition
Authors: Carlos Coronel, Steven Morris
Posted Date:
Students also viewed these databases questions
-
Choose Oracle data types for the attributes in the normalized relations in Figure 5-4b. DBMS you are using is Oracle. If that is not the case, feel free to modify the question for the DBMS...
-
A project needs to be accomplished in a year with the total project costs of RM100,000. After six months of its implementation, it was found that the project had utilized RM60,000 with only 40% of...
-
a. Write a SQL query that would enable the user 'ww10_StaffMember' to view all of the data in the ww10_student table. 1b. (1 query) Assuming the SQL query from #5 has executed, write a SQL query that...
-
Ames Manufacturing Plant produces two different replacement parts for dishwashers. During a normal shift, they have 7 hours of time available on their main fabrication machine. The machine will...
-
Hartford Publishing Company (HPC) specializes in international business news publications. Its principal product is HPC-Monthly, which is mailed to subscribers the first week of each month. A weekly...
-
This is a more difficult but informative problem. James Brodrick & Sons, Inc. is growing rapidly and, if at all possible, would like to finance its growth without selling new equity. Selected...
-
You need to understand the approach described in question 3 in More Genetic TIPS before answering this question. A gene that is normally expressed in pancreatic cells was cloned and then subjected to...
-
BONDS ISSUED AT FACE VALUE Ito Co. issued the following bonds: Date of issue and sale: ........April 1, 20-1 Principal amount: ..........$300,000 Sale price of bonds: .........100 Denomination of...
-
1.) Pineapple Inc. issued a common stock for $30,000 and ended the period with net cash from financing of -$5,000. If the only other financing company was a payment of cash dividend, what is the...
-
For each of the following employees, calculate the Social Security tax for the weekly pay period described: For simplicity, all calculations throughout this exercise, both intermediate and final,...
-
Write a paper on the topic Impact of Play to infants concerning early childhood pedagogy.
-
A car consumes 1 3 . 2 5 gallons of fuel when driving a distance of 4 0 0 . 0 miles. How many liters of gasoline will it consume when driving 7 7 5 . 0 kilometers?
-
RDT&EN (COMPOSITE) Research, Development, Test & Evaluation, Navy (1319) NAVY Base Year = 2015 Raw Fiscal Year Index Weighted Index 2012 0.9603 2013 0.9746 2014 0.9891 2015 1.0000 2016 1.0120 2017...
-
An Italiano Expresso Machine retails for $999.99. Coffee R Us is giving a 35% discount on their model. If there is an 8.5% sales tax, how much will you actually pay for the coffee machine after the...
-
1) A brick building stands 130 ft tall. Each brick weighs 10 lb and has dimensions of 8 in. 4 in. 2in. What is the stress on the bottom layer of bricks? How tall could a building be before the...
-
Assume Andys and Helens behavior at home is partially regulated by their condominium association, which acts as a small voluntary government for its residents. a) Per the Coase Theorem, how might the...
-
Determine the equation of the parabola graphed below. Note: be sure to consider the negative sign already present in the template equation when entering your answer. 3 43 210 2 3 4 5 -2
-
Grace is training to be an airplane pilot and must complete five days of flying training in October with at least one day of rest between trainings. How many ways can Grace schedule her flying...
-
When implementing a 1:1 relationship, where should you place the foreign key if one side is mandatory and one side is optional? Should the foreign key be mandatory or optional?
-
Create a trigger named trg_pic_hours that will automatically update the PILOT table when a new CREW row is added and the CREW table uses a pilot CREW_JOB entry. Use the CHARTER tables...
-
Write the business rules reflected in this ERD.
-
When facilitating the methylation or pseudouridylation of an rRNA, a snoRNA functions as a. a decoy. b. a scaffold. c. a guide. d. both b and c.
-
Suppose that the overexpression of a particular miRNA was associated with pancreatic cancer. Which of the following agents might be effective in treating this type of cancer? a. Enoxacin b. A DNA...
-
When an ncRNA functions as a decoy, it a. contains binding sites for many different proteins, thereby promoting the formation of a large complex. b. recognizes other ncRNAs and sequesters them,...
Study smarter with the SolutionInn App