avipars / DB-Mini-Project

Book Database System for a Library
1 stars 0 forks source link

Create ERD and DSD (Stage 1) #1

Open avipars opened 1 week ago

avipars commented 1 week ago

using erdplus.com make the ERD, copy/take a picture of the diagram and also save the output code it produces

the site should also help convert the ERD to a DSD which is needed for part of stage 1

avipars commented 1 week ago

Requirements

Create an ERD with six entities at the very least. You are required to use two date fields at the minimum. A kind reminder: normalization dictates that entities should host enough properties to make them unique (separable from other entities). Stage the ERD as a JSON file in the repo, and include it as an image in the README. Also, document the why’s and how’s of your design; what gave rise to the entities that were chosen, and why (use cases, target users, what parts of the process are not covered). The document is evaluated under the ‘proposal’ component of the score.

My input:

Probably important to store author name and maybe a date field of when the book was added and maybe last updated (if it moved from location to location)