For the following scenario for a point of sale system, draw the following: • A mail order company that distributes CDs and tapes at discount prices to record club members (tells the purpose of the system). • When an order processing clerk receives an order form, she verifies that the sender is a club member by checking the MEMBER FILE. If the sender is not a member, the clerk returns the order along with a membership application form. • If the customer is a member, the clerk verifies the order item data by checking the ITEM FILE,

For the following scenario for a point of sale system, draw the following: • A mail order company that distributes CDs and tapes at discount prices to record club members (tells the purpose of the system). • When an order processing clerk receives an order form, she verifies that the sender is a club member by checking the MEMBER FILE. If the sender is not a member, the clerk returns the order along with a membership application form. • If the customer is a member, the clerk verifies the order item data by checking the ITEM FILE,

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

1 Suppose you are a manager of an event management company. Your team is responsible for running various events. Each event, depending on its nature, runs for varied lengths. Your company policy is such that you charge a flat amount for each event your team is managing (irrespective of the duration a particular event). The size of the team that you are running is such that your team can manage to run one event at a particular time i.e. your company is unable to run multiple events at a particular time. More formally, if there are two events i and j, the events are mutually compatible (i.e. you can select both i and j) if s>f, or s,>f, where s, and f, are the start and finish time of the event i. You are required to select events that your team is going to manage so that you can maximize the profit for your company. The following table shows some candidate events for your company to manage for a particular day. Find out which events would you select such that you can maximize the profit…
A small university would like to create a registration system for its students. The students will use thissystem to obtain information about courses, when and where the classes meet, register for classes,print transcripts, drop classes, etc. The faculty will be using this system to find out what classes theyare assigned to teach, when and where these classes meet, get a list of students registered for eachclass, and assign grades to students in their classes. The university administrative staff will be usingthis database to add new faculty and students, remove faculty and students who have left, put in andupdate information about each course the university offers, enter the schedules for classes that arebeing offered in each term, and any other housekeeping tasks that need to be performed.Your task is to analyse this system, extract and list the details of the various business processes,develop the use cases, and find the conceptual classes and their relationships.In finding the…
Draw the Level 0 and Level 1 Data Flow Diagram for a Car Purchasing System. Scenario: An owner has to register first to buy a car by providing his personal details, which are later saved in the registration database, then the system will give the registration number back to the owner. The owner will then need to provide the model, name, type of car he wants to buy, and the system automatically reads the status of the car from the car database, which later informs the owner regarding its availability. The owner pays the cost of the car. The system will update the payment database and issue a receipt back to the owner.
In Chapter 3 of Sharma et al. (2010), you will be introduced with a case study: "This case study describes a simple Library Management System. Assume the requirements for the system were written by your client exactly in these terms: The system will manage the author's and loaner's information, and keep track of books loaned. The borrower's information includes name, address, e-mail, and phone. The author's information includes name, address, and e-mail. New books, authors and clients are entered into the system. When a client checks out a book, the system will register the date the book was loaned and calculate the days the book can be loaned. It will also calculate the date the book is due to be returned. If the borrower returns the book late, he must pay a fine based on the number of days overdue." (Sharma, et al., 77). Assume that the traditional file system is currently used in this library and a DBMS is to be developed. Discuss the advantages and challenges for the use of…
There has been a use case diagram posted for you below, just add more things to it. Please make sure to include "uses" and "extends" just like in the diagram below. Please also provide an explanation for the diagram (maybe explain all the associations).
In a food delivery system platform, a registered customer can place many orders from all the available registered restaurants. An order can only come from 1 restaurant, and a restaurant can prepare many orders to any numbers of customers. Each of these orders will be handled by a registered rider that accepts the job to deliver. A rider cannot take more than 1 delivery order at any one time until he/she completes the delivery. Draw the class diagram to represent the above scenario. Each entity should have at least 1 attribute as its identity. Provide the relevant associations between these entities and include the multiplicities.
A small university would like to create a registration system for its students Actors: The Faculty, Student, Administrative Staff Write the use case scenarios of the following: Course Registration View Student Grades
Draw an ER diagram using Cardinality Notation for the following description: A veterinary hospital only treats dogs and cats (use ISA). Clients have an address, phone number and client ID. Each pet has a name, a pet ID and belongs to exactly one client. Each client can have at most 5 cats and 2 dogs.
Activity: Interaction Models Consider the university system. Departments offer courses. Professors teach courses. Students can declare majors and are admitted to university departments if they meet minimum requirements. Students and professors have schedules based on courses they take/teach. Courses have rosters, scheduled times, and instructors. Courses may get full. Students can request to sign up for courses, and if the course is not full and they meet pre-requisites, the course is added to their schedule and the course will have them as a student in that course. Students can also drop courses. Students should be informed of the consequences such as change of status from full-time to part-time, loss of scholarships, and delays in graduation. Perform the following: 1. Create a use-case diagram for this university. Make your use-case diagram as complete as you can. 2. Pick two use cases from your use case diagram, CourseAdd and CourseDrop, and describe these use cases in the standard…
The Happy Tails Pet Store wants to create an online system for their customers, so they can buy a pet through their system. The customer can create an account, search pet kinds, choose a pet and pay for their pet that he/she chose. Each Pet has an ID, name, type, gender and colour. Each pet can be either b cat, a dog or a rabbit. The customer can buy one pet or more. The supplier provides the store with the pets. Each supplier has a name, phone number company address. The pet store deals with several suppliers. However, eve supplier must provide one type of pet. The supplier adds the provided pet t- the system. The customer must fill the required pet type, colour and gender, then the system will display all available pets based on the customer choice. The customer must pay for the system online through her/his visa card or the pe will not be delivered to the customer. After paying for the pet, the system w display a thank you message. The functions supported by the system: • Create an…
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…
Use the following scenario to answer the questions that follow. A hotel that delivers food to customers would like to develop an information system that will help them serve their clients efficiently. Currently they run a manual system whereby a customer calls to make an order. The calls are usually received by the receptionist who looks at the menu list and tells the customer the amount of money he/she is supposed to pay, and how long it will take to prepare the order. Once the customer agrees to the terms and conditions of the delivery. The receptionist writes down the order and the customer details in a piece of paper and gives the piece of paper to the caterer. The caterer prepares and packs the order and sticks the order details he/she received from the receptionist to the food package. The packed order is then handed over to the delivery person who will deliver the order in a motorbike. The receptionist usually has contact details of the motorbike guys whom she would call to…