Lecture notes Database Development (Comp11007)

JF A Question on ER to Relational Mapping and a highly problematic answer 02Dec2021


Identify and correct all mistakes and add all missing elements in the given answer in blue below
to the following question:


Question: ER to Relational Mapping

Map the conceptual design of a database in ER illustrated in Figure 1 below to a relational schema.
Identify primary and foreign keys in your relational schema. Present your relational schema in the
format illustrated in the example below:

Pet {petID, petName, breed, age, owner}
Primary key: petID
Foreign key: owner references Owner(ownerID)
Alternate key: none



PropertyforSale viewedBy Viewer
propertyID {PK} 1..* 1..*
viewerID {PK}
type name
price fName
location lName
date
1..* result
1..1
owns
hasPermitFor
1..1
0..1
Owner
Vehicle
ownerID {PK}
name regNo {PK}
fName make
lName model
postcode
phoneNo [1..*]




Figure 1 A conceptual design in ER