How many hours of training does a clerk receive

Assignment Help Database Management System
Reference no: EM132152964 , Length: 6 pages

Problem I

Steve Smith is a restaurant owner who wants to spend his $10,000 to modernize his restaurant by adapting it more closely to the preferences of his repeat customers. Keeping track of his customers' likes and dislikes. Information such as where they like to sit, what they like to eat, when they normally arrive at the restaurant are all items of interest to him, since he believes that in this way he can better serve his customers. Steve has asked you to develop a system for him that will help make his customers happy while increasing his business.
You have heard what Steve had to say about his customers. There are certainly more preferences that he can keep track of.

Develop a problem definition for Steve...

Next define each area.

Be sure to include several possibilities and not just the minimum:

Problem Definition
Issues
Objectives
Requirements
Constraints

Problem II
Please label each question as either closed question or open-ended question.
1. How many personal computers do you have in this department?
2. How is this task performed?
3. Why do you perform the task that way?
4. How many hours of training does a clerk receive?
5. How many customers ordered products from the Web site last month?
6. What are users saying about the new system?
7. How are the checks reconciled?
8. What added features would you like to have in the new billing system?
9. Is the calculation procedure described in the manual?
10. Is there anything else you can tell me about this topic?

Problem III
1. What are six fact finding techniques and what are the advantages and disadvantages of each?
2. What are the types of facts a systems analyst is required to collect?
3. What is a fact-find strategy that will make the most of your time with end-users?
4. How do you develop an interview agenda and a questionnaire?
5. What is the role of ethics in the process of fact finding?

Problem IV
Perfect Pizza wants to install a system to record orders for pizza and chicken wings. When regular customers call Perfect Pizza on the phone, they are asked their phone number. When the number is typed into a computer, the name, address, and last order date is automatically brought up on the screen. Once the order is taken, the total, including tax and delivery, is calculated. Then the order is given to the cook. A receipt is printed. Occasionally, special offers (coupons) are printed so the customer can get a discount. Drivers who make deliveries give customers a copy of the receipt and a coupon (if any). Weekly totals are kept for comparison with last year's performance. A summary of business activities for taking an order at Perfect Pizza is as follows:
1. Draw a context-level data flow diagram for Perfect Pizza using the following items. Explode the above context-level diagram by drawing the logical data flow diagram 0 showing all the major processes using the following items:
Process names:
(1) Find and display customer record
(2) Take customer order
(3) Send order to cook
(4) Print customer receipt
(5) Deliver customer order
(6) Print weekly totals
Data stores:
(1) Customer master
(2) Product file
(3) Coupons
(4) Sale history
Entities:
(1) Customer
(2) Management
(3) Cook

Problem V:
In the following proposed DFD design, there are some typical errors among external entities (E), processes (P) and data stores (DS).

193_figure.jpg

1. Identify and explain errors in the above design. (Use a narrative explanation))

2. Propose design modifications. (Use a narrative explanation)

Reference no: EM132152964

Questions Cloud

What would be some steps to change the organization culture : Provide one example of why a leader might want to change an organization's culture. What would be some steps to change the organization's culture?
Reason for developing a contingency plan : Define what a contingency plan is and provide at least one reason for developing a contingency plan.
Increase the chances of stakeholders agreeing : Describe three (3) measures to increase the chances of stakeholders agreeing to and endorsing workplace planning objectives.
Allowed the full rights and privileges of assignee : Shelly claims that Lori is going to pay the rent and should be allowed the full rights and privileges of an assignee. Is Shelly or the landlord correct.
How many hours of training does a clerk receive : Information Systems Analysis, Modeling, and Design ITEC 630 - Identify and explain errors in the above design. (Use a narrative explanation)
Australian fair work act : Identify five employee rights from the Australian Fair Work Act and explain how you would ensure that the staff regularly review government
Explain how the levels of unemployment : Explain how the levels of unemployment may affect the supply of workers in your industry.
In order to evaluate the economic merits of cafe standards : In order to evaluate the economic merits of CAFE standards of 35 mpg, the following data was collected by your research team:
Explain the current systems utilized by healthcare companies : After reading the material for this module, Explain the current systems utilized by healthcare companies to maximize the supply chain to achieve the utmost.

Reviews

len2152964

10/28/2018 11:47:59 PM

I need an expert in Information System Design with good written English and plagiarism free with report. Please follow instruction as specified in the question Make sure that you read, acknowledge, and follow the following rules Rules: The exam is to be taken in accordance with the Honor Code – e.g., do not collaborate or seek help from anyone else. This is an open-book exam but you are only allowed to use your textbook and information posted in our classroom. Please do not use any other sources that are not listed in our classroom. For example, you can refer to our class lecture notes and all links posted in the lecture notes but you should not search the Web for information to solve exam questions. You should not discuss exam questions with other students or anyone else. If you have any questions about the exam, please send me an email.

len2152964

10/28/2018 11:47:19 PM

Guidelines: You should submit your exam to your assignment folder in WebTycho in a MS-Word (preferred), MS-RTF, PDF or ASCII file. Please scan your file against viruses before submitting. Please keep the full text of the question as part of your answering sheet. Be as clear and objective as you can in all questions and be sure you are answering what is asked. Justify all your numerical answers and answer all the questions using your own words. Show all your work, including how you found your answer (this is very important and essential to have your answer graded appropriately!). Post one file for the exam…do not include separate files!

Write a Review

Database Management System Questions & Answers

  Determine the functional dependencies

Using your knowledge of the college environment, determine the functional dependencies that exist in the following?

  Explain the diference between hash indexes and b+- ree index

Explain the difference between Hash indexes and B+- ree indexes. In particular, discuss how equality and range searches work, using anexample.

  Determine steps in development of an effective erm diagram

Determine the steps in development of an effective ERM Diagram and determine possible iterative steps / factors that one must consider in this process with consideration of HR core functions and responsibilities of the client.

  How many cylinders does the disk have

Consider a disk with a sector size of 512 bytes, 2000 tracks per surface, 50 sectors per track, ?ve double-sided platters, and average seek time of 10 msec.

  Explain why data flow diagrams are developed in a hierarchy

Explain why data flow diagrams are developed in a hierarchy? What are the names of some levels in the hierarchy?

  Calculate the total cost for each event

Find all maincourses that have not been served at wedding receptions. List out the description - Calculate the total cost for each event - Find all maincourses that have not been served at wedding receptions. List out the description.

  Describes the basics of database planning

The link should be to an informative piece that describes the basics of one of the following: Database Planning, SQL, Access 2010, Queries and Form Design

  Primary keys and indexes

Primary Keys and Indexes

  List all the foreign key constraints among these relations

Give an example of a (plausible) constraint involving one or more of these relations that is not a primary key or foreign key constraint.

  List the functional dependencies for the car mechanics

According to the given description, construct an Entity Relationship (ER) diagram for the database, and make assumptions where necessary.

  How would you define a relational database

How would you define a relational database? What is "normalization" and why do we normalize DBs

  You are the technical director for a company with 1500

you are the technical director for a company with 1500 employees. the chief executive officer has asked you to prepare

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd