Question

In: Computer Science

Normalization This is a Database Development problem.  Go through all the steps and process of normalization. Do...

Normalization

This is a Database Development problem.  Go through all the steps and process of normalization. Do normalization/dependency diagram FIRST. Then create a dependency diagram normalizing the following business rules to 3NF. Once normalized, create an accurate Entity Relationship Diagram. (ERD)

Business Scenario: You have been hired by a law firm to create a database that keeps track of the specific areas of law that each of their attorneys currently practice and their current caseload.

Business Rules:

1. An attorney can practice any area of law once he/she is admitted to their state’s Bar Association. However, most attorneys specialize in specific areas of law.

2. Our law firm is organized into departments based on the types of cases we receive in the areas of labor law, family law, and personal injury law.

3. Within these main departments, attorneys have specializations. For example, we have some attorneys who only handle worker’s compensation cases in our labor law area.

4. An attorney can only accept cases in their currently assigned department.

5. A client can have many open cases with our law firm at any one time.

6. Each client’s case is assigned to an attorney who specializes in that case’s form of law

Solutions

Expert Solution

Attorney Table

Attorney ID Attorney Name Area of Expertise Case Department Client ID

Client Table

Client ID Client Name Case

First Normal Form

Attorney ID Attorney Name Case
Attorney ID Attorney Name Department

Second Normal Form

Both table satisfies partial dependencies for 2NF

Attorney ID Attorney Name
Attorney ID Department Case Area of Expertise

Third Normal Form

Attorney table

Attorney table contains two transitive dependencies for the following column name i.e., Department and Case. Hence it is placed in a separate table.

Attorney ID Attorney Name
Attorney ID Area of Expertise
Department Case

Client Table

Client name and Case attributes are transitive dependencies.It must be placed in a separate table for the client table.

Client ID Client Name
Client Name Case

Entity Relationship Diagram


Related Solutions

Consumer decision-making process. Go through the six steps of the purchase process outlined in the readings...
Consumer decision-making process. Go through the six steps of the purchase process outlined in the readings and identify where marketing can influence each of the six steps. For example, if a consumer just identified a need for your product in step one, then the company can advertise how your product fills that need. Or, if a consumer purchased your product, the consumer can be called and asked about their satisfaction with the product and if there is any dissatisfaction steps...
All deuterostomes go through the same initial stages of development. What are they? Using the prepared...
All deuterostomes go through the same initial stages of development. What are they? Using the prepared slide of urchin development, make a sketch of each stage. •All chordates possess the same four structures in the early embryo. What are they? Make a sketch of the chick embryo and label these. •What is the difference between adeuterostome, a chordate, and anamniote? Provide examples from lab of each of these. Can an animal fall into more than one of these categories? Which...
why do you think normalization is a necessary step in the creation of your database? list...
why do you think normalization is a necessary step in the creation of your database? list multiple reasons
Do believe that someone needs to go through all the stages of grief to resolve their...
Do believe that someone needs to go through all the stages of grief to resolve their emotions? Do believe that someone needs to go through all the stages of grief to resolve their emotions?
Please Use matlab and show command window. Please go through all steps Using a Dialog button...
Please Use matlab and show command window. Please go through all steps Using a Dialog button with 3 buttons have the user chose one of the 3 anonymous functions below to be used in the later selected three Programmed functions (1) Integral by Trapezoidal Method,(2) Integral by Simpson Method, or (3) Root by BiSection Method.: a. f(x) = 2*x^5 -3*x^2 – 5 b. f(x) = x^2 – 5 c. f(x) = x^(1/2) 2. Using an input statement ask the user...
Explain the new-product development process and product development through acquisition.
Explain the new-product development process and product development through acquisition. 
1) Describe the process of management development. What are the main steps involved in the process?...
1) Describe the process of management development. What are the main steps involved in the process? 2) Discuss the future of training and development in Canada? What changes, if any, can we expect?
Consider the 7 steps of the Systems Development Life Cycle. What two steps in the process...
Consider the 7 steps of the Systems Development Life Cycle. What two steps in the process do you feel is the most critical? Can any steps be left out of the cycle? • Planning • Needs Analysis • Design and Acquisition • Build • Testing • Implementation • Maintenance
Summarize the steps a claim must go through in order to be processed and payment received.
Summarize the steps a claim must go through in order to be processed and payment received.
With regards to Pompe disease discuss the steps an accredited laboratory will go through to reach...
With regards to Pompe disease discuss the steps an accredited laboratory will go through to reach a definitive diagnosis. In your answer you should consider how the laboratory maintains the quality of their service.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT