Question 1: The following ERD refers to an borrow system of a library. Member can borrow different books, which were written by different authors and published by different publishers. A writer can be contracted to one or more publishers. Each member can have different borrows with different books to different expiring dates. a) Give two Attributes for each entity. Draw them directly into the ER-diagram. b) Give a primary key for each entity. Draw it directly into the ER-diagram. c) Create the SQL statement for implementing the table for one of the entities of the up standing ERD
Question 1: The following ERD refers to an borrow system of a library. Member can borrow different books, which were written by different authors and published by different publishers. A writer can be contracted to one or more publishers. Each member can have different borrows with different books to different expiring dates. a) Give two Attributes for each entity. Draw them directly into the ER-diagram. b) Give a primary key for each entity. Draw it directly into the ER-diagram. c) Create the SQL statement for implementing the table for one of the entities of the up standing ERD
Fundamentals of Information Systems
9th Edition
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter7: Knowledge Management And Specialized Information Systems
Section: Chapter Questions
Problem 13SAT
Related questions
Question
Question 1:
The following ERD refers to an borrow system of a library. Member can borrow different books, which were written by different authors and published by different publishers. A writer can be contracted to one or more publishers. Each member can have different borrows with different books to different expiring dates.
a) Give two Attributes for each entity. Draw them directly into the ER-diagram.
b) Give a primary key for each entity. Draw it directly into the ER-diagram.
c) Create the SQL statement for implementing the table for one of the entities of the up standing ERD.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning