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

Related questions

Q: You are the CTO of a startup based out of Arlington, VA that needs to setup a database to keep track…

A: The most important step for drawing an ERD diagram is to identify the entities in the database. The…

Q: Jim Watanabe, manager of the “No Customer Escapes” project, and assistant director of IT for Petrie…

A: Data is the raw facts and figures that are collected and stored for future use. A database is a…

Q: Your team of Data Analysts have been asked to create a database design for the Boeing X Aircraft…

A: An Entity relationship (ER) diagram which refers to the one it is a graphical representation of…

Q: Assume you work for a database company that caters to people and small enterprises. This company…

A: introduction: Define the Present as well as the Future. Utilise outside information to develop a…

Q: Now, James River Jewelry wants to expand its database applications beyond the recording of purchases…

A: ER Diagram for the given Scenario

Q: John Deere wants to build a database to track all of the computer hardware assets and software…

A: An Entity-Relationship (ER) diagram is a visual representation of the relationships among entities…

Q: Imagine that you are working as a consultant. You have been hired by a small company whose database…

A: However, the reality is that regardless of however advanced your IT infrastructure is, your…

Q: Screen shot (JPG or PNG) of data in the Track table Screen shot (JPG or PNG) of all the data joined…

A: 1. Query to display all the data from the Track table: SELECT * FROM Track; Output of sample data:

Q: The administrators of Tiny College are so pleased with your design and implementation of their…

A: Answer: We have drawn the ERD for the given information so we will see in the more details…

Q: You are a database consultant with Ace Software, Inc., and have been assigned to develop a database…

A: The Johnson Video Store, a local business, has been relying on manual record-keeping systems for…

Q: ere in this question how can i check room availability just clicking the button

A: A: You can use AJAX to achieve this.Here is an example:<code>$(function() {…

Q: he administrators of Tiny College are so pleased with your design and implementation of their…

A: The administrators of Tiny College maintain the database for their motor vehicle pool. The following…

Q: Assume you work for a company that specialises in database development for individuals and small…

A: Introduction: Metrics are quantitative assessment measures that are routinely used to evaluate,…

Q: The job that used to be done by file handling has been taken over by a database management system.…

A: The advent of database management systems revolutionized the way organizations handle data,…

Q: This scene beyond description. When we say "perspective," what do we mean? Is view definition data…

A: In the setting of folders, a view refers to a near or logical view of the data stored inside a…

Q: A database management system does the work that used to be done by handling files. Since this new…

A: The advent of database management systems(DBMS) revolutionized the way organizations handle data,…

Q: Global Computer Solutions (GCS) is an information technology consulting company with many offices…

A: Solution :

Q: The idea of normalisation is one that database professionals pay great attention to. Whether you're…

A: The process of organising data in a database is referred to as normalization. This process involves…

Q: Given the following scenario create an ERD for the Bookstore. I sell books and would like to create…

A: Bookstore ERDEntities:Book:Attributes:BookId (PK)TitleAuthorId (FK)PublisherId (FK)GenreId…

Q: Global Computer Solutions (GCS) is an information technology consulting company with many offices…

A: The steps to create the tables in MS-Access along with required relationships, primary keys and…

Q: Experts in databases often struggle with the problem of normalization. It's a helpful resource…

A: Normalization is the process of organizing data in a database to reduce data redundancy and improve…

Q: When it comes to database structure, the Database Approach is the approach of choice in today's…

A: Introduction: The database strategy is preferable to the shared file solution because it enables…

Q: Now, James River Jewelry wants to expand its database applications beyond the recording of purchases…

A: James River Jewelry Project - Data ModelJames River Jewelry needs to extend its data set…

Q: Please read the brief scenario provided below: As the IT director for a large tertiary care center,…

A: Such a database that would best solve the problems of the oncology office. Biomedical databases…

Concept explainers

Transaction Processing

Transaction processing is a computational style generally performed by server computers, which supports interactive applications (apps). Transaction processing is also known as information processing, which divides the work into indivisible and individual operations called transactions. The transaction is a set of tasks; a single task is considered as the minimum processing unit that cannot be divided again.

Question

Scenario
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 sit down with Mom and Pop to discuss their business and watch their operation for about a
week. Mom and Pop rent legacy video/DVDs and discuss their need to move away from
maintaining 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 a
separate plastic case when rented out. They have several copies of each rental movie. There are
several videos and DVDs for each movie title. You learn that in their inventory, they have several
thousand videos and DVDs, which they get wholesale from about a half dozen distributors. The
video and DVD prices to them are based on the quantity of their shipment and the past business
they 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 types
of movies in both video and DVD format. It is possible to obtain the same movie from multiple
distributors, and at different wholesale prices.
Each video and DVD has a unique identification number that Mom and Pop assign in their
inventory, in addition to the distributor's serial number for the item. Each movie also has a
unique identification number Mom and Pop assign in addition to the title, and any movie IDs the
distributors use in their electronic catalogs. Distributors provide electronic catalogs to Mom and
Pop and the information from these catalogs must be included in the database.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: An outline of the question at hand.

VIEW

Step 2: Designing a Comprehensive Relational Database for Mom and Pop Johnson Video Store

VIEW

Step 3: Continue- Designing a Comprehensive Relational Database for Mom and Pop Johnson Video Store

VIEW

Step 4: establish relationships between gives tables using foreign keys to ensure data integrity.

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 5 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Global Computer Solutions (GCS) is an information technology consulting company with many offices throughout the United States. The company’s success is based on its ability to maximize its resources—that is, its ability to match highly skilled employees with projects according to region. To better manage its projects, GCS has contacted you to design a database, so GCS managers can keep track of their customers, employees, projects, project schedules, assignments, and invoices. The GCS database must support all of GCS’s operations and information requirements. A basic description of the main entities follows: The employees of GCS must have an employee ID, a last name, a middle initial, a first name, a region, and a date of hire recorded in the system. Valid regions are as follows: Northwest (NW), Southwest (SW), Midwest North (MN), Midwest South (MS), Northeast (NE), and Southeast (SE). Each employee has many skills, and many employees have the same skill. Each skill has a skill…
suppose you are planning to develop a database where you store information about the students, courses and student grades. This is a very simple database - but would help us to learn several important concepts. How would you design and implement the database?
The administrators of Tiny College are so pleased with your design and implementation of their student registration and tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows:• Faculty members may use the vehicles owned by Tiny College for officially sanctioned travel. For example, the vehicles may be used by faculty members to travel to off-campus learning centers, to travel to locations at which research papers are presented, to transport students to officially sanctioned locations, and to travel for public service purposes. The vehicles used for such purposes are managed by Tiny College’s Travel Far But Slowly (TFBS) Center.• Using reservation forms, each department can reserve vehicles for its faculty, who are responsible for filling out the appropriate trip completion form at the end of a trip. The reservation form includes the expected departure date, vehicle type required,…
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
Warner and his brothers operate a cinema chain (Warner and Brothers Movies). He wants to build a database to use for forecasting demand for both the movies he shows and the food he sells as well as to track other critical information for his business. He tells you he has several cinemas and each cinema has between 1 and 15 theaters. Each cinema has a location (address), a unique name and a phone number. The theaters vary in terms of seating style, type of sound equipment and seating capacity. Movies are shown throughout the day starting at 11 am and finishing at 1 am. Some movies will the shown in multiple theaters and over time may switch theatres that they show in. For instance, Star Wars may originally be shown in the 3 largest theatres in a cinema but after 3 months it may be showing in just one of the smaller theaters. Of course, each theater is also used for a variety of movies over time. Warner is interested in knowing how many people, classified by adults and children, attend…
Jarzin Supermarket has been in the retail (wholesale) business for the past 40 years. And over theyears, the company has grown significantly. However, Jarzin has failed to greatly benefit from its growthdue to the lack of a well-managed and maintained database management system that keeps therecords of the business.Jarzin has approached you as a DB administrator/designer to develop their database that will captureall their business processes. Mr Banda, who has been working with the organisation for the past 25years, has been tasked by Jarzin to see to it that you get all the business requirements.During your meeting with Mr Banda, you ask him to tell you how the business operates and what thebusiness needs are. The following is the response Mr Banda gives you:“As a retail company, we cater for the needs of various customers. Some customers are once offcustomers who visit the shop, buy their desired products, pay and leave. We also have regularcustomers. Our regular customers are those…
In a hypothetical situation, you have been tasked with the responsibility of planning and delivering a training session for new users of your school's database system. Specifically, what subjects do you want to cover during the session?
What is the best example of a scenario in which a new database should be created to support the business? a.) An organization is building an eCommerce website for their customers to purchase products. They would like to have all of the usual features of an eCommerce site setup while allowing their customer service team to help track orders and provide help to customers that call in. b.) An organization would like to create a reporting tool built off of their eCommerce database to identify data analytics around customer purchases on their existing data. c.) An organization would like to create an eCommerce site through a hosting site like Shopify that handles all of the processing of the orders. d.) An organization would like to create a new product line to sell on their existing eCommerce site.
Assume you work for a database company that caters to people and small enterprises. This company wants to quantify its software development. Write a report recommending acceptable metrics and how to gather them.
You must create an ER model for Upwork before forward engineering the database in MySQL. A database design project typically begins with requirements analysis to identify the business rules, entities, and relationships to form an ERD, which is then converted into a database. Assumptions: - A client/freelancer can sign up and create an account via email. - A freelancer cannot be a client. - Clients can leave feedback on the freelancers. - The system should keep track of all bids for each project. - The total bid amount can be calculated by assuming an 8-hour workday. [(freelance hourly rate * total number of days * 8) = Bid Amount] Other functionality not mentioned in the assumptions section is out of scope. Hint: How to get started: - Writing down your design before implementing it in MySQL will help you better understand the relationships. - Examine the screenshots provided to learn how the website works. - Determine which entities are required and which may be required. - Record…
Let's say your employer has given you the assignment of picking the company's database management system. Make a technical to-do list of the selection process's components, including problems and other things to take into account.
Now, James River Jewelry wants to expand its database applications beyond the recording of purchases and purchase awards. (See the description of the award program in the James River Jewelry Project Questions for Chapter 1 that is online in Appendix D.) (Refer to blackboard/appendix/appendix D) The company still wants to maintain data on customers, purchases, and awards, but it wants to include other data as well. Specifically, James River Jewelry wants to record artists and styles and keep track of which customers are interested in which artists and styles. James River Jewelry sells most of its jewelry on consignment, so the company does not pay the artist for a piece of jewelry until it is sold. Typically, the company pays artists 60 percent of the sales price, but the terms are negotiated separately for each item. For some items, the artists earn a larger percentage and for others they earn less. Artists and James River Jewelry personnel agree on the initial sales price at the…