Semester 1, 2024: COIT20247 Database Systems - Property Rental ERD

Desklib provides solved assignments and past papers to help students succeed.

COIT20247

Contents
Introduction..............................................................................................................................3
ERD............................................................................................................................................4
Assumptions..............................................................................................................................4
Conclusion.................................................................................................................................6
Reference...................................................................................................................................7
Table of figure
Figure 1: ERD............................................................................................................................4

Introduction
There is about the property which is for the rent and the whole case scenarios were given the
main task was to build the ERD that is entity relationship diagram which will help to
understand the system. The implementation is done on the online software that is draw.io.
There are business rule and assumptions taken.

ERD
Figure 1: ERD
Assumptions
There is some assumption take for the diagram that is:
1. There is a weak entity present which will not be unique as there is no primary key
present.
2. There is a one-to-many relationship present which is on the Pro_ManagerID. And this
is also assigned as the foreign key in the different table.
3. There will be a property manager who will manage multiple properties.
4. There are no restrictions for the customer to buy only one property. They can have
multiple properties.

5. There is a one-to-one relationship present which will have a property and on the rental
property.
6. There is a multivalued attribute in employee type which has different task such as a
plumber, maintenance staff, etc.
7. There is the use of specialization which shows there perfection fields such as staff will
have the maintenance and other staffs etc.
8. There is a one-to-one relationship present which is between the application and owner
(Fredstam, & Johansson, 2019).
9. All the entities contain the primary keys that help in identifying the particular column
uniquely.
10. Many to Many relationship is also resolved in the above created diagram between
Property and the Owner of the Property.
11. Foreign keys are the main part in extracting any type of data from two or more tables
as they help in joining the tables.

Conclusion
The ERD is perfectly designed according to the scenario given and this has also explained the
assumption which is taken for making the ERD. The tool draw.io is the simplest tools which
will help the user understand the scenario.

Reference
Quang, H., & Pham, T. (2015). Expressing a temporal entity-relationship model as a
traditional entity-relationship model. In Computational Collective Intelligence (pp. 483-491).
Springer, Cham.
Fredstam, M., & Johansson, G. (2019). Comparing database management systems with
SQLAlchemy: A quantitative study on database management systems.