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