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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!