Cynthia Marsh

Byron McCluney

Gwen Marlor

CIS 153-01

Instructor Russell Virgo

18 July 2005

DBDL for Ten-Man Systems

Tenant(TenantNum, Name, Street, City, State, Zip, Phone, ContactPerson, LeaseStart,

LeaseEnd, BaseSales, PercentRate)

CostType(Type, Description)

RentCosts(RentCostNum, TenantNum, Type, Amount, StartDate, EndDate)

FK TenantNum -> Tenant

FK Type -> CostType

AR(ARNum, InvoiceNum, Type, TenantNum, Date, Amount)

FK TenantNum -> Tenant

FK Type -> CostType

ARHistory(ARNum, InvoiceNum, Type, TenantNum, Date, Amount)

FK TenantNum -> Tenant

FK Type -> CostType

TenantSales(TenantNum, Date, Amount)

FK TenantNum -> Tenant

ER Diagram for Ten-Man Systems