Question: How do i put this information into first second and third form of normalization? Agents agent _ id ( PK ) - - int agent
How do i put this information into first second and third form of normalization?
Agents
agentid PK int
agentname varchar
agentaddress varchar
agentphone int
parcelnumber FK int
Properties
propertyid PK int
parcelnumber varchar
propertyaddress varchar
numberofrooms int
squarefootage float
purchasedate date
purchaseamount float
marketvalue float
archid FK int
Architecture Style
styleid PK int
archname varchar
archdescription varchar
Buyer Property
buyerid PK int
parcelnumber FK int
Agent Property
agentid PK int
parcelnumber FK int
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
