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
icon
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.

1
1
book
fullfills
borrow
has
member
m
published
by
publisher
m
eontracted
by
written
writer
by
Transcribed Image Text:1 1 book fullfills borrow has member m published by publisher m eontracted by written writer by
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Database Environment
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
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning