CREATE TABLE `abc_real_estate`.`vendor` ( `vendor
id` INT(50) NOT NULL , `name` VARCHAR(50) NOT NULL , `gender` VARCHAR(50) NOT
NULL , `age` VARCHAR(50) NOT NULL ) ENGINE = InnoDB;
Property vendor-
CREATE TABLE `abc_real_estate`.`property
vendor` ( `property_id` INT(50) NOT NULL , `vendor
id` INT(50) NOT NULL ) ENGINE = InnoDB;
Agent table-
CREATE TABLE `abc_real_estate`.`agent` ( `AGENT_ID` INT(50) NOT NULL , `name` VAR
CHAR(50) NOT NULL , `gender` VARCHAR(50) NOT NULL , `age` VARCHAR(50) NOT N
ULL ) ENGINE = InnoDB;
Purchase table-
CREATE TABLE `abc_real_estate`.`purchase` ( `purchase id` INT(50) NOT NULL , `property
id` INT(50) NOT NULL , `AGENT_ID` INT(50) NOT NULL , `AUCTION` VARBINARY(50)
NOT NULL , `SALE_PRICE` INT(50) NOT NULL , `CONTRACT_DATE` DATE NOT NUL
L , `SETTLEMENT_DATE` DATE NOT NULL ) ENGINE = InnoDB;
TASK 2
Insert MySQL Statement-
INSERT INTO `property` (`property_id`, `STREET_ADDRESS`, `SUBURB`, `STATE`,
`STATUS`, `TYPE`, `LIST_PRICE`, `DATE_CREATED`, `DATE_EDITED`) VALUES
('10001', 'Howard street ', 'Aarons Pass', 'New South Wales', 'listed', ' residential', '12222333',
'2021-04-19', '2021-04-21'), ('10002', 'Crown plaza', 'Abbotsford (NSW)', 'New South Wales',
4

+13062052269

info@desklib.com

Database Fundamentals: Introduction, Tasks, and Case Study

Contribute Materials