Question: 1 question solve only please fast and read proper instruction Given, the following data and business rules, draw the dependency diagram in 3NF Attribute Name

1 question solve only please fast and read proper instruction

Given, the following data and business rules, draw the dependency diagram in 3NF

Attribute Name	Sample Value	Sample value	Sample Value
CLIENT_NUM	298	289	289
CLIENT_NAME	Marianne R. Brown	James D. Smith	James D. Smith
CLIENT_REGION	Midwest	Southeast	Southeast
CONTRACT_DATE	10-Feb-2010	15-Feb-2010	12-Mar-2010
CONTRACT_NUMBER	5841	5842	5843
CONTRACT_AMOUNT	$2,985,00.00	$670,300.00	$1,250,000.00
CONSULT_CLASS_1	Database Administration	Internet Services	Database Design
CONSULT_CLASS_2	Web Applications		Database Administration
CONSULT_CLASS_3			Network Installation
CONSULT_CLASS_4
CONSULTANT_NUM_1	29	34	25
CONSULTANT_NAME_1	Rachel G. Carson	Gerald K. Ricardo	Angela M. Jamison
CONSULTANT_REGION_1	Midwest	Southeast	Southeast
CONSULTANT_NUM_2	56	38	34
CONSULTANT_NAME_2	Karl M. Spenser	Anne T. Dimarco	Gerald K. Ricardo
CONSULTANT_REGION_2	Midwest	Southeast	Southeast
CONSULTANT_NUM_3	22	45
CONSULTANT_NAME_3	Julian H. Donatello	Geraldo J. Rivera
CONSULTANT_REGION_3	Midwest	Southeast
CONSULTANT_NUM_4		18
CONSULTANT_NAME_4		Donald Chen
CONSULTANT_REGION_4		West

This table was created to enable the manager to match clients with consultants. The objective is to match a client within a given region with a consultant in that region, and to make sure that the clients need for specific consulting services is properly matched to the consultants expertise. For example, if the client need help with database design and is located in the Southeast, the objective is to make a match with a consultant who is located in the Southeast and whose expertise is in database design. (Although the consulting company manage tries to match consultant and client locations to minimize travel expense, it is not always possible to do so.) The following basic business rules are maintained:

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 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 in it. For example, the consulting company might employ many consultants who are networking experts.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Using the INVOICE table structure shown in Table 1 , do the following: Table 1 : \ table [ [ \ table [ [ Attribute ] , [ Name ] ] , Sample Value,Sample Value,Sample Value,Sample Value,Sample Value ]...

To keep track of office furniture, computers, printers, and so on, the CSU DIT uses the table structure shown in Table 1. Please note that BLDG stands for building. Table 1 Sample ITEM Records...

(a) Using the INVOICE table structure given below, do the following questions Attribute Name Sample Value Sample Value Sample Value Sample Value Sample Value INV_NUM 211347 211347 211347 211348...

Use the following STUDENT table structure to do question (b). The sample values of data are provided for your consideration, but you should also base your answers on the common sense about a...

ASSESSMENT DESCRIPTION: Consider the following Scenario: Suppose you have been given the table structure and data given below, which was imported from an Excel spreadsheet. Attribute Name Sample...

Use the following STUDENT table structure to do question (a) . The sample values of data are provided for your consideration, but you should also base your answers on the common sense about a...

1 0 . The manager of a consulting firm has asked you to evaluate a database that contains the table structure shown in Table P 6 . 1 0 . Table P 6 . 1 0 ATTRIBUTE NAME SAMPLE VALUE SAMPLE VALUE...

Assessment Description Using the INVOICE table structure shown in Table 1 , do the following: Table 1 : Attribute Name Sample Value Sample Value Sample Value Sample Value Sample Value INV _ NUM 1 0 0...

To keep track of office furniture, computers, printers, etc. of its different business divisions in different locations, the FOUNDIT company uses the table structure. The sample values of data are...

A P-N junction diode with T = 100 ns conducts a forward-bias current I D = 4.3 mA. At time t = 0, the circuit conditions change, so that a reverse-bias voltage V E = 20 V is connected in series with...

Redemption of Bonds Reynolds Corporation issued $75,000 face value bonds at a discount of $2,500. The bonds contain a call price of 103. Reynolds decides to redeem the bonds early when the...

Calculate and interpret relevant financial ratios, including : - Profitability ratios

A company's inventory records report the following in November of the current year: Date Activities Units Acquired at Cost Units Sold at Retail November 1 Beginning inventory 5 units @ $44 = $220...

4. Create a briefing for division managers showing the advantages and disadvantages of using MOOCs. Use websites, including www.td.org, www.coursera.org, and www.mooc-list.com.

LO3 Identify three types of analyses used to determine training needs.

1. The explosion in technology has led to dramatic changes in how companies deliver training. The process of learning on the go in brief, accessible modules is starting to replace more traditional...