Is there an answer to this Entity Relationship Modeling? Requirements: The company has several branch offices. Each
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Requirements: The company has several branch offices. Each branch is identified by a branch_number. The name, address (street, city, ZIP), and revenue_target of each branch office are maintained. Each branch has one manager and the manager's employee_ID is maintained. Each employee has a unique employee_ID. The company maintains the name, designation, starting_date, branch_number, salary, and supervisor's employee_ID for each employee. Each product sold by the company is identified by a unique Product_code. The description, unit price, and stock_level of each product are maintained. Each type of installation performed by the company is identified by a unique installation_type. The description and the billing_rate per hour for the installation_type are maintained. Customers are identified by unique customer_ID. Information is maintained on each customer's address (street, city, ZIP) and phone_number. Customer orders are identified by unique order_numbers. Each order is placed by a unique customer on a specific date. An employee is responsible for the order. A customer order may include orders for multiple products and installations. For each product in an order, the quantity_ordered is recorded. For each installation_type ordered, the estimated number_of_hours for installation is recorded. Requirements: The company has several branch offices. Each branch is identified by a branch_number. The name, address (street, city, ZIP), and revenue_target of each branch office are maintained. Each branch has one manager and the manager's employee_ID is maintained. Each employee has a unique employee_ID. The company maintains the name, designation, starting_date, branch_number, salary, and supervisor's employee_ID for each employee. Each product sold by the company is identified by a unique Product_code. The description, unit price, and stock_level of each product are maintained. Each type of installation performed by the company is identified by a unique installation_type. The description and the billing_rate per hour for the installation_type are maintained. Customers are identified by unique customer_ID. Information is maintained on each customer's address (street, city, ZIP) and phone_number. Customer orders are identified by unique order_numbers. Each order is placed by a unique customer on a specific date. An employee is responsible for the order. A customer order may include orders for multiple products and installations. For each product in an order, the quantity_ordered is recorded. For each installation_type ordered, the estimated number_of_hours for installation is recorded.
Expert Answer:
Related Book For
Essentials of Database Management
ISBN: 978-0133405682
1st edition
Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman
Posted Date:
Students also viewed these databases questions
-
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...
-
Explain the meaning of the terms emoluments, employments and office for the purposes of PAYE as you earn systems. 2. Explain the actual receipts basis of assessing the emoluments from the employment...
-
Why is an objects internal data usually hidden from outside code?
-
It is specified that a certain type of iron should contain .85 g of silicon per 100 g of iron (.85%). The silicon content of each of 25 randomly selected iron specimens was determined, and the...
-
Everything else held constant, will an increase in the amount of inventory on hand increase or decrease the firm's profitability?
-
When Bernie Marcus and Arthur Blank opened the first Home Depot store in Atlanta in 1979, they forever changed the hardware and home-improvement retailing industry. Marcus and Blank envisioned huge...
-
The Keener Company has had 1,000 shares of 7%, $100 par-value preferred stock and 40,000 shares of $5 stated-value common stock outstanding for the last three years. During that period, dividends...
-
n Show that O(log n)
-
A construction company wants to determine the optimal replacement policy for the earth mover it owns. The company has a policy of not keeping an earth mover for more than five years, and has...
-
Report shows that the average person watched 4.55 hours of TV per day in 2005. A random sample for 20 people showed an average of 4.76. The population standard deviation was 2.297 for last year. Was...
-
// Write a program that demostrates how to enter 3 test grades, which // calculates the average test grade. import java.util.Scanner; // Needed for the Scanner class Il so you can input the test...
-
What do you believe are the barriers to successful communication in the world of work and what would you recommend overcoming them?
-
Although not all clients use A&R for both services, about 7 0 percent do . A&R bills audit services based on billable hours and advising services at a fixed fee. The cost for audit services is...
-
1. You own a delayed perpetuity. It pays $200 per year, starting at the end of year five. If the annual interest rate is 4%, what is its current value to you? 2. You are renting some fields to a...
-
How would Yeti account for the contingent liability arising from a recall of its soft coolers and gear cases? Yeti is recalling nearly two million soft coolers and gear cases, including the Hopper...
-
Lamont Company is a Canadian company that produces electronic switches for the telecommunications industry. Lamont regularly imports component parts from Sousa Ltd., a supplier located in Mexico, and...
-
Give an example of transitory income. What effect does this income have on the marginal propensity to consume?
-
Write a database description for each of the relations shown, using SQL DDL (shorten, abbreviate, or change any data names, as needed for your SQL version). Assume the following attribute data types:...
-
Which employees were hired during 1999?
-
For each salesperson, list the total number of orders.
-
Compute the following probabilities: a. If \(Y\) is distributed \(t_{15}\), find \(\operatorname{Pr}(Y>1.75)\). b. If \(Y\) is distributed \(t_{90}\), find \(\operatorname{Pr}(-1.99 \leq Y \leq...
-
\(Y\) is distributed \(N(5,100)\), and you want to calculate \(\operatorname{Pr}(Y <3.6)\). Unfortunately, you do not have your textbook, and do not have access to a normal probability table like...
-
The random variable \(Y\) has a mean of 1 and a variance of 4. Let \(Z=\frac{1}{2}(Y-1)\). Show that \(\mu_{Z}=0\) and \(\sigma_{Z}^{2}=1\).
Study smarter with the SolutionInn App