Relational Schema
- Customer (customer_id, customer_name, nic, address, email)
- Customertelephone (customer_id, telephone_num)
- Property (property_id, property_name, property_type, address, area, estimated_value)
- Employee (emp_id, name, emp_type, address, email, telephone_num)
- Rent (rent_id, property_id, customer_id, amount, duration)
- Rentproperty (rend_id, property_id, rent_date_time)
- Buyer (buyer_id, buyer_name, address, email, telephone_num)
- Lease (lease_id, property_id, customer_id, amount, duration)
- Leaseproperty (lease_id, property_id, lease_date_time)
- Sale (sale_id, property_id, customer_id, amount)
- Saleproperty (sale_id, property_id, sale_date_time)
Tags
MYSQL Programming