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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started