1  - Specify composite, primary, foreign keys for each table shown in Figure 1.2. Please refer to the below image.

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
icon
Related questions
icon
Concept explainers
Question

#1  - Specify composite, primary, foreign keys for each table shown in Figure 1.2. Please refer to the below image. 

STUDENT
Name Student_number
Smith
17
Brown
8
COURSE
Course_name
Intro to Computer Science
Data Structures
Discrete Mathematics
Database
SECTION
GRADE_REPORT
Student_number
17
17
8
8
8
8
Class
1
2
Section_identifier Course_number
85
MATH2410
92
CS1310
102
CS3320
112
MATH2410
119
CS1310
135
CS3380
PREREQUISITE
Course_number
CS3380
CS3380
CS3320
Course_number
CS1310
CS3320
MATH2410
CS3380
Section_identifier
112
119
85
92
102
135
Major
CS
CS
Semester
Fall
Fall
Spring
Fall
Fall
Fall
Prerequisite_number
CS3320
MATH2410
CS1310
Credit_hours
4
Grade
B
C
A
A
B
A
4
3
3
Department
CS
CS
MATH
CS
Year
Instructor
07
King
07
Anderson
08
Knuth
08 Chang
08
08
Anderson
Stone
Transcribed Image Text:STUDENT Name Student_number Smith 17 Brown 8 COURSE Course_name Intro to Computer Science Data Structures Discrete Mathematics Database SECTION GRADE_REPORT Student_number 17 17 8 8 8 8 Class 1 2 Section_identifier Course_number 85 MATH2410 92 CS1310 102 CS3320 112 MATH2410 119 CS1310 135 CS3380 PREREQUISITE Course_number CS3380 CS3380 CS3320 Course_number CS1310 CS3320 MATH2410 CS3380 Section_identifier 112 119 85 92 102 135 Major CS CS Semester Fall Fall Spring Fall Fall Fall Prerequisite_number CS3320 MATH2410 CS1310 Credit_hours 4 Grade B C A A B A 4 3 3 Department CS CS MATH CS Year Instructor 07 King 07 Anderson 08 Knuth 08 Chang 08 08 Anderson Stone
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Query Syntax
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