Create a set of relational schemas with underlined (primary) keys and arrows connecting foreign keys and primary
Fantastic news! We've Found the answer you've been seeking!
Question:
Create a set of relational schemas with underlined (primary) keys and arrows connecting foreign keys and primary keys for a database containing the following information. If you have any difficulty drawing arrows, you can write foreign key information in a sentence instead.
Authors have Last Name, Firstname, ID, and Birthdate (identified by ID)
Publishers have Name, ID, address (identified by ID)
Books have ISBN, Title, Publisher (each book has a unique publisher and can be identified by ISBN).
Authors Write Books; since many authors can co-author a book, we need to know the rank of an author contributing to a book, stored in this table (i.e. a number 1, 2, 3; for single author books, this number is 1).
Related Book For
Systems analysis and design
ISBN: ?978-1118808177
5th edition
Authors: Alan Dennis, Barbara Haley Wixom, Roberta m. Roth
Posted Date: