[go: up one dir, main page]
Scribd
Upload
56 views1 page

Comp7071 Assignment3a Group2 Version2

The document describes an entity relationship diagram (ERD) for a rental property management system. The ERD shows entities like Applicant, Asset, Reference, OccupancyHistory, RentHistory, and their relationships. Key attributes are identified for each entity. Entities like MaintenanceRequest, Invoice, JobReport are also included to model work orders and billing.

Uploaded by

tushyais
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
56 views1 page

Comp7071 Assignment3a Group2 Version2

The document describes an entity relationship diagram (ERD) for a rental property management system. The ERD shows entities like Applicant, Asset, Reference, OccupancyHistory, RentHistory, and their relationships. Key attributes are identified for each entity. Entities like MaintenanceRequest, Invoice, JobReport are also included to model work orders and billing.

Uploaded by

tushyais
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

12/1/23, 11:49 PM assignments.assignment3d.

md

APPLICANT

+int ID
+String name
+String employer
+Float income
+id REFERENCE_FK

ASSET
REFERENCE SERVICE
+int ID
+int ID +int ID
+String type
+String name +String type
+String status
+String relationship +Float rate
+String location

OCCUPANCY_HISTORY
RENT_HISTORY DAMAGE APPLIANCE RENTER
LINE_ITEM
+int ID
+int ID +int ID +int ID +int ID
+int ASSET_FK +int SERVICE_FK
+int ASSET_FK +int ASSET_FK +int ASSET_FK +String name
+Date start_date +int INVOICE_FK
+Date date +String description ++String make +String emergency_contact_email
+Date end_date +INT hours
+Float amount +Date date_reported +String model +String family_doctor_email
+String license_plate

MAINTENANCE_REQUEST INVOICE

+int RENTER_FK +int ID


+int APPLIANCE_FK +Float rent_amount
+Date date +Float tax
+String description +Date due_date

JOB_REPORT
WORK_ITEM
+int ID
+int ID
+int MAINTENANCE_REQUEST_FK
+int MAINTENANCE_REQUEST_FK
+String description
+String status
+Date date_completed

file:///D:/bcit-fall2023-notes/dependencies/localhost/comp7071/notes/assignments.assignment3d.html 1/1

You might also like