Question: pls. correcr the errors of the code CREATE TABLE Branch branch No varchar(10) PRIMARY KEY, street varchar(20), city varchar(20) postcode varchar(10) ); CREATE TABLE Staff
CREATE TABLE Branch branch No varchar(10) PRIMARY KEY, street varchar(20), city varchar(20) postcode varchar(10) ); CREATE TABLE Staff staffNo varchar(10) PRIMARY KEY, FName nvarchar(20), LName nvarchar(20), position varchar(15), gender char(1). DOB datetime, salary numeric(8,2). branchNo varchar(10) FOREIGN KEY REFERENCES Branch); CREATE TABLE PrivateOwner ownerNo varchar(10) PRIMARY KEY, Name nvarchar(20), IName nvarchar(20), Address varchar(40), telNo varchar(15)); CREATE TABLE PropertyForRent propertyno varchar(10) PRIMARY KEY, street varchar(20), city varchar(20). postcode varchar(10), type varchar(10) not null, rooms numeric(2) default 4, rent numeric(5,2) default o, ownerNo varchar(10) FOREIGN KEY REFERENCES Private Owner, staffNo varchar(10) FOREIGN KEY REFERENCES Staff, branchNo varchar(10) FOREIGN KEY REFERENCES Branch ); CREATE TABLE Client clientNo varchar(10) PRIMARY KEY, fName nvarchar(20), IName nvarchar(20). telNo varchar(15), prefType varchar(10), maxRent numeric(6,2), eMail varchar(40) ); CREATE TABLE Viewing clientNo varchar(10) constraint clientNo_fk FOREIGN KEY(clientNo) REFERENCES Client, propertyNo varchar(10) FOREIGN KEY REFERENCES Property For Rent, viewDate datetime, comment varchar(100), constraint viewing_pk PRIMARY KEY(clientNo, propertyNo)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
