Bleu Sdn. Bnd. is a company that manages all house renting data in Jasin area. Currently, they are still using the traditional ﬁle based system to store data about renters, owners. houses and the house's Facilities in Jasin area. One day, almost all if the ﬁles in their cabinets are damaged due to some mistakes made by the employees. Hence. the company's top management has decided to hire a company to develop House Renting Management System to ease the management in monitoring their data. As a database designer. you need to design the data model according to these requirements belore the development starts. The requirements are. User data must include their IC number, email. and phone numbers. A user may rent a house and at one time. a house can oniy be rented by one user. The house must include a full address to ease the renter and owner. Each house must have exactly one owner and an owner may own multiple houses. Each house may have multiple facilities and the facilities may be the same for different houses. The facilities should be categorized in indoor or outdoor to differentiate its. Function. Draw a complete entity diagram which consists of primary key, foreign keys, and multiplicty constraints include relevant attributes when necessary.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Bleu Sdn. Bnd. is a company that manages all house renting data in Jasin area. Currently, they are still using the traditional ﬁle based system to store data about renters, owners. houses and the house's Facilities in Jasin area. One day, almost all if the ﬁles in their cabinets are damaged due to some mistakes made by the employees. Hence. the company's top management has decided to hire a company to develop House Renting Management System to ease the management in monitoring their data. As a database designer. you need to design the data model according to these requirements belore the development starts. The requirements are. User data must include their IC number, email. and phone numbers. A user may rent a house and at one time. a house can oniy be rented by one user. The house must include a full address to ease the renter and owner. Each house must have exactly one owner and an owner may own multiple houses. Each house may have multiple facilities and the facilities may be the same for different houses. The facilities should be categorized in indoor or outdoor to differentiate its. Function. Draw a complete entity diagram which consists of primary key, foreign keys, and multiplicty constraints include relevant attributes when necessary.

Expert Solution