1. Branch(branchnum, manager, phone, address, size)

branchnum-->manager, phone, address, size
SK    address


2. Employee(empssn, empname, branchnum, worktype, phone, address)
 

empssn-->empname, branchnum, worktype, phone, address
       SK    empname, worktype

3.  Apartmentstyle(stylenum,  bedrooms, sittingrooms, bathrooms,garage, area)

        stylenum-->bedrooms , sittingrooms, bathrooms, garage, area
        SK    bedrooms

4. Price(branchnum, stylenum, prices)
 

FK    branchnum-->Branch   DLT RSTR  UPD CSCD
FK    stylenum    -->Apartmentstyle  DLT CSCD   UPD RSTR
5. Apartment(apartnum, branchnum, stylenum, address, status)
 
SK    stylenum
FK    branchnum-->Branch   DLT  RSTR   UPD CSCD
FK    stylenum    -->Apartmentstyle  DLT CSCD   UPD RSTR
6. Property(propnum, branchnum,propname,proptype,purchdate,status)
 
SK  proptype
FK  brachnum-->Branch    DLT RSTR  UPD CSCS


7.Tenant(tenssn, tenname, phone, apartnum,billstatus)
 

SK    tenname, billstatus
FK    apartnum-->Apartment        DLT RSTR    UPD    RSTR
8. Fixlist( requestnum,apartnum,   requestdate, requesttype,description, empssn, fixdate)
 
SK    requesttype
FK    apartnum -->Apartment    DLT RSTR    UPD RSTR
 
 

 

   Data Structure Diagram