An organizer commissioned us to design a database for an inventory management system. They provide a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
An organizer commissioned us to design a database for an inventory management system. They provide a summary of requirements as below. A supplier is identified by his/her id. We also record his/her name, phone number and supplier type. A supplier may have several supplier types. A product is identified by its id. We also record its name, price, production date and availability. A supplier must provide one or many products. Each product must be provided by one supplier. A manager is identified by his/her id. We also record his/her name, phone number, working hours and job description. Each manager is hired by one supplier. A supplier may hire zero or many managers. A manager can oversee zero or many products. Each product can be overseen by zero or many managers. An order is identified by its id. We also record its order date, status and price. We are interested in the number of products in each order as well. An order must involve one or many products. Each product is involved in at most one order. Each shipping is identified by its id. We also record the shipping address, shipping company and status. The shipping address is composed of street number, street name, city and country. An order can have at most one shipping and each shipping must correspond to an order. Each order is associated with zero or many invoices. An invoice is identified by a combination of the invoice id and the order id. It must exist along with the order. We also record its date, billing address, payment method and tax information. Your task: draw an ER diagram to represent the scenario, clearly state any reasonable assumptions that you choose to make. Reasonable relation names are acceptable. Please keep to the notations taught in the lecture. An organizer commissioned us to design a database for an inventory management system. They provide a summary of requirements as below. A supplier is identified by his/her id. We also record his/her name, phone number and supplier type. A supplier may have several supplier types. A product is identified by its id. We also record its name, price, production date and availability. A supplier must provide one or many products. Each product must be provided by one supplier. A manager is identified by his/her id. We also record his/her name, phone number, working hours and job description. Each manager is hired by one supplier. A supplier may hire zero or many managers. A manager can oversee zero or many products. Each product can be overseen by zero or many managers. An order is identified by its id. We also record its order date, status and price. We are interested in the number of products in each order as well. An order must involve one or many products. Each product is involved in at most one order. Each shipping is identified by its id. We also record the shipping address, shipping company and status. The shipping address is composed of street number, street name, city and country. An order can have at most one shipping and each shipping must correspond to an order. Each order is associated with zero or many invoices. An invoice is identified by a combination of the invoice id and the order id. It must exist along with the order. We also record its date, billing address, payment method and tax information. Your task: draw an ER diagram to represent the scenario, clearly state any reasonable assumptions that you choose to make. Reasonable relation names are acceptable. Please keep to the notations taught in the lecture.
Expert 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
-
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...
-
Image transcription text Module 5 Discussion A' Instructions: This discussion will be completed in two parts, and will give you an opportunity to reect upon this week's content and to interact with...
-
Accounts Receivable AED 5,000 Accounts Payable 15,000 Advertising Expense 2,000 16,500 Building Cash Common Stock 50,000 Dividends 1,200 Equipment 2,000 Land 70,000 Notes Payable 60,000 3,400 Office...
-
Is it possible for a company to show an accounting profit even while it is incurring an economic loss? How? What might happen with such a company?
-
Improv Club (IC) features entertaining improvisational theatre performances. The theatre features a range of shows and talented performers. IC prepares financial statements on an annual basis. The...
-
The English scores for a sample of 14 students Find the mean, the median, and the mode of the data, if possible. If any measure cannot be found or does not represent the center of the data, explain...
-
I. M. Appelpolscher, supervisor of the process control group of the Ideal Gas Company, has installed a 25 x 40 x 5-ft swimming poe1 in his backyard. The poo1 contains level and temperature sensors...
-
Provide a constructive comparison between the scientific management Human Relations human resource approach as well as the strategic human resource management approach?
-
Perform the vertical and horizontal analysis and calculate the ratios as instructed (40 points) Fill the grey cells by using Excel formulas or cells referencing NOT hardcoding. You will not earn...
-
California Dreamin' manufactures 1960s style clothing and accessories. The company produces two main products: Floral and Tie-Dye. Currently, the company uses a traditional overhead rate in which...
-
For your Final Assignment, you are to act as an Esports Entity of your choice (Org, League, Publisher, Event Planner etc.) . You play the role of a Sponsorship & Partnerships Representative who is...
-
Let the individual claim amount distribution be (2,2), and let the premium loading factor be 10%. Calculate R when r < 2.
-
Suppose you have an initial investment of $3000, an annual interest rate of 12% compounded monthly, payments of $150 at the beginning of each month with the first payment to be made today, and you...
-
Happy Sdn Bhd purchased a debt instrument on 1 January 2 0 2 3 at its fair value of RM 5 million. The face value of the instrument was RM 1 2 million with an interest rate of 2 . 3 5 % . The...
-
On October 21, Portland Skydiving received $6,200 cash in advance from customers for a group skydiving experience it will provide in November, and correctly recorded this transaction. On November 8,...
-
Chevron Corporation (www.chevron.com) is one of the worlds leading energy companies. Chevrons headquarters are in San Ramon, California. The company has more than 62,000 employees and produces more...
-
The vapor pressure of the liquid NH, is measured at different temperatures. The following vapor pressure data are obtained. Temperature, K P, mmHg 217.1 223.4 234.7 588.1 Calculate the enthalpy of...
-
What is the purpose of the COMMIT command in SQL? How does commit relate to the notion of a business transaction (e.g., entering a customer order or issuing a customer invoice)?
-
Why is master data management important in an organization?
-
Explain the differences between user views, a conceptual schema, and an internal schema as different perspectives of the same database.
-
Comment on this statement: Dynamic modeling is about interaction.
-
Explain how objects interact by exchanging messages.
-
Describe events. Provide an example.
Study smarter with the SolutionInn App