I was asked to draw an arrow to indicate the foreign key for each relation. I read somewhere that if the pk being refere
Posted: Fri Jul 01, 2022 5:37 am
I was asked to draw an arrow to indicate the foreign keyfor each relation.
I read somewhere that if the pk being referenced to is acombination of attributes, then the foreign key must include allthe combined attributes.
So am I correct if I put it as such? if not how can I dothat?
0 O Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course: STUDENT(SSN, Name, Major, Bdate) COURSE(Course#, Cname, Dept) ENROLL(SSN, Course#, Quarter, Grade) BOOK_ADOPTION(Course#, Quarter, Book_ISBN) TEXT(Book_ISBN, Book_Title, Publisher, Author) Add foreign key constraints to the schema above IMG_2579 ✓ Search ENROLL(SSN, course #, Qvarter, Grade) Book-AdoPTON (Course #, Quarter Book- ISBN)
- I Was Asked To Draw An Arrow To Indicate The Foreign Key For Each Relation I Read Somewhere That If The Pk Being Refere 1 (993.67 KiB) Viewed 40 times
So am I correct if I put it as such? if not how can I dothat?
0 O Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course: STUDENT(SSN, Name, Major, Bdate) COURSE(Course#, Cname, Dept) ENROLL(SSN, Course#, Quarter, Grade) BOOK_ADOPTION(Course#, Quarter, Book_ISBN) TEXT(Book_ISBN, Book_Title, Publisher, Author) Add foreign key constraints to the schema above IMG_2579 ✓ Search ENROLL(SSN, course #, Qvarter, Grade) Book-AdoPTON (Course #, Quarter Book- ISBN)