Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Analysis Using SQL And Excel

Authors: Gordon S Linoff

2nd Edition

111902143X, 9781119021438

More Books

Students also viewed these Databases questions