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

A company hires out tools and equipment to customers and requires a computerized system to record details of bookings. The customer appears at the reception desk and ask if there is an item available for immediate hire. When dealing with a booking or allocating an available item to a customer, the receptionist has to check whether the customer has previously hired equipment from the company or is a new customer. For a new customer, the receptionist has to enter the customer's details. Otherwise, the receptionist has to retrieve the existing customer's record and update any details if necessary. If the item is available then the customer can get it, otherwise, the receptionist might suggest other alternatives. If the alternative is accepted, then the receptionist allocates the tool and updated the customer record. Draw an activity diagram that models the data processing of hiring.
Suppose you are organizing a conference where researchers present articles they have written. Researchers who want to present an article send a paper to the conference organizers. The conference organizers have access to a committee of reviewers who are each willing to read up articles each. Each paper submission gets reviewed by up to reviewers. Moreover, each submission has a particular topic and each reviewer has a specialization for a set of topics, so papers on a given topic only get reviewed by those reviewers who are experts on that topic. The conference organizers need to decide which reviewers will review each article (or equivalently, which articles will be reviewed by which reviewers). Explain how they could use a flow network to solve this problem.
A company has several employees, all with different names, who perform interviews with job applicants (one applicant is interviewed by one employee). The job applicants also have different names. The interviewer makes appointments for interviews with the applicants. Each applicant may be interviewed at several occasions, possibly by different interviewers, but in that case the interviews take place during different days. The company has special interview rooms. Each interviewer uses the same room for all interviews during a day. A room may, however, be used by different interviewers during a day, as long as the interviews don't collide in time. The reservation of interview appointments is to be computerized. The database devel- oper has decided to use a single relation for all data, with the following schema: Interviews(interviewer, applicant, day, time, room) a) From the text, find functional dependencies in the relation. b) Find the keys of the relation. c) Show that the relation is…
Scenario A combined cycle gas turbine power station requires a webbased system to manage the storage and installation of spare parts and the acquisition of new parts from the Central Storage Warehouse (the CSW). The powerstation maintains an inventory of all the parts it owns comprising: part name, description and specification. There are many copies of some parts – each part has a unique ID, known as an asset tag number. The asset tag number is used when there is damage to particular parts. The power station also keeps a catalogue of all the possible spare parts types used.Only registered maintenance engineers and team leaders are allowed to install and repair parts on the plant. Maintenance engineers and team leaders can use the parts catalogue tosearch for part types and can also search the parts inventory. Maintenance engineers work in teams, currently: electrical, mechanical and environmental. Each team has its own team lead. However, the system needs to be flexible enough to…
Let us consider the following process performed by an IT helpdesk that handles requests from clients. The clients are employees of a company. There are about 500 employees in total. A request may be an IT-related problem that a client has, or an access request (e.g. requesting rights to access a system). Requests need to be handled according to their type and their priority. There are three priority levels: “critical”, “urgent” or “normal”. The current process works as follows. A client calls the help desk or sends an e-mail in order to make a request. The help desk is staffed with five “Level-1” support staff who, typically, are junior people with less than 12 months experience, but are capable of resolving known problems and simple requests. The hourly cost of a Level-1 staff member is € 40. When the Level-1 employee does not know the resolution to a request, the request is for- warded to a more experienced “Level-2” support staff. There are three Level-2 staff mem- bers and their…
consider a Scenario: A client wants a database for Order entry at his Shop, database contain information about customers, items, and orders. The following information is to be included. For each customer: (Customer number (unique), Valid shipping/delivery addresses (several per customer), Balance, Credit limit, Discount) - For each order: (customer number, ship-to/delivery address, date of order. Detail lines (several per order), each giving item number, quantity ordered - For each item: Item number (unique), Quantity on hand at each warehouse Item description Design a ER-Diagram (on paper or in MS word) from this above mentioned data. ERD must contain relation degree/constraints.
PrimeVideo is a startup company providing concierge DVD kiosk service in upscale neighborhoods. PrimeVideo can own several copies (VIDEO) of each movie (MOVIE). For example, a kiosk may have 10 copies of the movie Twist in the Wind. In the database, Twist in the Wind would be one MOVIE, and each copy would be a VIDEO. A rental transaction (RENTAL) involves one or more videos being rented to a member (MEMBERSHIP). A video can be rented many times over its lifetime; therefore, there is an M:N relationship between RENTAL and VIDEO. DETAILRENTAL is the bridge table to resolve this relationship. The complete ERD is provided in the figure. Write the SQL code to create the table structures for the entities shown in the figure. The structures should contain the attributes specified in the ERD. Use data types (and lengths, if applicable) that are appropriate for the data that will need to be stored in each attribute. Enforce primary key and foreign key constraints as indicated by the ERD. Make…
Assume a store purchases products from vendor and stores in warehouse. There is a system that will facilitate to enter data of products which are going to be stored in warehouse. Then these products are moved to store for sale. The products moved from warehouse to store in reverse order as entered in warehouse. i.e. The products entered first in warehouse will be removed at end. You have to implement the system using LinkList Or Doubly LinkList Your system will facilitate to enter data of product when we have to store product in warehouse and remove data of product when we have to move it from warehouse to store. Data for product is; productId, productTitle, and productPrice. point:- Please Code In Java Linklist Or doubly LinkList
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.
Draw an ERD for the following problem. Help design the backend database for a startup company (imagine Facebook back in the “old” times), which plans to launch a social media platform that allows USERS to share their “MOMENTS” (like a posting) with their FRIENDS. A user may have some FRIENDS who are users of the system as well. A User can send a request to another user to become a friend. A user and his/her friend can post COMMENTS and LIKES to a MOMENT. Draw an ERD and show some important attributes (e.g., key, username, password, moment posting time, etc.). Clearly state any assumptions. When possible, convert to associate entities.
To access a database, we need to open a connection to it first and close it once our job is done. Connecting to a database depends on the type of the target database and the database management system (DBMS). For example, connecting to a SQL Server database is different from connecting to an Oracle database. But both these connections have a few things in common: •They have a connection string •They can be opened•They can be closed•They may have a timeout attribute (so if the connection could not be opened within the timeout, an exception will be thrown).Your job is to represent these commonalities in a base class called DbConnection. This class should have two properties: ConnectionString : stringTimeout : TimeSpanA DbConnection will not be in a valid state if it doesn’t have a connection string. So you need to pass a connection string in the constructor of this class. Also, take into account the scenarios where null or an empty string is sent as the connection string. Make sure to…
imagine that as example We have a transportation company operates individual taxis and shuttles. It uses its taxis for transporting in the form of an individual or small group from one location to another. On the other hand, the shuttles have different scenario. They are used to pick up individuals from separate locations and provide them conveyance to several destinations. Any individual can call the company from anywhere. It may be a hotel, a mall, entertainment venue or any tourist company. When the company receives a call from such individuals, it tries schedule any available taxi for pickup service for fee-based If There's no available taxi, it does not operate any form of queuing system. Means " If there is no available car, the order is lost " If the vehicles are available, the individual confirms for pick-up. After arrival at the pick-up place the driver notify the company that it has picked up the passenger. The driver notifies the company again at the time of dropping him…