Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Write SQL commands to create a database and add data to them.   There will be two tables: Courses and Sections CourseNo --> Credits, Title CRN --> CourseNo, Sec, Campus, Days, MeetingTime, Capacity, Actual, Remaining, Instructor, StartDate, EndDate, Location The table design requirements are as follows (refer to picture with dark background).   -Create SQL commands to create the two tables.  -Import the data shown in the other picture into the two tables.

Write SQL commands to create a database and add data to them.   There will be two tables: Courses and Sections CourseNo --> Credits, Title CRN --> CourseNo, Sec, Campus, Days, MeetingTime, Capacity, Actual, Remaining, Instructor, StartDate, EndDate, Location The table design requirements are as follows (refer to picture with dark background).   -Create SQL commands to create the two tables.  -Import the data shown in the other picture into the two tables.

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

Write SQL commands to create a database and add data to them.  

There will be two tables: Courses and Sections

CourseNo --> Credits, Title

CRN --> CourseNo, Sec, Campus, Days, MeetingTime, Capacity, Actual, Remaining, Instructor, StartDate, EndDate, Location

The table design requirements are as follows (refer to picture with dark background).

 

-Create SQL commands to create the two tables. 

-Import the data shown in the other picture into the two tables.

5 5 7 CRN 3 9 O 1 2 3 4 5 6 7 8 9 30 #1 A B Course 10246 CSC 101 11023 CSC 101 10247 CSC 125 10887 CSC 125 11041 CSC 145 12921 CSC 145 10248 CSC 199 10254 CSC 199 10255 CSC 199 12771 CSC 199 10249 CSC 199L LA 10250 CSC 199L LB 10251 CSC 199L LC 10252 CSC 199L LD 10253 CSC 199L LE 11663 CSC 232 12203 CSC 233 11606 CSC 275 11021 CSC 300 11607 CSC 325 11022 CSC 345 13564 CSC 385 12901 CSC 410 14241 CSC 415 10256 CSC 445 10257 CSC 488 13150 CSC 530 10258 CSC 540 12818 CSC 585 22 Section Sec C course E D Campus Days MWF TR MW W 1 Main 2 Main 1 Main 2 Main 1 Main 2 Main 1 Main 2 Main 3 Main 4 Web Main Main Main Main Main 1 Main 20 Web 1 Main 1 Main 1 Main- 1 Main 1 Main 1 Main 1 Web 1 Main 1 Main 1 Main 1 Main 1 Main MW TR W T T MWF MWF MW TR TR TR TR TR MW TR TR TR MW TR F MeetingTime 09:30 am-10:20 am 02:00 pm-03:15 pm 08:00 am-09:15 am 06:00 pm-09:00 pm 12:30 pm-01:45 pm 09:30 am-10:45 am 10:30 am-11:20 am 09:30 am-10:20 am 11:00 am-11:50 am TBA 09:30 am-10:20 am 12:30 pm-01:20 pm 01:30 pm-02:45 pm 12:30 pm-01:45 pm 02:00 pm-03:15 pm. 12:30 pm-01:45 pm TBA 12:30 pm-01:45 pm 08:00 am-09:15 am 12:30 pm-01:45 pm 09:30 am-10:45 am TBA 02:00 pm-03:15 pm TBA 11:00 am-12:15 pm TBA 08:00 am-09:15 am 08:00 am-09:15 am TBA G H Capacity Actual 35 35 35 35 35 35 85 85 85 35 60 60 60 60 60 25 25 OSOOS OSONOGO 30 35 30 30 5 30 35 30 2 30 30 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 0 0 0 0 0 0 0 Remaining Instructor 35 Clark Duncan (P) 35 Clark Duncan (P) 35 Ramona J Smith (P) 35 Clark Duncan (P) 35 Ramona J Smith (P) 35 Ramona J Smith (P) 85 Clark Duncan (P) K StartDate EndDate 01/17/2022 05/12/2022 BB 202 01/17/2022 05/12/2022 BB 202 01/17/2022 05/12/2022 BB 202 01/17/2022 05/12/2022 BB 202 01/17/2022 05/12/2022 BB 202 01/17/2022 05/12/2022 BB 202 01/17/2022 05/12/2022 BB 404 01/17/2022 05/12/2022 BB 404 01/17/2022 05/12/2022 BB 404 85 Clark Duncan (P) 85 Clark Duncan (P) 35 Linda Florence Johnsonius (P) 01/17/2022 05/12/2022 TBA 60 Clark Duncan (P) 01/17/2022 05/12/2022 BB 201 01/17/2022 05/12/2022 BB 201 01/17/2022 05/12/2022 BB 201 01/17/2022 05/12/2022 BB 201 01/17/2022 05/12/2022 BB 201 01/17/2022 05/12/2022 BB 455 01/17/2022 05/12/2022 TBA 01/17/2022 05/12/2022 BB 209 01/17/2022 05/12/2022 BB 552 01/17/2022 05/12/2022 BB 209 01/17/2022 05/12/2022 BB 455 01/17/2022 05/12/2022 TBA 01/17/2022 05/12/2022 BB 209 01/17/2022 05/12/2022 TBA 01/17/2022 05/12/2022 BB 455 01/17/2022 05/12/2022 TBA 01/17/2022 05/12/2022 BB 551 01/17/2022 05/12/2022 BB 551 01/17/2022 05/12/2022 TBA J 60 Clark Duncan (P) 60 Clark Duncan (P) 60 Clark Duncan (P) 60 Clark Duncan (P) 25 Ramona J Smith (P) 25 Brian Linn McMurtry (P) 30 Marc Beck (P) 35 Matthew Tennyson (P) 30 Marc Beck (P) 30 Marc Beck (P) 5 Matthew Tennyson (P) 30 Matthew Tennyson (P) 35 Phillip Daniel Wright (P) 30 Matthew Tennyson (P) 2 Victor S Raj (P) 30 Matthew Tennyson (P) 30 Michael Lee Ramage (P) 0 Matthew Tennyson (P) 4 M A B C Location CourseNo Credits Title CSC 101 CSC 125 CSC 145 CSC 199 CSC 199L CSC 232 CSC 233 CSC 275 CSC 300 CSC 325 CSC 345 CSC 385 CSC 410 CSC 415 CSC 445 CSC 488 CSC 530 CSC 540 CSC 585 2 3 5 6 7 8 9 0 21 22 23 24 25 26 27 28 [29 30 31 Section D E 3 Introduction to Special Topics 3 Parallel and Distributed Computing 3 Programming Languages 3 Computer Algorithms 3 Introduction to Problem Solving Using Computers 3 Internet and Web Page Design 3 Introduction to Programming 3 Introduction to Information Technology 0 Lab 3 Introduction to Programming in C# 3 Programming in Python 3 Introduction to Game Programming - 3 Discrete Structures 3 Advanced Object-Oriented Programming 3 Data Structures course F G 3 Cooperative Education/Internship 3 Senior Software Project 3 Social, Ethical, & Professional Issues in the Information Age 3 Special Problems
Transcribed Image Text:5 5 7 CRN 3 9 O 1 2 3 4 5 6 7 8 9 30 #1 A B Course 10246 CSC 101 11023 CSC 101 10247 CSC 125 10887 CSC 125 11041 CSC 145 12921 CSC 145 10248 CSC 199 10254 CSC 199 10255 CSC 199 12771 CSC 199 10249 CSC 199L LA 10250 CSC 199L LB 10251 CSC 199L LC 10252 CSC 199L LD 10253 CSC 199L LE 11663 CSC 232 12203 CSC 233 11606 CSC 275 11021 CSC 300 11607 CSC 325 11022 CSC 345 13564 CSC 385 12901 CSC 410 14241 CSC 415 10256 CSC 445 10257 CSC 488 13150 CSC 530 10258 CSC 540 12818 CSC 585 22 Section Sec C course E D Campus Days MWF TR MW W 1 Main 2 Main 1 Main 2 Main 1 Main 2 Main 1 Main 2 Main 3 Main 4 Web Main Main Main Main Main 1 Main 20 Web 1 Main 1 Main 1 Main- 1 Main 1 Main 1 Main 1 Web 1 Main 1 Main 1 Main 1 Main 1 Main MW TR W T T MWF MWF MW TR TR TR TR TR MW TR TR TR MW TR F MeetingTime 09:30 am-10:20 am 02:00 pm-03:15 pm 08:00 am-09:15 am 06:00 pm-09:00 pm 12:30 pm-01:45 pm 09:30 am-10:45 am 10:30 am-11:20 am 09:30 am-10:20 am 11:00 am-11:50 am TBA 09:30 am-10:20 am 12:30 pm-01:20 pm 01:30 pm-02:45 pm 12:30 pm-01:45 pm 02:00 pm-03:15 pm. 12:30 pm-01:45 pm TBA 12:30 pm-01:45 pm 08:00 am-09:15 am 12:30 pm-01:45 pm 09:30 am-10:45 am TBA 02:00 pm-03:15 pm TBA 11:00 am-12:15 pm TBA 08:00 am-09:15 am 08:00 am-09:15 am TBA G H Capacity Actual 35 35 35 35 35 35 85 85 85 35 60 60 60 60 60 25 25 OSOOS OSONOGO 30 35 30 30 5 30 35 30 2 30 30 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 0 0 0 0 0 0 0 Remaining Instructor 35 Clark Duncan (P) 35 Clark Duncan (P) 35 Ramona J Smith (P) 35 Clark Duncan (P) 35 Ramona J Smith (P) 35 Ramona J Smith (P) 85 Clark Duncan (P) K StartDate EndDate 01/17/2022 05/12/2022 BB 202 01/17/2022 05/12/2022 BB 202 01/17/2022 05/12/2022 BB 202 01/17/2022 05/12/2022 BB 202 01/17/2022 05/12/2022 BB 202 01/17/2022 05/12/2022 BB 202 01/17/2022 05/12/2022 BB 404 01/17/2022 05/12/2022 BB 404 01/17/2022 05/12/2022 BB 404 85 Clark Duncan (P) 85 Clark Duncan (P) 35 Linda Florence Johnsonius (P) 01/17/2022 05/12/2022 TBA 60 Clark Duncan (P) 01/17/2022 05/12/2022 BB 201 01/17/2022 05/12/2022 BB 201 01/17/2022 05/12/2022 BB 201 01/17/2022 05/12/2022 BB 201 01/17/2022 05/12/2022 BB 201 01/17/2022 05/12/2022 BB 455 01/17/2022 05/12/2022 TBA 01/17/2022 05/12/2022 BB 209 01/17/2022 05/12/2022 BB 552 01/17/2022 05/12/2022 BB 209 01/17/2022 05/12/2022 BB 455 01/17/2022 05/12/2022 TBA 01/17/2022 05/12/2022 BB 209 01/17/2022 05/12/2022 TBA 01/17/2022 05/12/2022 BB 455 01/17/2022 05/12/2022 TBA 01/17/2022 05/12/2022 BB 551 01/17/2022 05/12/2022 BB 551 01/17/2022 05/12/2022 TBA J 60 Clark Duncan (P) 60 Clark Duncan (P) 60 Clark Duncan (P) 60 Clark Duncan (P) 25 Ramona J Smith (P) 25 Brian Linn McMurtry (P) 30 Marc Beck (P) 35 Matthew Tennyson (P) 30 Marc Beck (P) 30 Marc Beck (P) 5 Matthew Tennyson (P) 30 Matthew Tennyson (P) 35 Phillip Daniel Wright (P) 30 Matthew Tennyson (P) 2 Victor S Raj (P) 30 Matthew Tennyson (P) 30 Michael Lee Ramage (P) 0 Matthew Tennyson (P) 4 M A B C Location CourseNo Credits Title CSC 101 CSC 125 CSC 145 CSC 199 CSC 199L CSC 232 CSC 233 CSC 275 CSC 300 CSC 325 CSC 345 CSC 385 CSC 410 CSC 415 CSC 445 CSC 488 CSC 530 CSC 540 CSC 585 2 3 5 6 7 8 9 0 21 22 23 24 25 26 27 28 [29 30 31 Section D E 3 Introduction to Special Topics 3 Parallel and Distributed Computing 3 Programming Languages 3 Computer Algorithms 3 Introduction to Problem Solving Using Computers 3 Internet and Web Page Design 3 Introduction to Programming 3 Introduction to Information Technology 0 Lab 3 Introduction to Programming in C# 3 Programming in Python 3 Introduction to Game Programming - 3 Discrete Structures 3 Advanced Object-Oriented Programming 3 Data Structures course F G 3 Cooperative Education/Internship 3 Senior Software Project 3 Social, Ethical, & Professional Issues in the Information Age 3 Special Problems
Table Field Section CRN |Туре Section CourseNo varchar(10) Section Sec Varchar(4) Section Days Section Time Int Section Campus Varcahr(10) Section Capacity Section Actual Varchar(5) Varchar(30) Int Int Section Remaining Int Section Instructor Varchar(20) Section StartDate Date Section EndDate Date Section Location Varchar(10) Course CourseNo varchar(10) Course Credits Int Course Title Varchar(30) Allowable values Value between 10001 and 99999 Either Main or Web or Hopkinsville or Zoom 0 to 100 0 to 200 0 to 200 EndDate > StartDate |>=0 |Key Primary key Foreign key Primary key
Transcribed Image Text:Table Field Section CRN |Туре Section CourseNo varchar(10) Section Sec Varchar(4) Section Days Section Time Int Section Campus Varcahr(10) Section Capacity Section Actual Varchar(5) Varchar(30) Int Int Section Remaining Int Section Instructor Varchar(20) Section StartDate Date Section EndDate Date Section Location Varchar(10) Course CourseNo varchar(10) Course Credits Int Course Title Varchar(30) Allowable values Value between 10001 and 99999 Either Main or Web or Hopkinsville or Zoom 0 to 100 0 to 200 0 to 200 EndDate > StartDate |>=0 |Key Primary key Foreign key Primary key
Expert Solution
Step 1

The question is answered in step2 

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
SQL Query
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS