Guest
08-03-2015, 05:21 PM
Objective: This lab enables the students to practice the concepts learnt
in the subject DBMS by delevoping a databases for an example company
named “Roadway Travels” whose description is as follows. The student
is excepted to practice the designing, developing and querying a
database in the context of example database “Roadway Travels”.
Students are excepted to use “Mysql” database.
Roadway Travels
“Roadway Travels” is in business since 1997 with several buses
connecting different places in India.Its main office is located in
Hyderabad
The company wants to computerize its operations in the following
areas:
? Reservations
? Ticketing
? Cancellations
Reservations:
Reservations are directly handled by booking office. Reservations can
be made 60 days in advance in either cash or credit. If the ticket is not
available, a wait listed ticket is issued to the customer.This ticket is
confirmed against the cancellation.
Cancellation and modification:
Cancellation is also directly handed at the booking office. Cancellation
charges will be changed.
Wait listed tickets that do not get confirmed are fully refunded.
Week 1: E-R Model
Analyze the problem carefully and come up with entities in it. Identify
what data has to be persisted in the database.This contains the entities,
attributes etc.
Identify the primary keys for all the entities.Identify the other keys like
calendar keys, partial keys, if any,
Example: E-R Entities
1. BUS
2. Ticket
3. Passenger
PRIMARY KEY ATTIBUTES:
1. Ticket ID (Ticket Entity)
2. Passport ID (Passport Entity)
Apart from the above mentioned entities you can identify more. The
above mentioned are few.
Reference: https://seminarproject.net/Thread-dbms-e...z3TnIaha1T
in the subject DBMS by delevoping a databases for an example company
named “Roadway Travels” whose description is as follows. The student
is excepted to practice the designing, developing and querying a
database in the context of example database “Roadway Travels”.
Students are excepted to use “Mysql” database.
Roadway Travels
“Roadway Travels” is in business since 1997 with several buses
connecting different places in India.Its main office is located in
Hyderabad
The company wants to computerize its operations in the following
areas:
? Reservations
? Ticketing
? Cancellations
Reservations:
Reservations are directly handled by booking office. Reservations can
be made 60 days in advance in either cash or credit. If the ticket is not
available, a wait listed ticket is issued to the customer.This ticket is
confirmed against the cancellation.
Cancellation and modification:
Cancellation is also directly handed at the booking office. Cancellation
charges will be changed.
Wait listed tickets that do not get confirmed are fully refunded.
Week 1: E-R Model
Analyze the problem carefully and come up with entities in it. Identify
what data has to be persisted in the database.This contains the entities,
attributes etc.
Identify the primary keys for all the entities.Identify the other keys like
calendar keys, partial keys, if any,
Example: E-R Entities
1. BUS
2. Ticket
3. Passenger
PRIMARY KEY ATTIBUTES:
1. Ticket ID (Ticket Entity)
2. Passport ID (Passport Entity)
Apart from the above mentioned entities you can identify more. The
above mentioned are few.
Reference: https://seminarproject.net/Thread-dbms-e...z3TnIaha1T