Requirement # Requirement Hi A client is physically located in one region 2 A consultant can work on many contracts over time A contract will likely...

Normalization

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

• Attachment 1
• Attachment 2

Requirement #RequirementHiA client is physically located in one region2A consultant can work on many contracts over timeA contract will likely require many consultants over time4A contract will likely require many_skills over timei/1A consultant will work only on contracts whose client is physically located in the singleregion to which he she is assigned.6The database design must be presented in a Visio ERDThe database design must reflect that all the entities are in 3" normal formOoAll primary and foreign keys must be indicated on the ERDThere shall be no "surrogate" primary keys to replace natural composite primary keys,(see pp. 179, 217)All the entities shown in the diagram must be consistent with relational tables to in 3rdnormal form (See 3' bullet point at top of page 204 of our text.)