Entites and Attributes

•  Entities that need to store data

1. system_login
2. company
3. property
4. employee
5. buyer

• Attributes that describe the Entities

Entity	Attributes
1.     system_login	login_username : (varchar)
	login_passward : (int)
2.     company	com_name : (text)
	com_reg_no : (int)
	phone_no : (int)
	address : (varchar)
3.     property	ID_no : (int)
	Type : (text)
	size : (varchar)
	location : (varchar)
	estimate_value : (double)
	com_reg_no : (int)
4.     employee	empolyee_ID : (int)
	name  : (text)
	gender : (char)
	NIC_no : (varchar)
	Address : (varchar)
	DOB : (date)
	phone_no : (int)
	com_reg_no : (int)
5.     buyer	buyer_ID : (int)
	name : (text)
	NIC_no : (varchar)
	phone_no : (int)
	address : (varchar)
	com_reg_no : (int)