Essentials of MIS (13th Edition)
13th Edition
ISBN: 9780134802756
Author: Kenneth C. Laudon, Jane Laudon
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 2, Problem 8HMP
Explanation of Solution
Don’s Lumber Company:
- The cost of lumber and other materials changes in constant periods.
- The price of the pre-finished wood flooring will be decided by the supplier.
- The supplier depends on the manual price sheets and updates them every day.
- Sometimes, the company fails to provide the present cost of the products and hence, the supplier calls back Don’s sales.
- Updating the price sheets every day requires much time and decreases the sales.
- If the pricing sheets are not updated every day may create confusion to customers.
- By using the online data systems, the price sheets can be updated immediately.
- Using e-commerce, the data required can be shared through websites and smartphones instead of papers.
- The information shared through e-commerce will be shared in a secured way...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Tyger Valley Pet Shelter (TVPS) receives food donations from a group of pet food manufacturers. TPS relies on each manufacturing company for a particular need. For example, Veggie Land supplies all the vegetables and Premier Seed Suppliers supplies all the seeds.
The different food types are allocated to the animals according to their category. For example, food type 'seeds' is allocated to category 'Birds', while food type 'vegetables' is allocated to the categories 'Mammals' and 'Birds'.
Each animal category is subdivided into different pet types. For example, the mammal record could relate to pet types 'Dog' and 'Cat'.
TPS has recruited you to be their database designer. The database will store information on their suppliers, food types, animal categories and pet types:
Record a unique ID, company name, contact number and possibly an e-mail address for each manufacturer.
When recording information about the different food types, ensure that the expiry date is also stored.
When…
Draw an ER diagram for the EMU Slimming Center based on the specification given below.
Case Study 01
A wedding hall (Shadi Hall) organizes different types of functions for its customers. Each function is hosted (owned) by exactly one customer. A customer may host many functions. There are many employees working at the company. Before each function date, the administrations of the wedding hall calls a meeting of relevant employees to finalize the arrangements of the function. Each meeting belongs to exactly one function. Comments/suggestions of each employee in the meetings and the decisions of the meetings are also recorded.
Instructions:
• Identify the relationship between Entities (clearly showing the cardinality and participation)
In Bangladesh Premier League (BPL) player selection system, each team ownerpossesses a numbered paddle that is used to indicate a base price for a player. The BPLmanaging committee then starts the proceeding by mentioning the base price, and checkswhen a paddle is raised to accept that price to buy that player. As a result, the acceptanceof the player’s base price changes which is broadcast to all the team owners in the formof a new bid.Which design pattern is applicable here and why? Which design pattern is applicablehere and why?
Chapter 2 Solutions
Essentials of MIS (13th Edition)
Ch. 2.2 - What Kinds of systems are illustrated in this case...Ch. 2.2 - Prob. 2CQ1Ch. 2.2 - Prob. 3CQ1Ch. 2.2 - Prob. 4CQ1Ch. 2.3 - Prob. 1CQ2Ch. 2.3 - Prob. 2CQ2Ch. 2.3 - Prob. 3CQ2Ch. 2 - Prob. 1IQCh. 2 - Prob. 2IQCh. 2 - Prob. 3IQ
Ch. 2 - Prob. 4IQCh. 2 - Prob. 5IQCh. 2 - Prob. 6IQCh. 2 - Prob. 1RQCh. 2 - Prob. 2RQCh. 2 - Prob. 3RQCh. 2 - Prob. 4RQCh. 2 - Prob. 5DQCh. 2 - Prob. 6DQCh. 2 - Prob. 7DQCh. 2 - Prob. 8HMPCh. 2 - Prob. 9HMPCh. 2 - Prob. 12CTPCh. 2 - Prob. 13CSQCh. 2 - Prob. 14CSQCh. 2 - Prob. 15CSQCh. 2 - Prob. 16MLMCh. 2 - Prob. 17MLM
Knowledge Booster
Similar questions
- Many of Hoosier Burger’s customers work in the downtown area, so Bob and Thelma think a noon delivery service will offer additional convenience to their customers. Until a new system is implemented, the delivery service will be operated manually. Bob envisions the delivery system operating as follows. When a customer calls and places a delivery order, a Hoosier Burger employee records the order on a multiform order ticket. The employee captures such details as customer name, business or home address, phone number, order placement time, items ordered, and amount of sale. The multiform document is sent to the kitchen, where it is separated when the order is ready for delivery. Two copies accompany the order; a third copy is placed in a reconciliation box. When the order is prepared, the delivery person delivers the order to the customer, removes one order ticket from the food bag, collects payment for the order, and returns it to Hoosier Burger. Upon arriving at Hoosier Burger, the…arrow_forwardMany of Hoosier Burger’s customers work in the downtown area, so Bob and Thelma think a noon delivery service will offer additional convenience to their customers. Until a new system is implemented, the delivery service will be operated manually. Bob envisions the delivery system operating as follows. When a customer calls and places a delivery order, a Hoosier Burger employee records the order on a multiform order ticket. The employee captures such details as customer name, business or home address, phone number, order placement time, items ordered, and amount of sale. The multiform document is sent to the kitchen, where it is separated when the order is ready for delivery. Two copies accompany the order; a third copy is placed in a reconciliation box. When the order is prepared, the delivery person delivers the order to the customer, removes one order ticket from the food bag, collects payment for the order, and returns it to Hoosier Burger. Upon arriving at Hoosier Burger, the…arrow_forward1)Modeling: Make a CDM from the following scenario: * A retail company wants to manage their sales activity. We have the following information- The date of sale, with the possibility of rolling up to the week, month, quarter and year- the store where the sale was made: store name, brand, address, city, department and region. - The employee associated with each sale: surname, first name, date of birth, social security number. Each employee is associated with a store.the customer who purchased the product surname, first name, date of birth, address. The product sold product name, d - iption, category, unit price. The order: quantity sold, amount of turnover, amount of margin. A transaction can consist of one or more orders. The indicators (quantity, turnover, margin) can be negative if it is a reimbursement. 2) In your MCD above, what are the dimension tables? * 3)In your MCD above, what are the fact tables?arrow_forward
- Assume you are a procurement officer for an office furniture manufacturer of steel office equipment. You have a single factory located in Sydney with 2,000 employees. You sell about 40% of your office furniture to retail-oriented catalog outlets such as Quill in response to specific customer orders, and the remainder of your output is sold to resellers under long-term contracts. You have a choice of purchasing raw steel inputs—mostly cold-rolled sheet steel—from an exchange and/or from an industry consortium. Which alternative would you choose and why? Prepare a report for management supporting your position.arrow_forwardIf you wanted to start a media firm, for instance, and hire graphic designers and media producers, you would have to go out and find individuals to work for you. Create a list of the hardware that will be delivered to the workers of each department, along with a description of why the hardware is required, and include both on the list. How do they go about ensuring that they have a copy of their data at all times?arrow_forwardMuscat Auto Workshop is a vehicle service centre located in the city ofMuscat, which provides vehicle maintenance/repair services.The charges of vehicle maintenance/repair are based on the type of the service. Details of charges are as follow: Basic Tuning: 50 OMRSoftware Re-installation: 60 OMRParts Replacement: 100 OMRBody Paint: 120 OMR The workshop offers 10% discounts to the customers who have membership of the service centre. Draw a flow chart diagram that takes customer’s name, car plate number, membership status(Y/N) and the required service (mentioned above). The program outputs the input data and maintenance charges based on the service provided by the service centre with discount, if applies.arrow_forward
- ABC is a pharmaceutical company that recruits volunteers for clinical trials on drugscurrently under development at the company. The company conducts multipleclinical trials concurrently. Each clinical trial is assigned a trial code together with description of theclinical trial, start date, end date, and the lead scientist. Each clinical trialinvolves at least one treatment, and each treatment belongs to only one trial.Treatment has its conduct date. When volunteers sign up for a treatment of a clinical trial, their contact detailsincluding full name, address, contact number, email address, as well as theirunique volunteer number are recorded. Each volunteer is involved in at leastone treatment, while each treatment is tested on at least 30 volunteers. In addition, medical details for each volunteer including weight, height, bloodtype, race, gender, and medical condition are also recorded separately. At each treatment each volunteer involves a specific drug of certain type,…arrow_forwardABC is a pharmaceutical company that recruits volunteers for clinical trials on drugscurrently under development at the company. The company conducts multipleclinical trials concurrently. Each clinical trial is assigned a trial code together with description of theclinical trial, start date, end date, and the lead scientist. Each clinical trialinvolves at least one treatment, and each treatment belongs to only one trial.Treatment has its conduct date. When volunteers sign up for a treatment of a clinical trial, their contact detailsincluding full name, address, contact number, email address, as well as theirunique volunteer number are recorded. Each volunteer is involved in at leastone treatment, while each treatment is tested on at least 30 volunteers. In addition, medical details for each volunteer including weight, height, bloodtype, race, gender, and medical condition are also recorded separately. At each treatment each volunteer involves a specific drug of certain type,…arrow_forwardSuppose you are organizing a conference where researchers present articles they have written. Researchers who want to present an article send a paper to the conference organizers. The conference organizers have access to a committee of reviewers who are each willing to read up articles each. Each paper submission gets reviewed by up to reviewers. Moreover, each submission has a particular topic and each reviewer has a specialization for a set of topics, so papers on a given topic only get reviewed by those reviewers who are experts on that topic. The conference organizers need to decide which reviewers will review each article (or equivalently, which articles will be reviewed by which reviewers). Explain how they could use a flow network to solve this problem.arrow_forward
- As the head buyer for a major supermarket chain, you are constantly being asked by manufacturers and distributors to stock their new products. Over 50 new items are introduced each week. Many times, these products are launched with national advertising campaigns and special promotional allowances to retailers. To add new products, the amount of linear shelf space allocated to existing products must be reduced or items must be eliminated altogether. Develop a simple spreadsheet DSS program that you can use to estimate the change in profits from adding or deleting an item from inventory. Your analysis should include input such as estimated weekly sales in units, the amount of linear shelf space allocated to stock an item (measured in inches), total cost per unit, and sales price per unit. Your analysis should calculate total annual profit by item and then sort the rows in descending order based on total annual profit.arrow_forwardTesta Inc. is a company specializing on self-driving electric vehicle (EV) production. In Testa, a self-driving EV is represented as a model, which is identified by its Model_No and has the attributes of Model_Desc (description), Production_Date, and Model_Cost. Each model uses one to many parts in its production; each part may be used in zero to many models. The number of parts (Num_Parts) is recorded for each part used in a model. Each part is identified by Part_No and has the attributes of Part_Name, Part_Cost, and Effective_Date. Each part may consist of zero to many other parts; each part may be a component of zero to many other parts. The nearby entity-relationship diagram shows the aforementioned situation. Testa is asking you to develop a MySQL database to manage its part and model data. You will create the tables and their data in your MySQL account and upload the MySQL script here. First, you are required to download a text file (click here) and then open it using a text…arrow_forwardFor below given Scenario draw the following UML Diagrams CLASS DIAGRAM SEQUENCE DIAGRAM The Buyer has already bid for the product. A message is displayed to the user that he has already bid for the product The system admin is provided with a page where the top level categories of products are displayed. If the system admin wishes to add a new top level category, he clicks on ‘add category’ button and adds a new category The system admin can browse to a specific level and then click on ‘add category’ button and add a new category at any level An already existing category is again added, an error message is provided to the user.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education