Complete ER diagrams of all the case studies. Use correct symbol like represent attributes by oval, entity by using rectangle, relationship by using diamond and line connects entities and relationships. Also write paragraphs explaining details about the design regarding following aspects
 What diagramming software is used and any comments on the software (if any otherwise handwritten is also fine).
 Any clarifications about your ERD which are not evident in the model itself.
 Any assumptions you had to make with respect to the requirements.
 Any constraints (business rules) apparent from the requirements that you are unable to model
via your ERD.

Case Study 1:

Question 1: Online Book Store [20 Points]
In an Online bookstore, Many authors write many books. Each author has a name, address, and URL. Each book has its ISBN, title, author name, year published and price. Each publisher publishes more than one book. Publishers have their own name, address, contact number, URL. Each customer can purchase more than one book. Each customer has a name, address, phone number, Email and purchase ID. The Number of books purchased are tracked during purchase. Many Books are stocked in many warehouses. Each warehouse has its own ID, Address, contact number, number of books.

Case Study 2:

Question 2: Charity Foundation [30 Points]
In a charity foundation, there is an admin who creates an account of every employee that is employed in the foundation. An admin has an ID, a username, password whereas a charity employee has an ID, name, password, rank/status, phone number, Email, task. There are needy people who approach admin for any help. Admin approves many needy people. Needy people need to provide information about their national ID, name, password, phone number, income, total number of family members, location and amount needed to the foundation. Each charity employee can deliver donations to many needy people who approach the foundation. Admin also registers many donation boxes and each charity employee collects money from those donation boxes. These donation boxes have their ID, password and location. In this foundation the donator can make many donations. In order to make a donation, the donator has to provide information about his/her national ID, name, password, phone number, location, amount donated. Each donation has its ID and type. A charity employee receives multiple donations. Many donations have many types of items. Each type has its own ID and name. The items only have the total type of items in it.

Answer rating: 100% (QA)

Case Study 1 1 The ERD has been designed using an online free drawing tool 2 Calcifications in the E... View the full answer