A store decides to go High Tech. You are asked to design a database for the...
Fantastic news! We've Found the answer you've been seeking!
Question:
![A store decides to go High Tech. You are asked to design a database for the store After brainstorming with](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/09/6513bf9bb90c2_1695793051331.jpg)
Transcribed Image Text:
A store decides to go High Tech. You are asked to design a database for the store After brainstorming with the store managers. you come up with the followings specification . The store has multiple departments, identified by their names, each department may have many employees but (at most) one of them is the department manager Employees are identified by their names. We also need to record their salaries. Each employee works in exactly one department. Managers are employees as well, each with a salary higher than all other employee's in the department he manages . The store sells various items identified by item ID's. Exactly one department carries each item. while each department may carry many items. For each item we also need to keep short description and its quantity in stocks . The store deals with a number of suppliers Identified by their names. We need to record their addresses • Each supplier supplies an item at a particular price. A supplier may supply any number of items. and each item must be supplied by at least 3 suppliers (probably different prices). . The store receives orders identified by order ID 's. Each order has a date, a shipping address, and may include different quantities of multiple items. (a identifying the entities and set their attributes (b). Draw E-R model and indicate the maximum cardinalities and existence A store decides to go High Tech. You are asked to design a database for the store After brainstorming with the store managers. you come up with the followings specification . The store has multiple departments, identified by their names, each department may have many employees but (at most) one of them is the department manager Employees are identified by their names. We also need to record their salaries. Each employee works in exactly one department. Managers are employees as well, each with a salary higher than all other employee's in the department he manages . The store sells various items identified by item ID's. Exactly one department carries each item. while each department may carry many items. For each item we also need to keep short description and its quantity in stocks . The store deals with a number of suppliers Identified by their names. We need to record their addresses • Each supplier supplies an item at a particular price. A supplier may supply any number of items. and each item must be supplied by at least 3 suppliers (probably different prices). . The store receives orders identified by order ID 's. Each order has a date, a shipping address, and may include different quantities of multiple items. (a identifying the entities and set their attributes (b). Draw E-R model and indicate the maximum cardinalities and existence
Expert Answer:
Answer rating: 100% (QA)
Solution Sure lets design a database for the store based on the given specifications We will identify the entities and set their attributes and then c... View the full answer
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these databases questions
-
In the context of data modeling, how do you effectively manage the trade-offs between flexibility and efficiency when designing schema to accommodate evolving business requirements?
-
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...
-
Develop a Presentation Layer Entity-Relationship (ER/EER) model for building a database for the Indian Hill Company described in the following narrative. Indian Hill Company is a factory...
-
Solve the equation symbolically. Then solve the related inequality. 1 - X
-
Consider the assets (in millions) of two banks, A and B. Both banks are funded by $120 million in deposits and $20 million in equity. Which bank has a stronger liquidity position? Which bank probably...
-
Emerald Corporation, a calendar year and accrual method taxpayer, provides the following information and asks you to prepare Schedule M1 for 2021: Net income per books (after-tax) Federal income tax...
-
1. A collect-on-delivery call (COD) costs zero initially, with the payoff at expiration being 0 if S
-
Two projects have an identical net present value of $9,000. Are both projects equal in desirability?
-
Create a spreadsheet that will calculate a tax provision for a company for 2016 and 2017 . ABC Inc. is in its first and second years of operations and has five differences between pretax accounting...
-
Carrie D'Lake, Reed A. Green, and Doug A. Divot share a passion for golf and decide to go into the golf club manufacturing business together. On January 2, 2015, D'Lake, Green, and Divot form the...
-
State Agencies. The law in a particular state provided that the commissioner of insurance had the authority to approve or not approve the rates charged consumers for automobile insurance. The...
-
Write out the form of the partial fraction decomposition of the function (see example). Do not determine the numerical values of the coefficients. x3 (a) x + 7x+6 9x+1 (b) (x + 1)3(x + 2) Submit...
-
You desire to make an 80% by weight vinyl acetate to 20% by weight styrene copolymer via free radical, emulsion polymerization. The r 1 and r 2 values for these monomers are 0.01 and 55,...
-
Q1)In a wheel and axle machine the diameters of the wheel and the axle are 450mm and 60mm respectively.The efficiency is 97%(0.97 per unit).When a body having a mass of 40kg is being lifted.Determine...
-
Smith & Chief Ltd. of Sydney, Australia, is a merchandising firm that is the sole distributor of a product that is increasing in popularity among Australian consumers. The company's income statements...
-
C. In lab, you measure the x & y components of a possible incompressible flow field as u = 2cxy; and where cand a are constants. v = c(a + x - y) 5. (04 pts) Short answer, what is necessary for the...
-
Road Kill Restaurant had the following account balances. The change in these accounts represents a net____ of cash for the year in the amount of Beginning Balance Ending Balance Accounts receivable $...
-
Use integration by parts to evaluate the following. Check your answer by taking the derivative. x2e-xdx
-
Display the customer ID, name, and order ID for all customer orders. For those customers who do not have any orders, include them in the display once by showing order ID 0.
-
What is the difference between deadlock prevention and deadlock resolution?
-
Write an SQL query to list the Read scores of students who were ever taught by tutors whose status is Dropped.
-
36. The City of Francois, Texas, has begun the process of producing a comprehensive annual financial report (CAFR). Several organizations that operate within the city are related in some way to the...
-
38. The following information pertains to the City of Williamson for 2008, its first year of legal existence. For convenience, assume that all transactions are for the General Fund, which has three...
-
39. The City of Bernard starts the year of 2008 with the following unrestricted amounts in its Gen eral Fund: cash of $20,000 and investments of $70,000. In addition, it holds a building bought on...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App