Title: Write the database table design to represent the data model below, including tables, the proper ...
Post by: lbelcher on Feb 11, 2019
Write the database table design to represent the data model below, including tables, the proper placement of the foreign key, and referential integrity constraint.
Title: Write the database table design to represent the data model below, including tables, the proper ...
Post by: BobbyD on Feb 11, 2019
STUDENT (StudentID, StuName, StuMajor, StuPhone, AdvisorID)
ADVISOR (AdvisorID, AdvName, AdvOffice, AdvPhone)
AdvisorID in STUDENT must exist in AdvisorID in ADVISOR.
ADVISOR (AdvisorID, AdvName, AdvOffice, AdvPhone)
AdvisorID in STUDENT must exist in AdvisorID in ADVISOR.