Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning Databases With PostgreSQL From Novice To Professional

Authors: Richard Stones, Neil Matthew

2nd Edition

1590594789, 978-1590594780

Students also viewed these Databases questions