Each client is located in one region.

A region can contain many clients.

Each consultant can work on many contracts.

Each contract might require the services of many consultants.

A client can sign more than one contract, but each contract is signed by only one client.

Each contract might cover multiple consulting classifications. For example, a contract may list consulting services in database design and networking.

Each consultant is located in one region.

A region can contain many consultants.

Each consultant has one or more areas of expertise $($class$).$ For example, a consultant might be classified as an expert in both database design and networking.

Each area of expertise $($class$)$ can have many consultants. For example, the consulting company might employ many consultants who are networking experts.

a$.$ Given this brief description of the requirements and the business rules, write the relational schema and draw the dependency diagram for the preceding $($and very poor$)$ table structure. Label all transitive and$/$or partial dependencies.

b$.$ Break up the dependency diagram you drew in Problem $10$a to produce dependency diagrams that are in $3$NF and write the relational schema. $($Hint: You might have to create a few new attributes. Also make sure that the new dependency diagrams contain attributes that meet proper design criteria; that is$,$ make sure there are no multivalued attributes, that the naming conventions are met, and so on$.)$

c$.$ Using the results of Problem $10$b$,$ draw the Crow's Foot ERD.