Assume that you have just been hired hired to work for a new IT consulting firm, and your boss, the CIO, has just asked you to design a database to be used in-house. The only information available is what is shown in figures 1 and 2 below. Your design must be consistent with this information. Figure 1 Attribute Name CLIENT NUM CLIENT NAME CLIENT REGION CONTRACT DATE CONTRACT NUMBER CONTRACT AMOUNT SKILL 1 SKILL 2 SKILL 3 SKILL 4 CONSULTANT NUM 1 CONSULTANT NAME1 CONSULTANT REGION 1 Midwest CONSULTANT NUM 2 CONSULTANT NAME 2 CONSULTANT REGION 2 Midwest CONSULTANT NUM 3 CONSULTANT NAME 3 CONSULTANT REGION 3 Midwest CONSULTANT NUM 4 ue mple value am 289 James D. Smith Southeast 12-Mar-2018 5843 $1.250,000.00 Database Design Database Administration Network Installation ue 298 Marianne R. Brown Midwest 10-Feb-2018 5841 James D. Smith Southeast 15-Feb-2018 5842 Database Administration Internet Services Web Applications 29 34 Gerald K. Ricardo Angela M. Jamison Southeast 38 Anne T. Dimarco Gerald K. Ricardo Southeast 25 Rachel G. Carson Southeast 34 Karl M. S Southeast Julian H. Donatello Geraldo J. Rivera Southeast 18 Donald Chen West CONSUL TANT NAME 4 CONSULTANT REGION 4 Figure 2 urement # uirement A client is physically located in one region A consultant can work on many contracts over time A contract will likel A contract will likely r A consultant will work only on contracts whose client is physically located in the single region to which he/she is assigned. The database design must be presented in a Visio ERD The database desigm must reflect that all the entities are in 3rd normal form All There shall be no see pp. 179, 217 All the entities shown in the diagram must be consistent with relational tables to in 3rd normal form (See 3d bullet point at top of page 204 of our text. e many consultants over time many skills over time and foreign keys must be indicated on the ERD to replace natural composite primary keys, Assume that you have just been hired hired to work for a new IT consulting firm, and your boss, the CIO, has just asked you to design a database to be used in-house. The only information available is what is shown in figures 1 and 2 below. Your design must be consistent with this information. Figure 1 Attribute Name CLIENT NUM CLIENT NAME CLIENT REGION CONTRACT DATE CONTRACT NUMBER CONTRACT AMOUNT SKILL 1 SKILL 2 SKILL 3 SKILL 4 CONSULTANT NUM 1 CONSULTANT NAME1 CONSULTANT REGION 1 Midwest CONSULTANT NUM 2 CONSULTANT NAME 2 CONSULTANT REGION 2 Midwest CONSULTANT NUM 3 CONSULTANT NAME 3 CONSULTANT REGION 3 Midwest CONSULTANT NUM 4 ue mple value am 289 James D. Smith Southeast 12-Mar-2018 5843 $1.250,000.00 Database Design Database Administration Network Installation ue 298 Marianne R. Brown Midwest 10-Feb-2018 5841 James D. Smith Southeast 15-Feb-2018 5842 Database Administration Internet Services Web Applications 29 34 Gerald K. Ricardo Angela M. Jamison Southeast 38 Anne T. Dimarco Gerald K. Ricardo Southeast 25 Rachel G. Carson Southeast 34 Karl M. S Southeast Julian H. Donatello Geraldo J. Rivera Southeast 18 Donald Chen West CONSUL TANT NAME 4 CONSULTANT REGION 4 Figure 2 urement # uirement A client is physically located in one region A consultant can work on many contracts over time A contract will likel A contract will likely r A consultant will work only on contracts whose client is physically located in the single region to which he/she is assigned. The database design must be presented in a Visio ERD The database desigm must reflect that all the entities are in 3rd normal form All There shall be no see pp. 179, 217 All the entities shown in the diagram must be consistent with relational tables to in 3rd normal form (See 3d bullet point at top of page 204 of our text. e many consultants over time many skills over time and foreign keys must be indicated on the ERD to replace natural composite primary keys