Question
(a) As depicted in Figure 1, some clients might be leasing properties. (i) Provide the necessary attributes for each of the tables Client, PropertyFor- Rent
(a) As depicted in Figure 1, some clients might be leasing properties.
(i) Provide the necessary attributes for each of the tables Client, PropertyFor- Rent and Lease.
(ii) Will this model allow you to rent two properties? Explanin why (or why not) in no more than 20 words.
(b) (i) Explain what Entity Integrity is, and why it should be enforced in relational
models. Use Figure 1 to contextualise your discussion.
(ii) Give an example of an integrity constraint (applicable to this data model) that you think should be enforced, but is not captured by the relevant primary keys and the foreign keys. Please provide a brief explanation of your answer. Limit your answer to 30 words.
(c) (3 marks) Due to a recent policy change, every new contract for a property owner must specify whether the owner is either a Domestic owner or Foreign owner (but not both). Describe how you will modify the data model in Figure 1 to accommodate this new requirement. Specifically, tell if the new relationship you would add is of Mandatory/Optional type and if it is of And/Or type, as appropriate, and explain why. Limit your complete answer to this question to 60 words.
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