ZuoTi.Pro
Question

Below is a badly designed ERD, where: A lawyer works on many cases, but is in only one section (for example, Civil, Crimin

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

a. Functional Dependencies:

Lawyer# -> LawyerName, Section#, JobTitle

Case# -> ClientName, StartDate,Status, HoursOnCase, LeadLawyer#

Section# -> SectionName

b. Normalization

One Case can have multiple Lawyers and One Lawyer can work on multiple Cases.

Relations in 3NF

Lawyer(Lawyer# , LawyerName, Section#, JobTitle)

Case(Case# , ClientName, StartDate,Status, HoursOnCase, LeadLawyer#)

Section(Section# , SectionName)

CaseLawyer(Case# , Lawyer#)

underlined are primary keys and italicised are foreign keys.

Do ask if any doubt. Please upvote.

0 0
Add a comment
Know the answer?
Add Answer to:
Below is a badly designed ERD, where: A lawyer works on many cases, but is in...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • In this phase of the project you will create an ERD based upon the following requirements and bus...

    In this phase of the project you will create an ERD based upon the following requirements and business rules. Limit your ERD to entities and relationships based on the business rules showed here. In other words, do not add realism to your design by expanding or refining the business rules. However, make sure you include all attributes needed that would permit the model to be successfully implemented, including all primary and foreign keys. 1. Trinity College (TC) is divided into...

  • Read, read and read and then think about that you can create perfectly an enhanced ERD...

    Read, read and read and then think about that you can create perfectly an enhanced ERD for the following description. with making sure to include all kind of entities, attributes, and correct cardinality in relationships between entities. Never forget foreign keys. You need to build a database for the Good College. The College database administrator needs to keep track of the students that attend the College, the courses offered by the college, and the college employees. College tracks the first...

  • This is about ERD. Question: The Gotham Buildings Department (GBD) is a city agency that tracks...

    This is about ERD. Question: The Gotham Buildings Department (GBD) is a city agency that tracks all the buildings within a metropolitan area in the northeast United States. The GBD maintains data about the location, size, and construction date of each building. It also keeps track of specific renovations made to each building over time, and also demolition of a building, if that occurs. For each building, the GBD keeps data about the building's lot number, which is unique, the...

  • ChangeRequest(CRID, CRType, CRTitle, CROriginDate, CRPriority, CRNeedEvent, CRStatus) NeedByEvent(Event) CRPrevState(CRID, CRState, StartDate, EndDate) CRAssigned(CRID, EmpID, StartDate, EndDate)...

    ChangeRequest(CRID, CRType, CRTitle, CROriginDate, CRPriority, CRNeedEvent, CRStatus) NeedByEvent(Event) CRPrevState(CRID, CRState, StartDate, EndDate) CRAssigned(CRID, EmpID, StartDate, EndDate) Employees(EmpID, FirstName, LastName, JobTitle) ChangeRequest(CRID, CRType, CRTitle, CROriginDate, CRPriority, CRNeedEvent, CRStatus) The CRID is the primary key, it is unique, and it is an positive integer The CRType may be one of two values: "Deficiency" or "Enhancement" CRTitle is a variable length string that may be up to 2048 characters CROriginDate is a date CRPriority is an integer that may assume a value of...

  • DATABASE SYSTEMS Project INDIVIDUAL WORK DELIVERABLE #: SUBMISSION DATE No Group Work Allowed Apr...

    DATABASE SYSTEMS Project INDIVIDUAL WORK DELIVERABLE #: SUBMISSION DATE No Group Work Allowed April 8 Introduction to Coursework You have been approached by a University for the design and implementation of a relational database system that will provide information on the courses it offers, the academic departments that run the courses, the academic staff and the enrolled students. The system will be used mainly by the students and the academic staff. The requirement collection and analysis phase of the database...

  • 1. Which article and section of the U.S. Constitution outlines the concept of extradition        (returning fugitives...

    1. Which article and section of the U.S. Constitution outlines the concept of extradition        (returning fugitives to the state where the crime occurred).   2. A member of the Senate can kill a bill by talking it to death in a procedure known as a 3. Who acts as the President of the Senate? 4. Who is the current Speaker of the House of Representatives? 5. Which of the following are a Constitutional requirement for becoming          president of the United States?...

  • Case 15.2    Glaser Machine Works Glaser Machine Works has experienced a significant change in its business...

    Case 15.2    Glaser Machine Works Glaser Machine Works has experienced a significant change in its business operations over the past 50 years. Glaser started business as a machine shop that produced specialty tools and products for the timber and lumber industry. This was a logical fit, given its location in the southern part of the United States. However, over the years, Glaser looked to expand its offerings beyond the lumber and timber industry. Initially, its small size coupled with its...

  • Read this New York Times article linked on the assignment page and share your thoughts. Failed...

    Read this New York Times article linked on the assignment page and share your thoughts. Failed by Law and Courts, Troops Come Home to Repossessions By JESSICA SILVER-GREENBERG and MICHAEL CORKERY MARCH 16, 2015 Charles Beard, a sergeant in the Army National Guard, says he was on duty in the Iraqi city of Tikrit when men came to his California home to repossess the family car. Unless his wife handed over the keys, she would go to jail, they said....

  • Case Incident: As this chapter has shown, emotions are an inevitable part of people’s behavior at...

    Case Incident: As this chapter has shown, emotions are an inevitable part of people’s behavior at work. At the same time, it’s not entirely clear that we’ve reached a point where people feel comfortable expressing all emotions at work. The reason might be that business culture and etiquette remain poorly suited to handling overt emotional displays. The question is, can organizations become more intelligent about emotional management? Is it ever appropriate to yell, laugh, or cry at work? Some people...

  • Case Incident: As this chapter has shown, emotions are an inevitable part of people’s behavior at...

    Case Incident: As this chapter has shown, emotions are an inevitable part of people’s behavior at work. At the same time, it’s not entirely clear that we’ve reached a point where people feel comfortable expressing all emotions at work. The reason might be that business culture and etiquette remain poorly suited to handling overt emotional displays. The question is, can organizations become more intelligent about emotional management? Is it ever appropriate to yell, laugh, or cry at work? Some people...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT