Changes between Version 8 and Version 9 of ERModel
- Timestamp:
- 05/04/26 02:17:52 (3 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ERModel
v8 v9 1 == Entity-Relationship Model v.0 21 == Entity-Relationship Model v.03 2 2 3 3 [[Image(ERModel_v03.png, align=center)]] 4 4 5 5 == Entities 6 7 List all entities and relationships with the following information for each of them8 9 Entity/relationship name: one paragraph of explanation, what does the entity/relationship represent, why it is needed, why is it modeled the way it is10 11 Candidate keys: If you have multiple candidates for the primary key, list them and explain which one you chose as the primary key and why you chose it as the primary key12 13 List of entity attributes, for each of them: the data type (numeric/text/date/…) and whether there are any restrictions in the input form/format (required/optional, special format, value interval, …)14 15 **NAME OF ENTITY/RELATIONSHIP**16 6 17 7 DESCREPTION OF THE ENTITY/RELATIONSHIP … … 23 13 24 14 **1.User:** 15 * **Candidate Keys** 25 16 * user_id (bigint) - primary key 17 * **Attirbutes** 26 18 * email (text) 27 19 * username (bigint) … … 30 22 31 23 **2.Admin:** 24 * **Candidate Keys** 25 * **Attributes:** 32 26 * type (text) 33 27 * employee_id (bigint) … … 35 29 **3.Consumer** 36 30 * **Candidate Keys** 31 * **Attributes:** 37 32 * telephone_number (text) 38 33 * shipping_address (text) … … 47 42 * wishlist_id (bigint) - foreign key(Wishlist) 48 43 * product_id (bigint) - foreign key(Product) 44 * **Attributes:** 49 45 * added_at (date) 50 46 … … 52 48 * **Candidate Keys** 53 49 * product_id (bigint) - primary key 50 * **Attributes:** 54 51 * format (enum) 55 52 * price (bigint) … … 60 57 * **Candidate Keys** 61 58 * release_id (bigint) - primary key 59 * **Attributes:** 62 60 * title (text) 63 61 * record_label (text) … … 76 74 * **Candidate Keys** 77 75 * artist_id (bigint) - primary key 76 * **Attributes:** 78 77 * artist_name(text) 79 78 * description(text) … … 83 82 * **Candidate Keys** 84 83 * song_id(bigint) - primary key 84 * **Attributes:** 85 85 * song_name(text) 86 86 * featured_artist (text) … … 91 91 * order_id (bigint) - foreign key(Order) 92 92 * product_id (bigint) - foreign key(Product) 93 * **Attributes:** 93 94 * price_at_purchase (bigint) 94 95 * quantity (bigint)
