Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Given the following database with 3 tables. Each student can enroll in many classes and a class can have many students. At the end of
Given the following database with 3 tables. Each student can enroll in many classes and a class can have many students. At the end of each semester, a student will receive a grade for each class. Answer the following questions: StudentNumber LastName FirstName EmailAddress STUDENT Table #ofrows_ # of attributes Primary Key Foreign Key_ 1 Cooke 2 Lau 3 Harris Grene GraceGraceGreene@Ouru.edu Sam.Cooke@OurU.edu Marcia Marcia.Lau@Ouru.edu Lou.Harris@0urU.edu Lou CLASS Table #ofrows_ # of attributes Primary Key Foreign Key ClassNumber Term 10 CHEM 101 20 CHEM 101 0 CHEM 101 40 ACCT 101 50 ACCT 101 2014-Fall 2014-Fall 2015-Spring 2014-Fall 2015-Spring StudentNumber ClassNumber GRADE Table #ofrows_ # of attributes Primary Key Foreign Key_ Grade 10 40 20 30 3.70 3.50 3.70 3.10 3.00 3.50 50 1. The relationship between STUDENT and GRADE is It means that one student may be linked to many in GRADE TABLES 2. The relationship between CLASS and GRADE is.It means that one class may have many students. Do these 3 tables exhibit entity integrity? Does GRADE exhibit referential integrity? 3. 4. 5. Draw the ER diagram (Using Crow's Foot notation) to show the relationship among these 3 tables
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started