ScenarioYou are a database consultant with Ace Software, Inc. and have been assigned to develop adatabase for the Mom and Pop Johnson Video Store in old-town. Mom and Pop have beenkeeping their records of videos and DVDs purchased from distributors and rented to customers instacks of invoices and piles of rental forms for years. They have finally decided to automate theirrecord keeping with a relational database.You sit down with Mom and Pop to discuss their business and watch their operation for about aweek. Mom and Pop rent legacy video/DVDs and discuss their need to move away frommaintaining their rental records on paper. You discover for 1 title, they typically (but not always)offer two formats including a video (VCR) and DVD format. Both formats of a movie are kept in aseparate plastic case when rented out. They have several copies of each rental movie. There areseveral videos and DVDs for each movie title. You learn that in their inventory, they have severalthousand videos and DVDs, which they get wholesale from about a half dozen distributors. Thevideo and DVD prices to them are based on the quantity of their shipment and the past businessthey have done with each company.The cost of a DVD rental might be different than the price of a video rental for the same movie,even from the same distributor. Each distributor provides different types of movies (e.g.,suspense, horror, mystery, comedy, etc.). A single distributor may provide several different typesof movies in both video and DVD format. It is possible to obtain the same movie from multipledistributors, and at different wholesale prices.Each video and DVD has a unique identification number that Mom and Pop assign in theirinventory, in addition to the distributor's serial number for the item. Each movie also has aunique identification number Mom and Pop assign in addition to the title, and any movie IDs thedistributors use in their electronic catalogs. Distributors provide electronic catalogs to Mom andPop and the information from these catalogs must be included in the database.

The question is about designing a relational database for the Mom and Pop Johnson Video Store,…

You are a database consultant with Ace Software, Inc. and have been assigned to develop a database for the Mom and Pop Johnson Video Store in old-town. Mom and Pop have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database.

You are a database consultant with Ace Software, Inc. and have been assigned to develop a database for the Mom and Pop Johnson Video Store in old-town. Mom and Pop have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database.

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

TakeltAll Inc is a wholesaler company that has just opened up for business. They sell all kinds of technology devices at their store, ranging from graphics cards to fully kitted gaming motherboards. To help them develop the information system needed for their sales operations, they have hired you to design their database. They currently keep a wide variety of products at their warehouse. The usual information stored for each product includes name, manufacturer, and price, etc... Apart from keeping track of their products, they would like you also to keep track of the purchases made by their clients. Purchases made by clients are shown in invoices that list all the client's products and the quantities of each product. The price at which a product was bought should also be recorded at the purchase of the products. TakeltAll has two types of employees they would like to keep track of in their new information system. Namely sales agents and product managers. Each employee can either be a…
CyberToys is a small chain that sells computer hardware and software and specializes in personal service. The company has four stores located at malls and is planning on expanding to other locations. Each store has a manager, a technician, and between one and four sales reps. The owners want to create a personnel records database, and they asked you to review a table that they had designed. They suggested fields for Store Number, location, store telephone, manager name, and manager home telephone. They also want fields for technician name and technician home telephone and fields for up to four sales rep names and sales rep home telephones. Draw an Entity Relationship Diagram modeling their suggested design. Analyze their original design using the normalization concepts you learned in Module 9. For this part of the question, make sure you begin with the original table in an unnormalized form as requested by the company. Work your way through 1st, 2nd, and 3rd normal forms. At each…
The Vegan Garden is a little cafe in the tranquil village of Dawnsville. Five years have passed since the eatery first opened its doors. Nowadays, sales are recorded manually via the use of cash registers, and monthly sales reports, in addition to other corporate paperwork such as employee and supplier information, are kept in dusty filing cabinets. The manager of Vegan Garden has decided to build a database. He enlisted the help of a computer company to create a database tailored to the Vegan Garden's current methods of doing business.You're in charge of leading the team that builds the Vegan Garden database.In your role as project manager, it is your responsibility to warn Vegan Garden's owner about the risks associated with the insecurity of their computer systems. List FIVE (5) of the MOST COMMON SECURITY THREATS FACING INFORMATION SYSTEMS.
Bundoora College has a small book store that opens for students, staff and general public. Currently, they use a manual order system. The manager asked you to build a database for them. You had an interview session with him and you get a general overview about the database requirements. The database should store: Orders information made by students, staff or general public. The order should have order number, the date and the time it is made. Customers details, so that the manager can notify the customers with the order status as well as send promotional material. The detail includes customer code, the full name, home address, contact phone number, and email address. List of the items in each order. The items can be books and/or stationeries. For each book, you should be able to include the details such as the title, the authors, the ISBN, and the price. For stationery, you should have the code, description, and price. If a book is required for a particular subject offered in…
ScenarioYou are contracted by BitStream to develop a management system for the TV streamingservices the company provides. Your first task is to design a database structure for thisSystem. Specifically, the database would need to be able to record the following things:● Customers information and account details. This includes customer’ssubscription full details and payment details. Customer’s address needs to berecorded as well. (Hint: you need more than 2 tables)● Movies: information about every movie available for streaming must berecorded. A Movie has many actors and may have more than one director. Amovie may have more than one genre, for example, it can have Drama andAdventure Genres. Movie information needed to be displayed in the systemincludes Title, description, Release year, Language, Genre, classification, mainactors, director, and reviews (hint: reviews should be a separate entity). Recordinformation if the movie is based on a real story or a book.● TV Series: information…
You are the CTO of a startup based out of Arlington, VA that needs to setup a database to keep track of the details of the customers: last name, first name, customer ID, street address, customer star rating (a rating on a 1 – 5 scale, with 5 being best, representing the type of customer) and phone number. It also needs to keep track of similar information for suppliers as well (although instead of supplier first and last name, there will just be a supplier company name). The database should maintain the data on products that are offered. Information about which product is offered by which supplier should also be maintained. Finally, which customers have purchased which products should also be tracked (note that we are only interested in which customers bought which product, but not concerned about the date or how many were bought). 1.1 Business Rules Assumptions for the business model are as follows: Only customers that have purchased one or more products will exist in the database.…
Dr. Jones, knowing that you are an intuitive database design student, has come to you with a possible database solution for his medical practice. He is interested in storing data related to his patients and the medications that they take. He specifically would like to keep track of the drug names, the drug price, the dosage each patient takes, and the dates that the medications were prescribed. He needs to be able to pull patient data quickly to make sure that each patient is taking the least medication to help their illness. Create business rules that might go with this scenario. Keep in mind that nouns (subjects) will become entities and their characteristics attributes. Verbs will translate into the relationships between entities. Create the ER diagram using Visio that would go with this scenario. Be sure to include entities, attributes, keys, and relationships using the crow’s feet notation
Notown Records has decided to store information about musicians who perform on its albums (as well as other company data) in a database. The company has wisely chosen to hire you as a database designer.• Each musician that records at Notown has an SSN, a name, an address, and a phone number. Poorly paid musicians often share the same address, and no address has more than one phone.• Each instrument used in songs recorded at Notown has a name (e.g., guitar, synthesizer, flute) and a musical key (e.g., C, B-flat, E-flat).• Each album recorded on the Notown label has a title, a copyright date, a format (e.g., CD or MC), and an album identifier.• Each song recorded at Notown has a title and an author.• Each musician may play several instruments, and a given instrument may be played by several musicians.• Each album has a number of songs on it, but no song may appear on more than one album.• Each song is performed by one or more musicians, and a musician may perform a number of songs.• Each…
I need crow's foot diagram for my ms sql server hospital database project. I add the business rules and the assets I created below. Business Rules A patient can only visit a doctor.A doctor can examine many patients. An examination can be done by a doctor.A doctor can do multiple exams.A patient can request more than one exam from the doctor. Each staff member can only have one title.Some staff members may not have a title. A hospital can employ more than one doctorA doctor can work in a single hospital. A patient can give more than one test.Each assay can only be given by one patient. A prescription is for one patient only.A patient may have more than one prescription. It can contain many drugs in one prescription.The same medicine can be prescribed in many prescriptions. Only one patient can stay in a ward.More than one patient can stay in each room.A patient can stay in only one room. By the way, Please alert me if you think I have made the relational diagram wrong. I'm so grateful…
The marketing team wants to celebrate the success of StayWell with a party. The team wants a table with the names of all residents and owners combined into single column named PARTICIPANT. You need to combine this information from the tables and send it back to the team. You do not need to create a new table in the database schema. Task Return a list of all the residents and owners
John liked your work so much that he would like you to create a database for the comic book shop that you worked with in the first project. Create a relational database with at least two tables. Comic book and company would be two logical ones
Your task is to develop a database, in order to keep information on all sales at a motorcycle dealership. The database will include information on motorcycles, salespeople, sales, and customers. We assume for simplicity that the dealership sells only new motorcycles and that all motorcycles are produced by the same manufacturer. Each kind of motorcycle is called a model, and it has a unique model number. For each model, you want to store also its name, engine size in cubic centimeters (cc) which is an integer number, and the date when this particular model was introduced. For each salesperson, you want to store their employee ID number, first name, middle initial, last name, and the date when the employee was hired. For each customer, you want to store a customer ID number, first name, middle initial, last name, address information (city, state, and zipcode), phone number (given in standard US format), and e‐mail address. Assume that you do not have a zip code table available. Each…