Experiencing MIS
8th Edition
ISBN: 9780134792736
Author: KROENKE
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 5, Problem 1UYK
a.
Explanation of Solution
Data fields
The possible tables of data and possible data fields are
- Industry statistics
- Market research
- Industry analysis
- Market size
- Industry trends
- Growth and profit forecasts
- Industry trends
- Industry information
- Research
- Financial ...
b.
Explanation of Solution
Using a spreadsheet
“Yes”, spreadsheet can be used for tracking data.
Reason
- Spreadsheets are mainly used to store and sort data...
c.
Explanation of Solution
Relationships
- In the context of databases, a relationship is a situation that exists between two relational
database tables. - It allows relational databases t...
d.
Explanation of Solution
Database components
- The database components needed are data entry forms and reports.
- Data entry form is main...
e.
Explanation of Solution
Personal Database Management System (DBMS)
- This application is used for a single user at a time...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Create a Crow's Foot ERD for the following description:
The KwikTite Corporation operates many factories. Each factory is located in a region, and each region can be "home" to many of KwikTite's factories. Each factory has many employees, but each employee is employed by only one factory.
4. Company TeaLeaves has recently adopted a new order management system for handling
production requests. The sales representative can place a new order for production. If special
materials are required for producing the new order, then an order is placed for special
materials with the supplier. Otherwise, if no special materials are required for producing the
new order or the supplier has finished providing the special materials, the order is added to
the production list. Afterwards, the order is scheduled for production. Once the order is
confirmed, a letter is generated to the sales representation and to the manager.
Draw the activity diagram for the above scenario.
The Vegan Garden is a little restaurant that may be found in the tranquil village of Dawnsville. It has been five years since the eatery first opened its doors. At the moment, sales are recorded manually via the use of cash registers, and monthly sales reports and other corporate paperwork, such as information on employees and suppliers, are kept in dated filing cabinets. The owner of Vegan Garden has made the decision to develop an information system. He then went and sought the aid of a company that specializes in information technology in order to design an information system that would be suitable for the current commercial operations of the Vegan Garden.You have been given the responsibility of serving as the project manager for the creation of the Vegan Garden information system.As the project manager of the development project, it is your responsibility to advise the owner of Vegan Garden about the information system security issues that exist. Provide an explanation for ANY…
Chapter 5 Solutions
Experiencing MIS
Ch. 5.3 - Prob. 1SWCh. 5.3 - Prob. 2SWCh. 5.3 - Prob. 3SWCh. 5.3 - Prob. 4SWCh. 5 - Prob. 1EGDQCh. 5 - Prob. 2EGDQCh. 5 - Prob. 3EGDQCh. 5 - Prob. 4EGDQCh. 5 - Prob. 5EGDQCh. 5 - Prob. 6EGDQ
Ch. 5 - Prob. 7EGDQCh. 5 - Consider the adage Never ask a question for which...Ch. 5 - Prob. 1ARQCh. 5 - Prob. 2ARQCh. 5 - Prob. 3ARQCh. 5 - Prob. 4ARQCh. 5 - Prob. 5ARQCh. 5 - Prob. 6ARQCh. 5 - Prob. 1UYKCh. 5 - Prob. 2UYKCh. 5 - Prob. 3UYKCh. 5 - Study Figure 5-17 to understand the entities and...Ch. 5 - Working with your team, develop a list of seven...Ch. 5 - Modify the E-R model in Figure 5-17 to include a...Ch. 5 - Discuss the advantages and disadvantages of the...Ch. 5 - Transform the data model in Figure 5-17 into a...Ch. 5 - Prob. 9CECh. 5 - Fill your database with sample data. Because you...Ch. 5 - Prob. 11CECh. 5 - Prob. 12CSCh. 5 - Prob. 13CSCh. 5 - Prob. 14CSCh. 5 - Prob. 15CSCh. 5 - Prob. 16CSCh. 5 - Prob. 17CSCh. 5 - Prob. 18CSCh. 5 - Prob. 19MMLCh. 5 - Prob. 20MLM
Knowledge Booster
Similar questions
- Review: PVF manufactures high-quality wood furniture and distributes it to retail stores throughout the United States. Its product lines include dinette sets, stereo cabinets, wall units, living room furniture, and bedroom furniture. In the early 1990s, PVF’s founder, Alex Schuster, started to make and sell custom furniture in his garage. Alex managed invoices and kept track of customers by using file folders and a filing cabinet. By 1994, business expanded and Alex had to rent a warehouse and hire a part-time bookkeeper. PVF’s product line had multiplied, sales volume had doubled, and staff had increased to 50 employees. By 2000, PVF moved into its third and present location. Due to the added complexity of the company’s operations, Alex reorganized the company into the following functional areas: Manufacturing, which was further subdivided into three separate functions—Fabrication, Assembling, and Finishing Sales Orders Accounting Purchasing PINE VALLEY FURNITURE Alex and…arrow_forwardRead carefully the following case:Imagine that you work as an internal auditor for a company that owns several pharmacies throughout the city. Based on your audit plan, the first cycle to audit will be revenue. The first thing you do is document the processes related to receiving and processing the various sources of income. On your initial visit, you were able to observe the following:Once customers have the items to purchase, they head to the register, where a clerk processes the sale. The pharmacy has three cash registers, but does not have an employee who specifically works as a cashier at each one. This provides flexibility in the operation because, of the three employees that the business has, one can collect at any of the cashiers when available. By not having to leave a single person as a cashier, the cashier can focus on providing more direct customer service, refilling merchandise on the shelves, and even assisting in receiving or dispatching merchandise from the store.At the…arrow_forwardComputer Science Rewrite this brief section. Create a table that illustrates the data. INTRODUCTION: The University of Wisconsin–Stout has experienced a series of large budget cuts in recent years. The athletic department has been granted an estimated budget of $250,000 for updates of current facilities. For a new floor installation to be feasible, the total cost must not reach over $250,000. FIGURES: According to Connors Flooring, the total installation cost of a maple sports floor is $81,300 with over 38 years of life expectancy. This is based on a 10,000-square-foot floor. The Maple Floor Manufacturers Association has concluded that wood floors also require regular cleaning, sanding, lines repainted, and floor refinishing approxi- mately every three years. This is a cost of approximately $8,000.00 per three years, equaling $2,666.00 p/year. With a 38 year life expectancy, the total for cleaning, sanding, painting, etc. = 101,308. CONCLUSION: The total cost of the floor is under…arrow_forward
- Draw an ER diagram that captures the following information: A book identified by (unique Id number, a title and one or more authors), A library identified by (unique name and adders), A borrower has a name and a unique ID code. The library service may own several copies of a given book. A borrower can have many books on loan, but each copy of a book can only be on loan to one borrower. A borrower could borrow the same book on several occasions, but it is assumed that each such loan will take place on a different date. *arrow_forwardCreate a use case sequence diagram using the information below. Buy Parts Customer/Store Employee Description: This use case describes car parts dealer purchasing. Successful Finish: client requests vehicle component 2. Store associate verifies availability 3. component is available and client pays cost 4. Customer receives part; stock adjusted. 1. Customer asks auto part 2. Store Associate checks part availability 3. Part is unavailable and customer chooses to order part or no part 4. Customer receives part and stock is updated (if alternate part ordered) or leaves without part. Alternative: Customer wants component. No post-condition No assumptionsarrow_forwardshould use Lucidchart to draw the ERD.arrow_forward
- Please solve this one I need help: 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 theservice.Details of charges are as follow:Basic Tuning: 50 OMRSoftware Re-installation: 60 OMRParts Replacement: 100 OMRBody Paint: 120 OMRThe workshop offers 10% discounts to the customers who have membershipof the service centre.You are required to draw a flow chart diagram and write a C++ computerprogram that takes customer’s name, car plate number, membershipstatus(Y/N) and the required service (mentioned above). The programoutputs the input data and maintenance charges based on the serviceprovided by the service centre with discount, if applies.arrow_forwardLuxury-Oriented Scenic Tours (LOST) provides guided tours to groups of visitors to the Washington, D.C. area. In recent years, LOST has grown quickly and is having difficulty keeping up with all of the various information needs of the company. The company's operations are as follows: LOST offers many different tours. For each tour, the tour name, approximate length (in hours), and fee charged is needed. Guides are identified by an employee ID, but the system should also record a guide's name, home address, and date of hire. Guides take a test to be qualified to lead specific tours. It is important to know which guides are qualified to lead which tours and the date that they completed the qualification test for each tour. A guide may be qualified to lead many different tours. A tour can have many different qualified guides. New guides may or may not be qualified to lead any tours, just as a new tour may or may not have any qualified guides. Every tour must be designed to visit at least…arrow_forwardBased on the provided information below, what would be the entities and the relationship between each one? Thank you!arrow_forward
- The worksheet shown in the figure below contains two years of sales that will be used to create a PivotChart. The goal is to create a column chart that shows the total sales dollars by year for each month. Given this goal, what would be the best chart area to place the Year field? 1 2 3 4 3 6 7 . 9 10 11 12 13 14 15 Year Month 2017 April 2018 April 2017 August 2018 August 2017 December 2018 December 2017 February 2018 February 2017 January 2018 January 2017 July 2018 July 2017 June 2018 June VALUES O LEGEND AXIS FILTERS Total Sales Dollars $ 50,970.00 $ 48,400.00 $ 52,470.00 $ 50,700.00 $112,425.00 $120,000.00 $ 56,205.00 $ 56,850.00 $ 59,940,00 $ 62,950.00 $19.980.00 $ 18,500.00 $ 22.485.00 $ 21,000.00arrow_forwardExercise 3: school system Each subject is owned by a department and each department is managed by a teacher, called Head of Department (HOD). Each department has a name and a unique code number. Each subject has a name, unique number and credit value. All teachers have a unique ID. A HOD cannot manage more than one department at a time. Also, a HOD does not teach subjects. A subject cannot be taught by more than one teacher. Finally, the system needs to know each student's contact details, including, full ID, address, age and gender, as well as date of enrolment in the subject. name, studentarrow_forwardi need the answer quicklyarrow_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 Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable 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