Fundamentals of Information Systems
9th Edition
ISBN: 9781337097536
Author: Ralph Stair, George Reynolds
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 4, Problem 2.2RQ
Program Plan Intro
Measures that can be taken to control access to the master production schedule so that only authorized customers may enter their data.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Study Case Statement:
Semuarasa Restaurant is a restaurant that is famous for its taste, so it has many customers. All the flavors are here, serving typical archipelago food that has spread in several cities with various mainstay menus. However, although it already has many branches and the number of order transactions is very large every day, this Semuarasa Restaurant does not yet have an application and database to manage transactions and data. Recording orders and sales reports are still done manually. Restaurant owners know that information technology can support their business so they plan to build applications to serve food orders both offline and online.
Question:
a) In the database design stage, it is known as a bottom-up, top-down and inside-out approach. Explain the three approaches!
b) In your opinion, what approach is used for database system development at Semuarasa Restaurant? Explain why you chose this approach!
Define Normalization & Normalize the following table to 3NF using excel
Sherry’s Meats, a regional meat wholesaler and retailer, needs to collect up-to-date information on how much of each meat product it has in each store. It will then use that information to schedule deliveries from its central warehouse. Currently, customers entering the store fill out a detailed form specifying their individual orders. The form lists over 150 items; it includes meat and meat products available in different amounts. At the end of the day, between 250 and 400 customer orders are tabulated and deducted from the store’s inventory. Then the office worker in each store phones in an order for the next day. Store employees have a difficult time tabulating sale because of the mistakes customers make in filling out their forms.
1. What are the requirements of the clients?
2. Design and draw a specialty form of the same size that will meet the needs of Sherry’s customers, office workers, and warehouse workers. (Design plan for web flow)
3. Design a Web page used by a customer…
Chapter 4 Solutions
Fundamentals of Information Systems
Ch. 4 - Prob. 1LOCh. 4 - Prob. 2LOCh. 4 - Prob. 3LOCh. 4 - Prob. 4LOCh. 4 - Prob. 5LOCh. 4 - Prob. 6LOCh. 4 - Prob. 7LOCh. 4 - Prob. 8LOCh. 4 - Prob. 9LOCh. 4 - Prob. 10LO
Ch. 4 - Prob. 11LOCh. 4 - Prob. 12LOCh. 4 - Prob. 13LOCh. 4 - Prob. 1.1RQCh. 4 - Prob. 1.2RQCh. 4 - Prob. 1.1CTQCh. 4 - Prob. 1.2CTQCh. 4 - Prob. 2.1RQCh. 4 - Prob. 2.2RQCh. 4 - Prob. 2.1CTQCh. 4 - Prob. 2.2CTQCh. 4 - Prob. 3.1RQCh. 4 - Prob. 3.2RQCh. 4 - Prob. 3.1CTQCh. 4 - Prob. 3.2CTQCh. 4 - Prob. 4.1RQCh. 4 - Prob. 4.2RQCh. 4 - Prob. 4.1CTQCh. 4 - Prob. 4.2CTQCh. 4 - Prob. 1SATCh. 4 - Prob. 2SATCh. 4 - Prob. 3SATCh. 4 - Prob. 4SATCh. 4 - Prob. 5SATCh. 4 - Prob. 6SATCh. 4 - Prob. 7SATCh. 4 - Prob. 8SATCh. 4 - Prob. 9SATCh. 4 - Prob. 10SATCh. 4 - Prob. 11SATCh. 4 - Prob. 12SATCh. 4 - Prob. 13SATCh. 4 - Prob. 14SATCh. 4 - Prob. 15SATCh. 4 - Prob. 1RQCh. 4 - Prob. 2RQCh. 4 - Prob. 3RQCh. 4 - Prob. 4RQCh. 4 - Prob. 5RQCh. 4 - Prob. 6RQCh. 4 - Prob. 7RQCh. 4 - Prob. 8RQCh. 4 - Prob. 9RQCh. 4 - Prob. 10RQCh. 4 - Prob. 11RQCh. 4 - Prob. 12RQCh. 4 - Prob. 13RQCh. 4 - Prob. 14RQCh. 4 - Prob. 15RQCh. 4 - Prob. 16RQCh. 4 - Prob. 17RQCh. 4 - Prob. 18RQCh. 4 - Prob. 19RQCh. 4 - Prob. 1DQCh. 4 - Prob. 2DQCh. 4 - Prob. 3DQCh. 4 - Prob. 4DQCh. 4 - Prob. 5DQCh. 4 - Prob. 6DQCh. 4 - Prob. 7DQCh. 4 - Prob. 8DQCh. 4 - Prob. 9DQCh. 4 - Prob. 10DQCh. 4 - Prob. 11DQCh. 4 - Prob. 12DQCh. 4 - Prob. 13DQCh. 4 - Prob. 14DQCh. 4 - Prob. 15DQCh. 4 - Prob. 16DQCh. 4 - Prob. 17DQCh. 4 - Prob. 18DQCh. 4 - Prob. 19DQCh. 4 - Prob. 1PSECh. 4 - Prob. 2PSECh. 4 - Prob. 3PSECh. 4 - Prob. 1WECh. 4 - Prob. 2WECh. 4 - Prob. 3WECh. 4 - Prob. 1CECh. 4 - Prob. 2CECh. 4 - Prob. 3CECh. 4 - Prob. 1.1CSCh. 4 - Prob. 1.2CSCh. 4 - Prob. 1.3CSCh. 4 - Prob. 2.1CSCh. 4 - Prob. 2.2CSCh. 4 - Prob. 2.3CS
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- 1)Explain in one sentence why there is a multiplicity association between management and produce schedule information? 2)Explain in one sentence why there is a multiplicityassociation between doctor and record availability?arrow_forwardSchedulers must be discussed. Medium-term scheduler goals?arrow_forwardLazy Eddie is a furniture chain specializing in recliners. Their management has asked you to review the large number of printed reports that are distributed to Lazy Eddie’s 35 store managers. Management is not sure that the managers actually read or use the reports, even though the store managers say they want them. Store visits have shown many of the reports end up stacked on top of filing cabinets, seemingly untouched. To determine if store managers really use the printed reports, management has asked you to create a procedure that requires users to review and justify their information needs. You could design a form that asks if the information still is required, and why. You could try to get users to decide if a report is worth the cost of producing it. How do you proceed?arrow_forward
- Premier University's admissions process is well-known to you. Students can access the enrollment portion of their accounts by logging in. Afterwards, individuals can choose the courses they wish to take. When all the courses are submitted, they move on to the awaiting requests. Each request that has been put on hold is approved by the adviser. For the whole registration process, create an SRS documentarrow_forwardDiscuss the procedures for periodic back ups.arrow_forwardWhat would you prioritise if you were required to convert to a system that processes data in batches? Please provide an explanation and justification for your selection in the poll.arrow_forward
- In preparation for the opening of the border, the Government of Malaysia plans to develop an Electronic COVID-19 passport information system (eCPIS) to store Malaysian immunization information. You are required to develop this system to keep immunization information and allow passport control officers to retrieve each individual immunization information. eCPIS should contain the following information:Personal information (Name, passport no., age, and gender)Vaccination status (completed 2 doses or partially completed or not taken)Vaccine information (Type of vaccine, Date of receiving vaccine)PROGRAM DESIGN REQUIREMENTS: Design object-oriented programming which demonstrates the use of base class, derived class,inheritance, composition, and friend functions. The program should allow a user to do the following tasks:Enter informationUpdate vaccination information.Search each individual vaccination information status via passport no.list of unvaccinated personslist of individuals who…arrow_forwardKindly explain the flow of data on the diagramarrow_forwardanswer a and b questions below Examine the table shown below. This table represents the hours worked per week for temporary staff at each branch of a company staffNo branchNo BranchAddress name position hoursPerWeek S4555 B002 City Center Plaza, Seattle, WA 98122 Ellen Layman Assistant 16 S4555 B004 16 – 14th Avenue, Seattle, WA 98128 Ellen Layman Assistant 9 S4612 B002 City Center Plaza,Seattle, WA 98122 Dave Sinclair Assistant 14 S4612 B004 16 – 14th Avenue, Seattle, WA 98128 Dave Sinclair Assistant 10 a. Identify the functional dependencies represented by the data shown in the table. State any assumptions you make about the data (if necessary b. Using the functional dependencies identified in part (b), describe and illustrate the process of normalization by converting Table 1 to Third Normal Form (3NF) relations. Identify the primary and foreign keys in your 3NF relations.arrow_forward
- how do they compare to Influential Access? Please give an illustration.When comparing Direct and Seq, what are the main differences?arrow_forwardDatabase Systems Jaja restaurant is a restaurant that is famous for its taste, so it has many customers. All the flavors are here, serving typical archipelago food that has spread in several cities with various mainstay menus. But even though it already has many branches and the number of order transactions is very large every day, this Jaja Restaurant does not yet have an application and database to manage transactions and data. Recording orders and sales reports are still done manually. RM owners know that information technology can support their business so they plan to build applications to serve food orders both offline and online. a. In the database design stage, it is known as a bottom-up, top-down and inside-out. Explain the three approaches! In your opinion, what approach is used for database system development at Rumah Makan Jaja? Explain why you chose this approach! b. What techniques have you used in gathering information (fact finding)? Give your reasons why choose…arrow_forwardIn the least amount of time, explain why a group chart of accounts is not necessary when all company codes within a certain group use the same operating chart of accounts.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
- Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageCOMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L