Entity Relationship Diagram (ERD)

Larsvandijk / WT_backend

0 stars 1 forks source link

Entity Relationship Diagram (ERD) #8

Open nirajdoritos88 opened 3 months ago

nirajdoritos88 commented 3 months ago

Design a ERD with the following entities in mind.

Teaching material (for now only books)
Users:
- Teachers
- Trainees
- Front Desk/WT employees
Address

HoangBuiGit commented 3 months ago

Current ERD. Feel free to comment if we miss anything or if something is unclear.

Larsvandijk commented 3 months ago

Looks very good in my opinion!

Is it necessary to include Categroy_list_ID and author_list_Id? Saw that they did that in the online example below (See junction_Id)

HoangBuiGit commented 3 months ago

Looks very good in my opinion!

Is it necessary to include Categroy_list_ID and author_list_Id? Saw that they did that in the online example below (See junction_Id)

Thanks for the feedback. In the udemy course about database design under second forms they did not add a PK for junction tables. But it can be handy for large databases, so I will add those to the design.

HoangBuiGit commented 3 months ago

Added extra dates to reservation, the junction_ids and changed author_id link in review to users.