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

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter6: Managing Multiple Worksheets And Workbooks
Section: Chapter Questions
Problem 3.12CP
icon
Related questions
Question
100%

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

 

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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
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
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
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
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Basic sql queries
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
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
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning