Question: Map the ER diagram into the relational schema that consists of relation names, their attributes with primary keys underscored and foreign keys pointing to the
Map the ER diagram into the relational schema that consists of relation names, their attributes with primary keys underscored and foreign keys pointing to the corresponding attributes properly without using SQL, and specify which constraints cannot be represented in SQL.

3. Publication enterprises include books, authors and publishers. Authors are people with name and date of birth, but in addition they wrote one or more books. A book has title, ISBN, publication date. Publishers are companies that publish books. They have an address, phone numbers (typically more than one), and name. A book can be written by more than one author, but it can be published by only one publisher. An author can write more than one book and to be called an author one, of course, has to write at least one book. Design an ER diagram that describes this database application with all relevant constraints represented using Method 3. (10 marks) Aname DOB ISBN#) (Title) PubDate) Wrote Book Author
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
