assignment 2 csd 2206 (2)
pdf
keyboard_arrow_up
School
Lambton College *
*We aren’t endorsed by this school
Course
2206
Subject
Information Systems
Date
Apr 3, 2024
Type
Pages
3
Uploaded by hihjk
CSD 2206 Database Design & SQL
© 2023 LAMBTON COLLEGE IN TORONTO Assignment 2
(Weight: 3%) Objectives: To understand and be able design entity relationship diagrams Submission: Instruction will be provided by the instructor Question 1 P03-04 –
Midtown Publishing
•
Create the ER diagrams in different tabs according to the requirements analysis below •
Export the file as a PDF and submit A) Develop the ERD for a publishing company that wants a database to maintain authors and books. Each author may write several books. Some authors sign with the publishing company before they write their first book. Each book may have one or more authors. However, some books are approved before any authors are assigned. The business rules are as follows: • Author id, first name, last n
ame, and mobile number are stored for each author • Book id, title, publication year, and page count are stored for each book. The publi
- cation year and page count are not known until the book is published • Draw the ERD for the many
-to-many relationship(s) • Use ERD language
CSD 2206 Database Design & SQL
© 2023 LAMBTON COLLEGE IN TORONTO B) •
Resolve the many-to-many relationship between the BOOK and AUTHOR entities •
Some books have two or more authors and they want to keep track of the order in which the author names appear on the book cover •
Identify identifying and non-identifying relationships •
Include ERD language \
CSD 2206 Database Design & SQL
© 2023 LAMBTON COLLEGE IN TORONTO Both the relation between book and author_book And the relationship between author and author_book are non identifying because they are not dependent book and author
’
s entity primary key.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help