Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How to do normalization step for this project. This is the DDL commands. Thank you CREATE TABLE Buyer ( buyer _ id INT PRIMARY KEY,
How to do normalization step for this project. This is the DDL commands.
Thank you
CREATE TABLE Buyer buyerid INT PRIMARY KEY, buyername VARCHAR buyeraddress VARCHAR buyercontact INT, occupation VARCHAR salary INT, creditscore INT;CREATE TABLE Properties propid INT PRIMARY KEY, parcelnum VARCHAR propadress VARCHAR numrooms INT, totalsq FLOAT, purchaseamt FLOAT, purchasedate DATE, marketvalue FLOAT,FOREIGN KEY archid REFERENCES ArchitectureStylearchidFOREIGN KEY buyerid REFERENCES BuyerbuyeridFOREIGN KEY agid REFERENCES Agentsagid;CREATE TABLE ArchitectureStyle archid INT PRIMARY KEY, archname VARCHAR archdescrip VARCHAR;CREATE TABLE Employee empid INT PRIMARY KEY, empname VARCHAR empaddress VARCHAR empphone VARCHAR emprole VARCHAR;CREATE TABLE Contractor conid INT PRIMARY KEY, conname VARCHAR conaddress VARCHAR conphone INT
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