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

pls. correcr the errors of the code
pls. correcr the errors of the code CREATE TABLE Branch branch No

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!