I was asked to draw an arrow to indicate the foreign key for each relation. I read somewhere that if the pk being refere

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

I was asked to draw an arrow to indicate the foreign key for each relation. I read somewhere that if the pk being refere

Post by answerhappygod »

I was asked to draw an arrow to indicate the foreign keyfor each relation.
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
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 39 times
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)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”