What type of table

[terry sarah]

I just started learning SQL and have 2 questions:
1. Please help me to define what type of table (ie:lookup table) for the 
following 
   table names:
   Table: Contract     
      ContractId
      ContractNm
      ContractTypeId
      PayerId
   Table: Payer      
      PayerId
      PayerNm
   Table: Contract_Type 
      ContractTypeId
      ContractTypeDesc
   Table: Client   
      ClientId
      ClientNm
   Table: Contract_Client      
      ContractClientId
      ContractId
      ClientId
      ContractStartDt
      ContractEndDt
2. There will be data which is unique to the association of a payer and a 
contract 
  and the new data will be in a column named “Amendment”.
  A contract can have one or more payers.
  A payer can belong one or more contracts.
  How would you modify the database model?
Please let me know. Thank you

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2810
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6