Normalization

Sign in to answer this question.

• IH

  Iftikar Hussain13y agoPosted Aug 24, 2013, 10:20 AM

  Hi,
          Here it is
  
  

  RentInfo

  ------------

  RentId int identity (PK)

  Owner_No  varchar(10)  (FK)

  Property_No varchar(10) (FK)

  Customer_No varchar(10) (FK)

  RentStart date,

  RentFinish dte,

  Rent money

  
  

  OwnerInfo

  ---------------

  Owner_No varchar(10) (PK)

  OName varchar(50)

  
  

  PropertyInfo

  -------------------

  Property_No varchar(10) (PK)

  PAddress varchar(100)

  
  

  CustomerInfo

  ---------------------

  Customer_No varchar(10) (PK)

  CName varchar(50)

  
  Regards,
  Iftikar