Pant

  • $66.00
    Unit price per 
  • Save $23


USE assignment;

CREATE TABLE RepairShop(

ShopID int UNIQUE NOT NULL AUTO_INCREMENT,

StreetNumber int NOT NULL,

StreetName char(30) NOT NULL,

Suburb char(30) NOT NULL,

State char(3) NOT NUll,

ContactNumber int NOT NULL,

NumberOfMechanic int NOT NULL,

CONSTRAINT ShopID_Pk PRIMARY KEY(ShopID)

);

ALTER TABLE ShopID AUTO_INCREMENT = 1;