Vic DeMon has started a consulting firm and needs some help with his database to assist him matching clients with consultants. The current table structure is below with sample data.

ClientNum ClientName Client$\_$Reg ContractDate Contract$\_$Num Contract$\_$Amt Cons$\_$Class ConsNum ConsName ConsReg

$298$ Marcus Jones Midwest $10-$Feb$-225841$ $$2,985,000$ Database Administrator

Web Applications $29$

$56$ Curtis Penrod

Begona Perez Midwest

Northwest

$290$ Greg Handel Southwest $15-$Feb$-23$

$12-$March$-235842$

$5843$ $$670,300$

$$1,250,000$ Internet Services

Database Design

Network Installation $34$

$32$

$29$

$48$

$34$ Eddie Horton

Jason Powell

Curtis Penrod

Sarah Wright

Eddie Horton Southwest

Southeast

Midwest

Northeast

Southwest

Vic$$s objective is to match a client within a given region to a consultant in that region. He also wants to be sure the consulting need of the client will match the consultant$$s area of expertise. For example, if a client in the northwest needs network installation, Vic would like to match them to a consultant that is in the northwest and specializes in network installation. While he would like to minimize travel expenses where he can, he knows this is not always possible. The following are the basic business rules.

$$ 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. $($i$.$e$.,$ Database design and network installation$)$

$$ Each consultant is located in one region

$$ A region can contain many consultants

$$ Each consultant has one or more areas of expertise $($class$)$

$$ Each area of expertise $($class$)$ can have many consultants in it$.$

Given the business rules and brief description of the company needs, complete the following tasks in a Word document or similar word processing software.

Take the unnormalized table structure and convert it to $1$NF$.$ Display the table structure in your document.

Draw or create a dependency diagram, labeling all partial and transitive dependencies. $($You can draw this or use draw.io$)$

Complete the relational schema for the $1$NF design.

Using the dependency diagram completed in part $2$ and the relational schema in part $3,$ complete a relational schema for the $2$NF design.

Using the dependency diagram completed in part $2$ and the relational schema created in part $4,$ complete the relational schema for the $3$NF design.

Display the $3$NF table structure with sample data in your document.

Using the business rules and $3$NF structure, complete the Crow$$s Foot ERD for this database. Remember that as you create the ERD, you may see many to many relationships that need to be handled. This could require adding more entities and$/$or attributes.

You can use draw.io for dependency diagrams and the ERD. You can export these diagrams and the ERD as JPEG or PNG$.$ These images can then be inserted into your Word Document. Be sure to present the results of this assignment in an organized format. Your instructor should not have to guess which task you completed.