Question [CLO3, PLO-37] [15 marks]

The Khan Sons Pvt. Limited is a private construction company that deals in house construction projects. They took different projects from different clients and build their houses. They use the following format to store information of a particular construction project. The house type is either clay or concrete. The construction rate depends upon house type. The concrete rate is higher than clay rate. The company hires different staff members for each project and pay them accordingly. Their daily charges are dependent upon their skills and work experience. Each staff member total working days are calculated and then multiplied with the rate of daily charges which leads to the total amount that need to be paid to the respective staff member.

Your task is to create a relational model to store this information and normalize it.

Project No		001			House Address		House#03, St#1, Phase1, Hayatabad, Peshawar
Project Name		Amjad House			House Owner Name		Mr. Amjad Usman
Project Start Date		01-Oct-2020			House Owner Contact#		0333 6728547
Project Duration		6 months			House Area		7 Marla
House Type		Concrete			Construction Rate		Rs. 280 per Square Foot
Staff No	Staff Name		Daily Charges	Work First Day		Work Last Day	Total Working Days	Total Amount
1	Usman		700	01-oct-2020		31-oct-2020	30	21,000
2	Kamran		700	01-oct-2020		20-oct-2020	20	14,000
3	Noman		800	21-oct-2020		20-nov-2020	30	24,000