Maplewood Public Library is located in a small but growing rural community that is rapidly becoming suburban as more people move into the area. The influx of library patrons has stretched this small library's information system to its limits. The current system is computerized, but it was not designed to handle the workload that is now required. As librarians log books in and out of the system, it is not unusual for the information system to hang. Patron requests for holds or interlibrary loans still are done at the circulation desk. The library building has just been expanded to sustain increasing public visitors. Local leaders have agreed that a new information system is necessary for the continued operation of the library. You are an experienced systems analyst and have been appointed as project manager for the project. 1. Write a brief memo that explains how the library's user interface will work. Include a description of the elements that will appear on the various screens. Describe how you will integrate help and feedback into the design. 2. Prepare a context diagram for the new system. 3. Prepare a level 1 DFD for the new system.

Maplewood Public Library is located in a small but growing rural community that is rapidly becoming suburban as more people move into the area. The influx of library patrons has stretched this small library's information system to its limits. The current system is computerized, but it was not designed to handle the workload that is now required. As librarians log books in and out of the system, it is not unusual for the information system to hang. Patron requests for holds or interlibrary loans still are done at the circulation desk. The library building has just been expanded to sustain increasing public visitors. Local leaders have agreed that a new information system is necessary for the continued operation of the library. You are an experienced systems analyst and have been appointed as project manager for the project. 1. Write a brief memo that explains how the library's user interface will work. Include a description of the elements that will appear on the various screens. Describe how you will integrate help and feedback into the design. 2. Prepare a context diagram for the new system. 3. Prepare a level 1 DFD for the new system.

Principles of Information Systems (MindTap Course List)

13th Edition

ISBN:9781305971776

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter12: System Acquisition And Development

Section: Chapter Questions

Problem 3PSE: A new sales ordering system needs a relational database that contains a customer table, a product...

See similar textbooks

Similar questions

Cinmaplex is a large library that borrows books to all members in the society. This library needs to maintain a record of its members and borrowed books in a database. The details about members need to be stored including member identification number, member name, telephone number and address. The details of available books are stored in the database. The database should contain a unique identification number for each book, book title, book rating and number of copies. As books are rented, transactions are recorded. Every transaction records an invoice number is automatically generated, schedule, date of return, actual date of return and final amount if required. Use Ms Access to create the entities and attributes identified in the case study. Hint: Make sure all tables are normalized.
A cormpany has a single table in a computer (e.g., a spreadsheet) in which is stored every information abow each worker including the transactions he/she does in the company. This,table is A A table database B A spreadsheet CA flat file database •D A joint database
A new sales ordering system needs a relational database that contains a customer table, a product inventory table, and an order table. Use a word-processing, graphics, or spread-sheet program to draw an entity-relationship diagram showing the relationships among these entities. Next, design each of these tables showing the keys and attributes to be included in each table. Include five sample records for each table.
A company sells toys by mail order. The company already has a product database, with a simple web interface, so that customers can get information about toys and prices. Currently, customers place orders by mail or by telephone. The company decides to create a system for selling toys online. The system will have three components: a product database, a customer database, and an ordering system. The plan is to develop the system in two phases: Phase 1 The product database will remain unchanged but the web interface will be replaced by the ordering system. A fully featured version of the ordering system will be developed. Every effort will be made to create an ordering system that will need little or no modifications in Phase 2. A simple version of the customer database will be developed. Page 3 of 4 Phase 2 A new product database will be created. Major enhancements will be made to the customer database. Minor changes may be made to the ordering…
Project Synopsis: DATABASE MANAGEMENT:ABC Walk-in Clinic is located in a large metropolitan city in Canada. The clinic staff consists of ten doctors, six nurses, five office secretaries, two administrative assistants and one manager. First time Patients have to visit the clinic personally and fill a registration form that contains their personal and health related information. An office secretary would then enter that information in the computer based information system. Patients may become a permanent patient (at any time) for one of the doctors at the clinic by filling up necessary forms (they are called enrolled patients) or they may choose to come walk-in for every visit. (They usually called walk-in patients) Enrolled Patients may book their appointments online or by calling, the office and one of the secretaries would then book their appointment with their doctor on a particular day/time. Any booked appointment may be cancelled up to 24 hours in advance after which the clinic…
You are asked to do some modelling development of a Bank accounts management system using the methods in lectures. The description of the system is as follows: This system provides the basic services to manage bank accounts at a bank called LUBank. LUBank has many branches, each of which has an address and branch number. A client opens accounts at a branch. Each account is uniquely identified by an account number; it has a balance and a credit or overdraft limit. There are many types of accounts, including: a mortgage account (which has a property as collateral), a checking account, and a credit card account (which has an expiry date and can have secondary cards attached to it). It is possible to have a joint account (e.g., for a husband and wife). Each type of account has a particular interest rate, a monthly fee, and a specific set of privileges (e.g. ability to write checks, insurance for purchases, etc.). LUBank is divided into divisions and subdivisions (such as Planning,…
You are asked to do some modelling development of a Bank accounts management system using the methods in lectures. The description of the system is as follows: This system provides the basic services to manage bank accounts at a bank called LUBank. LUBank has many branches, each of which has an address and branch number. A client opens accounts at a branch. Each account is uniquely identified by an account number; it has a balance and a credit or overdraft limit. There are many types of accounts, including: a mortgage account (which has a property as collateral), a checking account, and a credit card account (which has an expiry date and can have secondary cards attached to it). It is possible to have a joint account (e.g., for a husband and wife). Each type of account has a particular interest rate, a monthly fee, and a specific set of privileges (e.g. ability to write checks, insurance for purchases, etc.). LUBank is divided into divisions and subdivisions (such as Planning,…
You are asked to do some modelling development of a Bank accounts management system using the methods in lectures. The description of the system is as follows: This system provides the basic services to manage bank accounts at a bank called LUBank. LUBank has many branches, each of which has an address and branch number. A client opens accounts at a branch. Each account is uniquely identified by an account number; it has a balance and a credit or overdraft limit. There are many types of accounts, including: a mortgage account (which has a property as collateral), a checking account, and a credit card account (which has an expiry date and can have secondary cards attached to it). It is possible to have a joint account (e.g., for a husband and wife). Each type of account has a particular interest rate, a monthly fee, and a specific set of privileges (e.g. ability to write checks, insurance for purchases, etc.). LUBank is divided into divisions and subdivisions (such as Planning,…
Specification Suppose you are asked to design a club database system based on the _following information. Each student has a unique student id, a name, and an email; each club has a unique club id, a name, a contact telephone number, and has exactly one student as its president. Each student can serve as a president in at most one of the clubs, although he/she can be the members several clubs. Clubs organize activities and students can participate in any of them. Each activity is described by a unique activity id, a place, a date, a time and those clubs that organize it. If an activity is organized by more than one club, different clubs might contribute different activity fees. Question Draw an E-R diagram for the system according to the above description.
Draw a Context-Level and a Diagram-0 for the system activities described below. Temp Job Finder is a company that specializes in placing employees in businesses for short periods of time. This is how they handle their work: a. Businesses telephone the company to request temporary employees. The requests are used to create an Employment Request record. If the business requesting the temporary employee is not on the Employer Master file, a record is created for it. b. Employees are selected to fill the temporary positions based on employee qualifications and availability. The Employee Master and the Employment Request files are compared to identify all qualified candidates. c. Contracts are sent to the selected temporaries. Information is printed from the Employee Master, Employer Master, and Employment Request files. d. Returned contracts are used to update the Employee Master file. The Employment Request file is updated with scheduling and personnel information.
In log-based systems that provide support for transactions, updates to data items cannot be performed before the corresponding entries are logged. Why is this restriction necessary?
Instructions: Read the following Case Study and create a context diagram . When a patient arrives at ACME Medical with a prescription refill, the receptionist checks the prescription file for the previous prescription number and adds the prescription to the system. This has to be electronically authorized by a doctor before the resident pharmacist can dispense the medication. The system sends a cell phone notification to the doctor of any incoming prescriptions. The pharmacist dispenses the medication to the patient after receiving authorization. If the patient is entitled to free prescriptions, the pharmacist verifies this in the system and fills in the appropriate details on an electronic form, which is filed in the free prescriptions file. Otherwise the pharmacist takes the customers payment information, enters it into the system and gives the patient a receipt.