Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For each of the following descriptions, draw an ER diagram showing entities, attributes, and relationships and their multiplicities. Where necessary, state any assumptions. Customers are
For each of the following descriptions, draw an ER diagram showing entities, attributes, and relationships and their multiplicities. Where necessary, state any assumptions.
- Customers are identified by a name and have an address. They purchase items. Items are identified by a number and have a colour. The quantity bought of each item is recorded.
- Students are allowed to register in only one program at any given time. They enrol in courses in each semester. Students can enrol in the same course multiple times across different semesters. The system keeps track of marks obtained in each enrolment.
- A real estate agency keeps track of rental properties their agents manage. Each property has a unique address and other attributes, such as no. of bedrooms, no. of car spaces and type (unit |house| semi-detached). Each property is owned by one or more landlords. Landlords are uniquely identified by their email address. Each property is assigned to an agent. At any given point in time, there can be only one active rental contract but, it is required to retain all expired contracts as well. There could be one or more tenants party to a contract. A contract has a unique contract number, monthly rental, bond amount and start and end dates.
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