In this assignment,. you will 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 (look at picture) Task A. Create SQL commands to create the two tables Task B. Import two tables worth of data
In this assignment,. you will 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 (look at picture) Task A. Create SQL commands to create the two tables Task B. Import two tables worth of data
Chapter6: Managing Multiple Worksheets And Workbooks
Section: Chapter Questions
Problem 3.12CP
Related questions
Question
100%
In this assignment,. you will 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 (look at picture)
Task A. Create SQL commands to create the two tables
Task B. Import two tables worth of data
![Field
Section CRN
Table
Type
Int
Section Sec
Section Campus
Section Days
Section Time
Section Capacity
Int
Section Actual
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
Allowable values
Section CourseNo varchar(10)
Varchar(4)
Varcahr(10) Either Main or Web or Hopkinsville or Zoom
Varchar(5)
Varchar(30)
Varchar(30)
Value between 10001 and 99999
0 to 100
0 to 200
0 to 200
EndDate > StartDate
>=0
Key
Primary
key
Foreign
key
Primary
key](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F6fe936d4-9591-4816-9640-7f89653fc97b%2F0a9bd6ca-3d91-4b90-8448-d8c0c82d31cd%2F9qjl85a_processed.png&w=3840&q=75)
Transcribed Image Text:Field
Section CRN
Table
Type
Int
Section Sec
Section Campus
Section Days
Section Time
Section Capacity
Int
Section Actual
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
Allowable values
Section CourseNo varchar(10)
Varchar(4)
Varcahr(10) Either Main or Web or Hopkinsville or Zoom
Varchar(5)
Varchar(30)
Varchar(30)
Value between 10001 and 99999
0 to 100
0 to 200
0 to 200
EndDate > StartDate
>=0
Key
Primary
key
Foreign
key
Primary
key
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
Task B. Import the data shown in pictures into the two tables created.
![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
CRN
Sec
10249 CSC 199 LA
10250 CSC 199
LB
LC
LD
LE
10251 CSC 199
10252 CSC 199
10253 CSC 199
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
Campus
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
Days
MWF
TR
MW
W
MW
TR
W
T
T
MWF
MWF
MW
TR
TR
TR
TR
TR
MW
TR
TR
TR
MW
TR
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
Capacity Actual
35
35
35
35
35
35
85
85
85
35
60
60
60
60
60
25
25
30
35
30
30
5
30
35
30
2
30
30
Remaining Instructor StartDate EndDate Location
35 Clark Dun 01/17/202 05/12/202 BB 202
35 Clark Dun 01/17/202 05/12/202 BB 202
35 Ramona J 01/17/202 05/12/202 BB 202
35 Clark Dun 01/17/202 05/12/202 BB 202
35 Ramona J 01/17/202 05/12/202 BB 202
35 Ramona J 01/17/202 05/12/202 BB 202
85 Clark Dun 01/17/202 05/12/202 BB 404
85 Clark Dun 01/17/202 05/12/202 BB 404
85 Clark Dun 01/17/202 05/12/202 BB 404
35 Linda Flor 01/17/202 05/12/202 TBA
60 Clark Dun 01/17/202 05/12/202 BB 201
60 Clark Dun 01/17/202 05/12/202 BB 201
60 Clark Dun 01/17/202 05/12/202 BB 201
60 Clark Dun 01/17/202 05/12/202 BB 201
60 Clark Dun 01/17/202 05/12/202 BB 201
25 Ramona J 01/17/202 05/12/202 BB 455
25 Brian Linn 01/17/202 05/12/202 TBA
30 Marc Beck 01/17/202 05/12/202 BB 209
35 Matthew 01/17/202 05/12/202 BB 552
30 Marc Beck 01/17/202 05/12/202 BB 209
30 Marc Beck 01/17/202 05/12/202 BB 455
5 Matthew 01/17/202 05/12/202 TBA
30 Matthew 01/17/202 05/12/202 BB 209
35 Phillip Da 01/17/202 05/12/202 TBA
30 Matthew 01/17/202 05/12/202 BB 455
2 Victor S R: 01/17/202 05/12/202 TBA
30 Matthew 01/17/202 05/12/202 BB 551
30 Michael Le 01/17/202 05/12/202 BB 551
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0](https://content.bartleby.com/qna-images/question/6fe936d4-9591-4816-9640-7f89653fc97b/b8fbc6b1-a363-4dea-bf6b-9afa56b23858/9ngk169_thumbnail.png)
Transcribed Image Text: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
CRN
Sec
10249 CSC 199 LA
10250 CSC 199
LB
LC
LD
LE
10251 CSC 199
10252 CSC 199
10253 CSC 199
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
Campus
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
Days
MWF
TR
MW
W
MW
TR
W
T
T
MWF
MWF
MW
TR
TR
TR
TR
TR
MW
TR
TR
TR
MW
TR
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
Capacity Actual
35
35
35
35
35
35
85
85
85
35
60
60
60
60
60
25
25
30
35
30
30
5
30
35
30
2
30
30
Remaining Instructor StartDate EndDate Location
35 Clark Dun 01/17/202 05/12/202 BB 202
35 Clark Dun 01/17/202 05/12/202 BB 202
35 Ramona J 01/17/202 05/12/202 BB 202
35 Clark Dun 01/17/202 05/12/202 BB 202
35 Ramona J 01/17/202 05/12/202 BB 202
35 Ramona J 01/17/202 05/12/202 BB 202
85 Clark Dun 01/17/202 05/12/202 BB 404
85 Clark Dun 01/17/202 05/12/202 BB 404
85 Clark Dun 01/17/202 05/12/202 BB 404
35 Linda Flor 01/17/202 05/12/202 TBA
60 Clark Dun 01/17/202 05/12/202 BB 201
60 Clark Dun 01/17/202 05/12/202 BB 201
60 Clark Dun 01/17/202 05/12/202 BB 201
60 Clark Dun 01/17/202 05/12/202 BB 201
60 Clark Dun 01/17/202 05/12/202 BB 201
25 Ramona J 01/17/202 05/12/202 BB 455
25 Brian Linn 01/17/202 05/12/202 TBA
30 Marc Beck 01/17/202 05/12/202 BB 209
35 Matthew 01/17/202 05/12/202 BB 552
30 Marc Beck 01/17/202 05/12/202 BB 209
30 Marc Beck 01/17/202 05/12/202 BB 455
5 Matthew 01/17/202 05/12/202 TBA
30 Matthew 01/17/202 05/12/202 BB 209
35 Phillip Da 01/17/202 05/12/202 TBA
30 Matthew 01/17/202 05/12/202 BB 455
2 Victor S R: 01/17/202 05/12/202 TBA
30 Matthew 01/17/202 05/12/202 BB 551
30 Michael Le 01/17/202 05/12/202 BB 551
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
![CourseNo Credits
CSC 101
CSC 125
CSC 145
CSC 199
CSC 199
CSC 199
CSC 199
CSC 199
CSC 199
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
Title
3 Introduction to Problem Solving Using Computers
3 Internet and Web Page Design
3 Introduction to Programming
3 Introduction to Information Technology
0 Lab A
0 Lab B
0 Lab C
0 Lab D
0 Lab E
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
3 Introduction to Special Topics
3 Parallel and Distributed Computing
3 Programming Languages
3 Computer Algorithms
3 Cooperative Education/Internship
3 Senior Software Project
3 Social, Ethical, & Professional Issues in the Information Age
3 Special Problems](https://content.bartleby.com/qna-images/question/6fe936d4-9591-4816-9640-7f89653fc97b/b8fbc6b1-a363-4dea-bf6b-9afa56b23858/mnjxkxj_thumbnail.png)
Transcribed Image Text:CourseNo Credits
CSC 101
CSC 125
CSC 145
CSC 199
CSC 199
CSC 199
CSC 199
CSC 199
CSC 199
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
Title
3 Introduction to Problem Solving Using Computers
3 Internet and Web Page Design
3 Introduction to Programming
3 Introduction to Information Technology
0 Lab A
0 Lab B
0 Lab C
0 Lab D
0 Lab E
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
3 Introduction to Special Topics
3 Parallel and Distributed Computing
3 Programming Languages
3 Computer Algorithms
3 Cooperative Education/Internship
3 Senior Software Project
3 Social, Ethical, & Professional Issues in the Information Age
3 Special Problems
Solution
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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr