write down any assumptions that you made. An assumption may not be in contradiction with the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
write down any assumptions that you made. An assumption may not be in contradiction with the given text. This firm assists two types of customers; the business people and the public. They are three partners who specialize in different types of legal cases. Their office is in Dubai and has branches in all emirates of the UAE. Each branch is administered by an office administer has this attributes Branch Code, Contact Name. Title. Contact Number, City. Email, Physical Address, Employee Number, Case Number They employ two office administrators and two assistant staff (cleaning and tea making) in the Pretoria office and one office administrator and one assistant staff at each branch. Their prices differ according to the complexity of the case they've to handle and the type of client they are servicing. All employees have these attributes: Employee ID. Surname Names. Gender IDNo, Address, Cellphone, Hiredate and Salary. Each administrator will be allocated a docket or more. Each of the employee has a single banking account were the firm deposit the employee's salary. All public customers have Customer Number. Surname Names, Gender IDNo. Business Name, Work Phone, Cellphone and Email. Each client can open a docker or more with these attributes Case Number, Date Opened. Description, Cost. Verdict, Balance and Branch Code Employee Number, Customer No. Each client's docket(s) can be moved from one administrator to another at the discreer of the firm's partners. A client can have a file at any nearest branch of which the case has been opened. They(clients) have to their accounts by cash, stop orders or internet transfer Except when they pay at the offices the other payments must be verified by faxing the copy of the receipt to the head office. The fees collected from client are counted as of one firm than as of each individual A. From the case study define all of the entities and relationships. List the entity and how it relates to the other entity. Show also how they are connected. B. Give an ER diagram for the case described above. The ER diagram should at least contain: all entities all attributes described in the case (also mention identifiers that you introduced) relationships maximum and minimum cardinalities . write down any assumptions that you made. An assumption may not be in contradiction with the given text. This firm assists two types of customers; the business people and the public. They are three partners who specialize in different types of legal cases. Their office is in Dubai and has branches in all emirates of the UAE. Each branch is administered by an office administer has this attributes Branch Code, Contact Name. Title. Contact Number, City. Email, Physical Address, Employee Number, Case Number They employ two office administrators and two assistant staff (cleaning and tea making) in the Pretoria office and one office administrator and one assistant staff at each branch. Their prices differ according to the complexity of the case they've to handle and the type of client they are servicing. All employees have these attributes: Employee ID. Surname Names. Gender IDNo, Address, Cellphone, Hiredate and Salary. Each administrator will be allocated a docket or more. Each of the employee has a single banking account were the firm deposit the employee's salary. All public customers have Customer Number. Surname Names, Gender IDNo. Business Name, Work Phone, Cellphone and Email. Each client can open a docker or more with these attributes Case Number, Date Opened. Description, Cost. Verdict, Balance and Branch Code Employee Number, Customer No. Each client's docket(s) can be moved from one administrator to another at the discreer of the firm's partners. A client can have a file at any nearest branch of which the case has been opened. They(clients) have to their accounts by cash, stop orders or internet transfer Except when they pay at the offices the other payments must be verified by faxing the copy of the receipt to the head office. The fees collected from client are counted as of one firm than as of each individual A. From the case study define all of the entities and relationships. List the entity and how it relates to the other entity. Show also how they are connected. B. Give an ER diagram for the case described above. The ER diagram should at least contain: all entities all attributes described in the case (also mention identifiers that you introduced) relationships maximum and minimum cardinalities .
Expert Answer:
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these databases questions
-
A nonprofit is attempting to get residents in a neighborhood to come out to help clean parks in the area. They go house to house placing flyers on the doors. What communication method is being used?
-
Jack Dawn Milo (her Daddy wanted a boy) age 37 lived at 416 Grouse Avenue, Allentown, PA 18105. Jacks mother, Lulu Belle Taxdeduction age 65, is a resident of Windsor, Canada. Jack provides all of...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Match the cooking or preparation method to the relevant equipment. EQUIPMENT METHOD Food processor with a grater attachment or box grater Baking Range, pot or deep fryer, spatula or tongs Boiling...
-
Recent communication with the inhabitants of Neptune have revealed that they have a Celsius-type temperature scale, but based on the melting point (OoN)and boiling point (I OOoN)of their most common...
-
A compound has a molecular formula of C8H14O4, and its infrared spectrum contains an intense peak at 1730 cm -1. The 1H NMR spectrum of the compound is shown in Figure 20.11. What is its structure?...
-
ZipRecruiter periodically issues reports on wages of entry-level workers. They reported that entry-level wages for college graduates who took jobs in Deer Park, California were \($23.69\) per hour...
-
Perioto Inc. currently charges manufacturing overhead costs to products using machine hours. However, company management believes that the use of ABC would provide more realistic cost estimates and,...
-
Describe how organizations, utilize approaches and methods that drive forward the design of the employee experience, improve productivity, and enable high-performing talent practices to be...
-
a. To simplify the analysis, assume for now that there is virtually no turnaround time between flights so the next flight can begin as soon as the current flight ends. (If an immediate next flight is...
-
45. The price of circuit boards used in the manufacturing of LCD televisions has fallen. This will lead to LCD televisions. O a decrease in the quantity supplied of O a decrease in the supply of O an...
-
In 2008, Massachusetts decriminalized small amounts of marijuana possession and subsequently legalized it in 2016 and criminalized bullying behaviors in school settings (2010) and most recently the...
-
What does this statement mean and how to disagree with it "The creed which accepts as the foundation of morals, Utility, or the Greatest Happiness Principle, holds that actions are right in...
-
Question 9 ( 1 point ) Portmain Industries management has budgeted the following amounts for its next fiscal year: Increase competition in the market has forced management to consider a price...
-
You purchased an item from a store which provides you with a lifetime guarantee. Two years later the item just stops working. When you go back to the store to have it replaced, you are charged a...
-
A restaurant decided to decorate for the holiday season and asked Michael to come in on the weekend to put up the outdoor decorations and lights. The supervisor stated that a "big, strong man like...
-
Question 7 (Multiple Choice Worth 1 points) (04.01 MC) Polygon PQRST shown below is dilated with a scale factor of 3, keeping the origin as the center of dilation: I' T 10 9 818 6 A+ON+ y ts 3 ts +++...
-
An educational researcher devised a wooden toy assembly project to test learning in 6-year-olds. The time in seconds to assemble the project was noted, and the toy was disassembled out of the childs...
-
Explain how a Balanced Scorecard approach is helpful in identifying critical processes and evaluating the processes.
-
Planning and flexible budget variances Tang Company??s production performance report for April includes the information shown below. Prepare a flexible budget for the items shown and compute the...
-
It is impossible for an organization to focus on the 20 to 30 different measures that result if each of the four Balanced Scorecard perspectives contains between four to eight measures.
-
Pegasus Veterinary Hospital (PVH) is a partnership of five veterinarian surgeons who specialize in treating horses. PVH is located in a $25 million facility on 20 acres of land, employing over 40...
-
A tender evaluation method specifies 60% price and 40% quality. What is the weighted score of a tender that scored 80 points (out of 100) for price and 60 for quality?
-
You are a recently appointed purchasing manager who is overseeing terms and con- ditions of contract for an important international purchase with a UN country. What rules should you be particularly...
Study smarter with the SolutionInn App