Suppose you are involved in developing a database system for the ticket booking database of ABC bus company. The operation of the ticket booking can be described as follows. They have a file of booking that they provide to their clients. Each type of ticket has a unique ticket code, as well as, quantity available and a price. • They have a file of clients. Each client is given a unique client number. This file also contains client telephone, and client name. The client name consists of first name and last name. A client may make zero, one or more bookings at a time, and a booking is always placed by one client only. Information as to booking includes the booking date, and quantity. The system is allowed to booking up to 5 bookings per day, bookings limit which is used to validate customer. A booking may involve one or more than one tickets and a ticket involved in more than one booking. may be Given this information, draw an ER diagram for this ABC bus company. Identify and label the primary key(s) of each entity, relationships and the foreign keys required for creating the relational model.

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
icon
Related questions
Question
Suppose you are involved in developing a database system for the ticket booking database
of ABC bus company. The operation of the ticket booking can be described as follows.
They have a file of booking that they provide to their clients. Each type of ticket
has a unique ticket code, as well as, quantity available and a price.
1
They have a file of clients. Each client is given a unique client number. This file
also contains client telephone, and client name. The client name consists of first
name and last name.
A client may make zero, one or more bookings at a time, and a booking is always
placed by one client only. Information as to booking includes the booking date,
and quantity. The system is allowed to booking up to 5 bookings per day, bookings
limit which is used to validate customer.
A booking may involve one or more than one tickets and a ticket may be
involved in more than one booking.
Given this information, draw an ER diagram for this ABC bus company. Identify and
label the primary key(s) of each entity, relationships and the foreign keys required for
creating the relational model.
Transcribed Image Text:Suppose you are involved in developing a database system for the ticket booking database of ABC bus company. The operation of the ticket booking can be described as follows. They have a file of booking that they provide to their clients. Each type of ticket has a unique ticket code, as well as, quantity available and a price. 1 They have a file of clients. Each client is given a unique client number. This file also contains client telephone, and client name. The client name consists of first name and last name. A client may make zero, one or more bookings at a time, and a booking is always placed by one client only. Information as to booking includes the booking date, and quantity. The system is allowed to booking up to 5 bookings per day, bookings limit which is used to validate customer. A booking may involve one or more than one tickets and a ticket may be involved in more than one booking. Given this information, draw an ER diagram for this ABC bus company. Identify and label the primary key(s) of each entity, relationships and the foreign keys required for creating the relational model.
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Adjacency Matrix
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education