Question: I am posting second time this question please use below Attributes and Entities to create the diagram. Please don't copy someone answer from Chegg. Using
I am posting second time this question please use below Attributes and Entities to create the diagram. Please don't copy someone answer from Chegg.
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.
The below discussion I created for week 1. Please use these below Attributes and Entities and create diagram.
Suppose my new business is ''Computer rental service" in which there will be two types of customers. One who want to hire PCs, and the other who want to rent-out their PCs.
People can rent-out their PCs to earn rent, by depositing their PCs with my company. My company will then rent-out those PCs to customers who want to hire PCs.
A customer can hire personal computers for a given number of days. The customer has to a rent for using the computer depending on the number of days it is hired, model and configuration of the computer.
In this way my business works as a link between those who want to hire and those who want to rent out. Earning a small percentage of rent received.
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
