Computer Science Engineering (CSE) Exam > Computer Science Engineering (CSE) Questions > In airline reservation system, the entities a...
Start Learning for Free
In airline reservation system, the entities are date, flight number, place of departure, destination, type of plane and seats available. The primary key is:
- a)Flight number + date
- b)Flight number + place of departure
- c)Flight number
- d)Flight number + destination
Correct answer is option 'C'. Can you explain this answer?
| FREE This question is part of | Download PDF Attempt this Test |
Verified Answer
In airline reservation system, the entities are date, flight number, p...
Correct answer is C. Flight number because it is the unique key and it cannot be null. Using the flight number, the user can get all the information related to the reservation.
Most Upvoted Answer
In airline reservation system, the entities are date, flight number, p...
Explanation:
An airline reservation system is a software application that is used to book and manage flight tickets. The entities in the airline reservation system are the various components or objects that are involved in the reservation process. The primary key is a unique identifier that is used to identify each entity in the system. In this case, the primary key is Flight number with destination. Here's why:
Flight Number: A flight number is a unique identifier that is assigned to each flight. It helps in identifying the flight and its details such as the airline, the route, the departure and arrival times, etc.
Destination: The destination is the place where the flight is going to. It is an important entity that helps in identifying the flight and its route.
Dates: The date is an important entity in the reservation system as it helps in identifying the availability of seats on a particular flight on a particular day.
Place of Departure: The place of departure is the starting point of the flight. It helps in identifying the flight and its route.
Type of Plane: The type of plane is an entity that helps in identifying the details of the aircraft such as its capacity, seating arrangement, etc.
Seats Available: The seats available is an entity that helps in identifying the number of seats that are available on a particular flight.
Hence, the primary key for the airline reservation system is Flight number with destination as it is a combination of two unique identifiers that help in identifying the flight and its route.
An airline reservation system is a software application that is used to book and manage flight tickets. The entities in the airline reservation system are the various components or objects that are involved in the reservation process. The primary key is a unique identifier that is used to identify each entity in the system. In this case, the primary key is Flight number with destination. Here's why:
Flight Number: A flight number is a unique identifier that is assigned to each flight. It helps in identifying the flight and its details such as the airline, the route, the departure and arrival times, etc.
Destination: The destination is the place where the flight is going to. It is an important entity that helps in identifying the flight and its route.
Dates: The date is an important entity in the reservation system as it helps in identifying the availability of seats on a particular flight on a particular day.
Place of Departure: The place of departure is the starting point of the flight. It helps in identifying the flight and its route.
Type of Plane: The type of plane is an entity that helps in identifying the details of the aircraft such as its capacity, seating arrangement, etc.
Seats Available: The seats available is an entity that helps in identifying the number of seats that are available on a particular flight.
Hence, the primary key for the airline reservation system is Flight number with destination as it is a combination of two unique identifiers that help in identifying the flight and its route.
Free Test
FREE
| Start Free Test |
Community Answer
In airline reservation system, the entities are date, flight number, p...
Flight number only na primary key .if we take flightnumber+ date then they become a super key na?
Attention Computer Science Engineering (CSE) Students!
To make sure you are not studying endlessly, EduRev has designed Computer Science Engineering (CSE) study material, with Structured Courses, Videos, & Test Series. Plus get personalized analysis, doubt solving and improvement plans to achieve a great score in Computer Science Engineering (CSE).
|
Explore Courses for Computer Science Engineering (CSE) exam
|
|
Similar Computer Science Engineering (CSE) Doubts
Top Courses for Computer Science Engineering (CSE)View all
In airline reservation system, the entities are date, flight number, place of departure, destination, type of plane and seats available. The primary key is:a)Flight number + dateb)Flight number + place of departurec)Flight numberd)Flight number + destinationCorrect answer is option 'C'. Can you explain this answer?
Question Description
In airline reservation system, the entities are date, flight number, place of departure, destination, type of plane and seats available. The primary key is:a)Flight number + dateb)Flight number + place of departurec)Flight numberd)Flight number + destinationCorrect answer is option 'C'. Can you explain this answer? for Computer Science Engineering (CSE) 2024 is part of Computer Science Engineering (CSE) preparation. The Question and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus. Information about In airline reservation system, the entities are date, flight number, place of departure, destination, type of plane and seats available. The primary key is:a)Flight number + dateb)Flight number + place of departurec)Flight numberd)Flight number + destinationCorrect answer is option 'C'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for In airline reservation system, the entities are date, flight number, place of departure, destination, type of plane and seats available. The primary key is:a)Flight number + dateb)Flight number + place of departurec)Flight numberd)Flight number + destinationCorrect answer is option 'C'. Can you explain this answer?.
In airline reservation system, the entities are date, flight number, place of departure, destination, type of plane and seats available. The primary key is:a)Flight number + dateb)Flight number + place of departurec)Flight numberd)Flight number + destinationCorrect answer is option 'C'. Can you explain this answer? for Computer Science Engineering (CSE) 2024 is part of Computer Science Engineering (CSE) preparation. The Question and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus. Information about In airline reservation system, the entities are date, flight number, place of departure, destination, type of plane and seats available. The primary key is:a)Flight number + dateb)Flight number + place of departurec)Flight numberd)Flight number + destinationCorrect answer is option 'C'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for In airline reservation system, the entities are date, flight number, place of departure, destination, type of plane and seats available. The primary key is:a)Flight number + dateb)Flight number + place of departurec)Flight numberd)Flight number + destinationCorrect answer is option 'C'. Can you explain this answer?.
Solutions for In airline reservation system, the entities are date, flight number, place of departure, destination, type of plane and seats available. The primary key is:a)Flight number + dateb)Flight number + place of departurec)Flight numberd)Flight number + destinationCorrect answer is option 'C'. Can you explain this answer? in English & in Hindi are available as part of our courses for Computer Science Engineering (CSE).
Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) Exam by signing up for free.
Here you can find the meaning of In airline reservation system, the entities are date, flight number, place of departure, destination, type of plane and seats available. The primary key is:a)Flight number + dateb)Flight number + place of departurec)Flight numberd)Flight number + destinationCorrect answer is option 'C'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of
In airline reservation system, the entities are date, flight number, place of departure, destination, type of plane and seats available. The primary key is:a)Flight number + dateb)Flight number + place of departurec)Flight numberd)Flight number + destinationCorrect answer is option 'C'. Can you explain this answer?, a detailed solution for In airline reservation system, the entities are date, flight number, place of departure, destination, type of plane and seats available. The primary key is:a)Flight number + dateb)Flight number + place of departurec)Flight numberd)Flight number + destinationCorrect answer is option 'C'. Can you explain this answer? has been provided alongside types of In airline reservation system, the entities are date, flight number, place of departure, destination, type of plane and seats available. The primary key is:a)Flight number + dateb)Flight number + place of departurec)Flight numberd)Flight number + destinationCorrect answer is option 'C'. Can you explain this answer? theory, EduRev gives you an
ample number of questions to practice In airline reservation system, the entities are date, flight number, place of departure, destination, type of plane and seats available. The primary key is:a)Flight number + dateb)Flight number + place of departurec)Flight numberd)Flight number + destinationCorrect answer is option 'C'. Can you explain this answer? tests, examples and also practice Computer Science Engineering (CSE) tests.
|
|
Explore Courses for Computer Science Engineering (CSE) exam
|
|
Suggested Free Tests
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
|
© EduRev
|
Education Revolution
|
Follow Us
|
Signup on EduRev and stay on top of your study goals
10M+ students crushing their study goals daily