Answered step by step
Verified Expert Solution
Link Copied!

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 ( buyer_id INT PRIMARY KEY, buyer_name VARCHAR(250), buyer_address VARCHAR(250), buyer_contact INT, occupation VARCHAR(250), salary INT, credit_score INT);CREATE TABLE Properties ( prop_id INT PRIMARY KEY, parcel_num VARCHAR(250), prop_adress VARCHAR(250), num_rooms INT, total_sq FLOAT, purchase_amt FLOAT, purchase_date DATE, market_value FLOAT,FOREIGN KEY (arch_id) REFERENCES Architecture_Style(arch_id),FOREIGN KEY (buyer_id) REFERENCES Buyer(buyer_id),FOREIGN KEY (ag_id) REFERENCES Agents(ag_id));CREATE TABLE Architecture_Style ( arch_id INT PRIMARY KEY, arch_name VARCHAR(250), arch_descrip VARCHAR(250));CREATE TABLE Employee ( emp_id INT PRIMARY KEY, emp_name VARCHAR(250), emp_address VARCHAR(250), emp_phone VARCHAR(20), emp_role VARCHAR(250));CREATE TABLE Contractor ( con_id INT PRIMARY KEY, con_name VARCHAR(250), con_address VARCHAR(250), con_phone INT
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Successful Keyword Searching Initiating Research On Popular Topics Using Electronic Databases

Authors: Randall MacDonald, Susan MacDonald

1st Edition

0313306761, 978-0313306761

More Books

Students also viewed these Databases questions