Question: - Using the Entities and Attributes you created for your business from the week 1 discussions. Show the tables and relationships resulting from your model
- Using the Entities and Attributes you created for your business from the week 1 discussions. Show the tables and relationships resulting from your model in the form of an E/R diagram.
You can use PPT, VISIO or any other graphical modeling tool to create your ER diagram.
Hey The below Entities and Attributes I created for week 1. Please use these below Attributes and Entities and create diagram.
Entities and their attributes:
1.Entity: Renter
Attributes:
(I) Renter_ID (ii) Renter_Name (III) address (IV) mobile number (v) email_ID
2. Entity: Hirer
Attributes:
(I) Hirer_ID . (ii) Hirer_Name. (III) address (IV) mobile number (v) email_ID
3. Entity: PCs
Attributes:
(I) . PC_ID. (ii) Renter_ID (III) Rate (IV) brand (v) model (vi) ip_address (vii) processor (memory) (viii) body number
4. Entity: Rent_Transactions
Attributes:
(i) rent_transaction_ID (ii) renter_ID (III) rent_start_date (IV) rent_end_date (v) number_of_days (vi) total_rent_amonut (vii) service_fees (vii) net_amount_paid
5. Entity: Hire_Transactions
Attributes:
(I) hire_transaction_ID. (ii) hirer_ID (III) start_date (iv) end_date (v) number_of_days (vi) rent_charged (vii) service_fees
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
