Unanswered: Hey everyone Please help with 3NF(Third Normal Form)
Hi everyone im new to this forum and basically id really appreciate help on third normal form im doing a database assignment in college i dont have much experience with databases, id like every1 who will to look at these tables im using for a database to do with estate agents and tell me what ive got wrong and n e other comments thanks...Also if you wouldnt mind identifying the primary keys i might of left out. The primary keys i have are in bold , thanks ever so much
PROPERTY Property No
No of Bedrooms
Bathrooms with shower and or bath
Living room Size
BUYER Buyer No
VENDOR Vendor No
SOLICITOR Solicitor No
Here is my half-assed effort at normalization of the data you gave. Without knowing the requirements I can only speculate...
This is not 100% complete (to be read, don't turn this in, but look at it and understand what is being done)
if you want to achieve 3NF then there some things to condsider
- Store the addresses in one field and reference them from thier respective table, i.e. a person may be a vendor, seller or buyer at some point in time in the proces
- store the room information as a weak entity from room type. This can provide you room counts etc. any derived value should not be stored in a DB.
- make sure there are tables to store all 'type' references
I have included an ER and the SQL for table generation etc. This is not 100% correct, and data validation wasn't even considered (allow of nulls etc) but again, just look at it.