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
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
Related questions
Question
Write SQL commands to create a
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.
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
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
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
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.Recommended textbooks for you
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education