Question

Q.No.1 Convert following conceptual design into logical design: Supervisor Supervises Registers Optional) 0.10 Staff staffNo (PK) namo fName IName position Sex DOB 0..1 Manages 0_100 Property For Rent property No PK) address street city postcode type rooms rent 1..1 Associated with Views Clent dentNo (PK) name Namo IName telo 1.. viewDate comment Owns Holds States 0. Owner ownerNo {PK) address telo {Manciatory, Ort Preference profТуро maxRont Lease TeaseNo {PK) payment Method dopositPaid rentStart rentFinish Ideposit duration Private Owner Business Owner name fNamo IName bName bТуро contactNamo

Answer 1

Logical design

Staff(staffNo, fName, lName, position, sex,DOB, supervisorStaffNo)

PropertyForRent(propertyNo, street, city, postcode,type,rooms,rent, staffNo,ownerNo)

Views(propertyNo, clientNo, viewDate,comment)

Client(clientNo, fName,lName,telNo, staffNo)

Owner(ownerNo, address, telNo)

PrivateOwner(ownerNo, fName,lName)

BusinessOwner(ownerNo, bName, bType, contactName)

Lease(leaseNo, paymentMethod, depositPaid, rentStart, rentFinish, deposit, duration,propertyNo,clientNo)

Preference(clientNo, prefType, maxRent)

bold attributes are primary keys and italicized are foreign keys.

Do ask if any doubt. Please up-vote.