Create the "Alexamara Marina Group" Database Tables


The Marina table
Column Name Data Type Allow Nulls Other Properties
MarinaNum
(Primary Key)
int No Identity Specification
      (Is Identity) = Yes
      Identity Increment = 1
      Identity Seed = 1
Name varchar(20) No  
Address varchar(20) No  
City varchar(15) No  
State varchar(2) No  
Zip varchar(5) No  

The Owner table
Column Name Data Type Allow Nulls Other Properties
OwnerNum
(Primary Key)
varchar(4) No  
LastName varchar(10) No  
FirstName varchar(18) No  
Address varchar(20) No  
City varchar(15) No  
State varchar(2) No  
Zip varchar(5) No  

The MarinaSlip table
Column Name Data Type Allow Nulls Other Properties
SlipID
(Primary Key)
int No Identity Specification
      (Is Identity) = Yes
      Identity Increment = 1
      Identity Seed = 1
MarinaNum int No Foreign Key into Marina table
SlipNum varchar(2) No  
Length int No  
RentalFee money No  
BoatName varchar(20) No  
BoatType varchar(15) No  
OwnerNum varchar(4) No Foreign Key into Owner table

The ServiceCategory table
Column Name Data Type Allow Nulls Other Properties
CategoryNum
(Primary Key)
int No Identity Specification
      (Is Identity) = Yes
      Identity Increment = 1
      Identity Seed = 1
CategoryDescription varchar(60) No  

The ServiceRequest table
Column Name Data Type Allow Nulls Other Properties
ServiceID
(Primary Key)
int No Identity Specification
      (Is Identity) = Yes
      Identity Increment = 1
      Identity Seed = 1
SlipID int No Foreign Key into MarinaSlip table
CategoryNum int No Foreign Key into ServiceCategory table
Description varchar(150) Yes  
Status varchar(150) Yes  
EstHours int No  
SpentHours int No  
NextServiceDate date Yes