STUDENT Name Student_number Class Smith 17 1 Brown 8 2 COURSE Course_name Intro to Computer Science Data Structures Discrete Mathematics Database SECTION Course_number CS1310 CS3320 MATH2410 CS3380 Section_identifier Course_number 85 MATH2410 92 CS1310 102 CS3320 112 MATH2410 119 CS1310 135 CS3380 Major CS CS Fall Fall Credit_hours 4 4 Spring Fall Fall Fall 3 3 Semester Year 8668888 07 07 08 08 08 08 Department CS CS MATH CS Instructor King Anderson Knuth Chang Anderson Stone Figure 1.2 A database that stores student and course information. GRADE REPORT Student number 17 17 8 8 8 8 PREREQUISITE Course_number CS3380 CS3380 CS3320 Section_identifier 112 119 85 92 102 135 Prerequisite_number CS3320 MATH2410 CS1310 Grade B A A B A

Systems Architecture
7th Edition
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Stephen D. Burd
Chapter3: Data Representation
Section: Chapter Questions
Problem 17VE
icon
Related questions
Question

Please written by computer source

Give 10 examples of integrity constraints that you think should hold on the database shown in Figure 1.2.

STUDENT
Name Student_number Class
Smith
17
1
Brown
8
2
COURSE
Course_name
Intro to Computer Science
Data Structures
Discrete Mathematics
Database
SECTION
Course_number
CS1310
CS3320
MATH2410
CS3380
Section_identifier Course_number
85
MATH2410
92
CS1310
102
CS3320
112
MATH2410
119
CS1310
135
CS3380
Major
CS
CS
Fall
Fall
Credit_hours
4
4
Spring
Fall
Fall
Fall
3
3
Semester Year
8668888
07
07
08
08
08
08
Department
CS
CS
MATH
CS
Instructor
King
Anderson
Knuth
Chang
Anderson
Stone
Figure 1.2
A database that stores
student and course
information.
GRADE REPORT
Student number
17
17
8
8
8
8
PREREQUISITE
Course_number
CS3380
CS3380
CS3320
Section_identifier
112
119
85
92
102
135
Prerequisite_number
CS3320
MATH2410
CS1310
Grade
B
A
A
B
A
Transcribed Image Text:STUDENT Name Student_number Class Smith 17 1 Brown 8 2 COURSE Course_name Intro to Computer Science Data Structures Discrete Mathematics Database SECTION Course_number CS1310 CS3320 MATH2410 CS3380 Section_identifier Course_number 85 MATH2410 92 CS1310 102 CS3320 112 MATH2410 119 CS1310 135 CS3380 Major CS CS Fall Fall Credit_hours 4 4 Spring Fall Fall Fall 3 3 Semester Year 8668888 07 07 08 08 08 08 Department CS CS MATH CS Instructor King Anderson Knuth Chang Anderson Stone Figure 1.2 A database that stores student and course information. GRADE REPORT Student number 17 17 8 8 8 8 PREREQUISITE Course_number CS3380 CS3380 CS3320 Section_identifier 112 119 85 92 102 135 Prerequisite_number CS3320 MATH2410 CS1310 Grade B A A B A
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Table
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
Systems Architecture
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
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
Enhanced Discovering Computers 2017 (Shelly Cashm…
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning