EXPLAIN AND CREATE ERD DIAGRAM 1. AN EXMAPLE FOR YOU TO DO: NORMALIZATION Given the following relation
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. AN EXMAPLE FOR YOU TO DO: NORMALIZATION Given the following relation and functional dependencies: COORDINATES (UnitCode, Semester, Option, Coordinator) FD: UnitCode, Semester, Option Coordinator What is (are) the candidate key(s)? Which NF is the relation in? Convert the relation into a relation or set of relations in at least 3NF 2. AN EXAMPLE FOR YOU TO DO: THE PLUMBING BUSINESS CASE An information system is required for a small plumbing business. A customer will contact the business with a request for work to be carried out. Acustomer has a unique customer number, a name, and a billing address (street, suburb, state, postcode). Awork order has a unique work order number, a creation date, a completion required date, a completion date, an optional supervising employee, an address where the work is undertaken, and a set of tasks. Each task has a unique task ID, a task name, an hourly rate, and estimated hours. Tasks are standardised across work orders so that the same task may be performed on many work orders. Each task on a work order has a status (not started, in progress, or completed), actual hours, and a completion date. The completion date is not entered until the status changes to complete. Complete an ERD including all the legends according to the above instruction 1. AN EXMAPLE FOR YOU TO DO: NORMALIZATION Given the following relation and functional dependencies: COORDINATES (UnitCode, Semester, Option, Coordinator) FD: UnitCode, Semester, Option Coordinator What is (are) the candidate key(s)? Which NF is the relation in? Convert the relation into a relation or set of relations in at least 3NF 2. AN EXAMPLE FOR YOU TO DO: THE PLUMBING BUSINESS CASE An information system is required for a small plumbing business. A customer will contact the business with a request for work to be carried out. Acustomer has a unique customer number, a name, and a billing address (street, suburb, state, postcode). Awork order has a unique work order number, a creation date, a completion required date, a completion date, an optional supervising employee, an address where the work is undertaken, and a set of tasks. Each task has a unique task ID, a task name, an hourly rate, and estimated hours. Tasks are standardised across work orders so that the same task may be performed on many work orders. Each task on a work order has a status (not started, in progress, or completed), actual hours, and a completion date. The completion date is not entered until the status changes to complete. Complete an ERD including all the legends according to the above instruction
Expert Answer:
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date:
Students also viewed these databases questions
-
Read the scenario below and answer the questions that follow: It's a man's world ... Since childhood, Thandi has been good at repairing all kinds of things in and around the house, and was always...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
Muskoka Boys Shaving Co. (MBSC") is a GST/HST registrant operating an online store in Ontario's cottage country region. The company specializes in selling fine grooming products for men. It is June...
-
A balanced experimental design has a sample size of n = 14 observations at each of k = 4 factor levels. The averages and variance estimates at each of the four factor levels are 1 = 0.705 and s21 =...
-
(a) Calculate the maximum rate at which a rocket can expel gases if its acceleration cannot exceed seven times that of gravity. The mass of the rocket just as it runs out of fuel is 75,000-kg, and...
-
List three classes of short-term liability and two classes of long-term liability that will appear in the typical balance sheet.
-
Bracewell Company reported net income of $195,000 for 2014. Bracewell also reported depreciation expense of $40,000 and a gain of $5,000 on disposal of plant assets. The comparative balance sheet...
-
Ch 22 Homework i Saved 3 5 points Diaz Company is a retail store with two operating departments, Clothes and Shoes. Information follows. For Year Ended December 31 Sales Cost of goods sold Direct...
-
Get It Right, CPAs, has been retained to review its client's corporate formation calculations for 20XX. Maria, Roger, and Novak created Grassroots Tennis, Inc. (GTI), which began operations on March...
-
Assume you win this prize, you expect to live for 50 more years and you choose your niece who is 6 years old as the person to receive the prize after your life.You expect your niece to live to 80...
-
What do you think the reaction of the staff would be if a company switched from being organized on departmental lines to being based on activities so that staff worked in multi- disciplinary teams?...
-
How do you decide whether or not a transaction is material?
-
By this stage of the book you should have a good knowledge of the purpose of manage- ment accounting and the techniques used. List three changes that you would like to see incorporated into...
-
To gain assurance that all inventory items in a client's inventory listing schedule are valid, an auditor most likely would trace a. Inventory tags noted during the auditor's observation to items...
-
Do you think that the structure of a manufacturing account makes it easy to follow? Are you clear about the meaning of each individual item? What does the information tell you about the cost of...
-
In Pharoah Company, total materials costs are $37,000, and total conversion costs are $60,480 for June. Equivalent units of production are materials 10,000 and conversion costs 12,000. (a1) Your...
-
Question 2 For an n x n matrix A = form) via (aij)
-
List (tabulate) the metadata available in the ER diagram in Exercise 23 on the next page and indicate the ones captured in the logical (relational) schema of design 23(a) and design 23(b)
-
Modify the pervious query to that instead of displaying as one of the totals the total number pounds of milk produced in each region, the total number of pounds of milk produced in each year across...
-
This vignette is a small excerpt from a comprehensive case about a clinic. Various physicians and surgeons working for a clinic are on an annual salary [o]. These doctors are identified by their...
-
Question: In 1572, during the reign of Queen Elizabeth I of England, a patent application was filed for a knife with a bone handle rather than a wooden one. Would this patent be granted under current...
-
Question: Craigslist, Inc., runs a Web site for classified ads, including ads for the sale and rental of houses and apartments. Some of the posted ads were discriminatory (although not consistent),...
-
Question: Cruise.com operated a Web site selling cruise vacations. It sent unsolicited e-mail advertisements-dubbed "E-deals"-to prospective customers. Eleven of these "E-deals" went to...
Study smarter with the SolutionInn App