Question
Bhalo Basha Chai (BBC) - is a housing agent in Bangladesh like Bikroy.com that publishes advertisements of properties that can be rented. Previously they stored
Bhalo Basha Chai (BBC) - is a housing agent in Bangladesh like Bikroy.com that publishes advertisements of properties that can be rented. Previously they stored all their information in papers. Recently they have decided to use a database. They have come up with the following requirements:
There are many branches of Bhalo Basha Chai throughout the country. Each branch is located in a street of a city and has a postcode.
Many employees work in Bhalo Basha Chai. Upon joining the company, they provide their name (first name and last name), sex, date of birth. They are also appointed to a position (like manager, salesperson etc) in a specific branch. Their salaries are also recorded for tax purpose.
Numerous clients rent houses from Bhalo Basha Chai. Whenever they register on the website, they provide their name, telephone number, email, and the maximum amount of rent they can afford.
During registration, the client goes to a specific branch. He/she is also assigned a staff member who is their contact person. A client can register in multiple branches. A client can be at most assigned to one employee and an employee can have at most one client.
Bhalo Basha Chai needs to store information about the house owners who own the houses. The owners register on their website by providing their name, telephone number, email, and password.
BBC has multiple houses for rent under them. These houses are denoted by house no, street, number of available rooms for rent. Each house is associated with one owner. But an owner can own from zero to multiple houses.
Each client can rent a house. While renting a house some information are recorded such as, price per month, rent date etc.
Every branch of BBC holds different events like Open House Event. This same event can be hosted in multiple days. Some event details like event name, date, food provided etc. are recorded. (Hint: Events will have discriminators)
Reduce the ER model that you have designed into a set of relations with proper justification. Identify the appropriate primary key for each relation.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started