Question: Develop the ERD and write the relation notation for the following scenarios. For each scenario state how many relations would be need to implement the
Develop the ERD and write the relation notation for the following scenarios. For each scenario state how many relations would be need to implement the relationship. Account for the cardinality and participation in each relationship on your ERD. A book rental store would like to track which customers have rented books from them. Customers have a name, several email addresses (that can be broken down into user handle, domain and suffic), date of birth and mobile number. Books are tracked by a book_id, title and an author. Each Rental may have multiple payments, where there is a system generated payment_id, payment date and payment amount.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
