Draw a diagram that meets field-level integrity, table-level integrity, and rela
ID: 3838398 • Letter: D
Question
Draw a diagram that meets field-level integrity, table-level integrity, and relationship-level integrity. Make sure to do each of the following:
Establish relationships
Define the appropriate deletion rules
Establish and identify the relationship-specific business rules (constraints)
Identify the type of participation for each table
Establish the proper degree of participation for each table Courses (Sample Data)
BUS101
BUS101
Intro to Business
Intro to Business
1
2
A
B
101
100
5
5
Main
Main
HISTORY100
HISTORY100
American History
American History
1
1
D
E
111
119
5
5
Blue
Yellow
1
2
E
E
17
17
5
5
Yellow
Yellow
CourseNumber CourseDescription Section Building Room Credits CampusBUS101
BUS101
Intro to Business
Intro to Business
1
2
A
B
101
100
5
5
Main
Main
MATH101 Probability 1 C 105 5 Blue LANGUAGE102 English 1 C 106 5 BlueHISTORY100
HISTORY100
American History
American History
1
1
D
E
111
119
5
5
Blue
Yellow
HISTORY105 Writing1
2
E
E
17
17
5
5
Yellow
Yellow
Explanation / Answer
Relationships:
CourseNumber -> CourseDescription,Credits
CourseNumber -> Section
CourseNumber,Section -> Room
Room -> Building,Campus
Based on above relationships, if we normalize table,
First table:
CourseDetails: CourseNumber,CourseDescription,Credits
Sections: CourseNumber,Section (Foreign key dependency on CourseDetails)
RoomDetails: Room,Building,Campus
ClassDetails: CourseNumber,Section,Room (Each row in this table is dependent on all the three tables)
Deletion rules:
1. Any row in ClassDetails can be deleted.
2. To delete any row from RoomDetails, need to remove that room from ClassDetails table
3. To delete any row from CourseDetails, need to remove that room from ClassDetails and SectionDetails table
4. Before removing any section remove its entries from Class Details
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.