BASED ON THE ERD, PLEASE COME UP WITH THE Referential Integreity Constriants and
ID: 3838646 • Letter: B
Question
BASED ON THE ERD, PLEASE COME UP WITH THE Referential Integreity Constriants and business rules
ER-Assista project-Ha Dass-Part 2 Fle Edt Mew Insert Mode Window Help FACULTY Facuby D LastName FacutyEmai H+------------3 partment Buildi OfficeNumber Office OR STUDENT A Student D F ty D (FH) Assignment Beg Assignment End Ready STUDENT Student astNam Student StudentE Dorm Name Dorm Room NTLM Men Assignment B Assignment -+H DEGREE INFO +-----------------1 Student D FK ALUMNI Graduatio eMajol MENTOR AAumFirstName AhumLastName Mentor astName AumE MentorfirstN Add State Com ystate Phone Com Com yPhone R ADVISOR A Faculty D (FK Assignment B A8aignmentLEExplanation / Answer
On the bases of ERD given, we can say that here Referential Integreity Constraints says that:
1) Each STUDENT must have exactly one FACULTY and that faculty must present in the database. It means "Faculty_ID" will be primary key in FACULTY table and it will act as foreign key in STUDENT table
2) Each STUDENT must have exactly one MENTOR and that mentor must present in the database.It means "MentorEnroll" will be primary key in MENTOR table and it will act as foreign key in STUDENT table
3) Each STUDENT must have exactly one degree and that degree information must present in database. It means "Student_ID" will be primary key in STUDENT table and it will act as foreign key in DEGREE_INFO table.
The various business rules are given below:
1) Each student must have only one degree and that degree information must be in the DEGREE_INFO table.
2) Each student must be associated with exactly one faculty.
3) Each student must be associated with exactly one mentor.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.