Create the Solmaris Condominium Group Database Tables


The Location table
Column Name Data Type Allow Nulls Other Properties
LocationNum
(Primary Key)
int No Identity Specification
      (Is Identity) = Yes
      Identity Increment = 1
      Identity Seed = 1
LocationName varchar(20) No  
Address varchar(20) No  
City varchar(15) No  
State varchar(2) No  
PostalCode 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  
PostalCode varchar(5) No  

The CondoUnit table
Column Name Data Type Allow Nulls Other Properties
CondoID
(Primary Key)
int No Identity Specification
      (Is Identity) = Yes
      Identity Increment = 1
      Identity Seed = 1
LocationNum int No Foreign Key into Location table
UnitNum varchar(3) No  
SqrFt int No  
Bdrms int No  
Baths int No  
CondoFee money 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
CondoID int No Foreign Key into CondoUnit 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