Create a query to display all passengers information

Assignment Help Database Management System
Reference no: EM131143544

Fastflight Database Project

Given the ERD and the data for each entity (table) do the following:

1- Define the primary keys, foreign keys, and secondary keys for each table.
2- Link all tables according the ERD
3- Design the input screens, output screens, and queries to:
a. Enter data
b. Display data
c. Modify data
d. Generate reports
a- FLIGHT table might look like this:

FLIGHT NUMBER

ORIGIN

DESTINATION

DEPART TIME

ARRIVE TIME

368

AUG

NAS

0923

1017

890

HPN

AUG

1410

1555

900

AUG

AUG

1535

1620

b. RESERVATION table might look like this:

FLIGHT NUMBER

FLIGHT DATE

PASSENGER NUMBER

RESERVATION CODE

SEAT NUMBER

AGENT NUMBER

368

7/6/04

ALER1098

912283

2A

412

890

6/1/04

BROT4657

289817

11A

686

890

6/1/04

BROT6182

318879

11B

686

c. PASSENGER table might look like this:

PASSENGER NUMBER

PASSENGER NAME

ALER1098

Alerion, Nathan

BROT4657

Brothers, Barbara

BROT6182

Brothers, Sam

d. RESERVATION AGENT table might look like this:

AGENT NUMBER

AGENT NAME

412

Alexis, Ramon

014

Madre, Jefferson

686

Vasquez, Wanda

Create the following:

1. Form to Add/Display/Modify/Delete FLIGHT information
2. Form to Add/Display/Modify/Delete RESER VA TION information
3. Form to Add/Display/Modify/Delete PASSENGER information
4. Form to Add/Display/Modify/Delete RESERVATION AGENT information
5. Query to display all Passengers information by using agent number as a search key.
6. Query to display passenger name by using reservation code as a search key.
7. Query to display agent name by using flight number as a search key.
8. Report to view all passengers (grouped by agent number)
9. Report to view all flights (grouped by destination)

Reference no: EM131143544

Questions Cloud

What is the deflection angle to the following circular curve : After a backsight on the PC with 0°00' set on the instrument, what is the deflection angle to the following circular curve points?
Compute the conversion premium : Iowa Meat Packers, Inc. has a convertible bond quoted on the NYSE bond market at 85. (Bond quotes represent percentage of par value. Thus 70 represents $700, 80 represents $800, and so on.) The bond matures in 15 years and carries a coupon rate of 6½..
Balanced score card and cloud computing : The quantity of information currently being generated these days is not just data being gathered for analysis. We’re also reminded how important it is for people to be able to gather and synthesize information from a great number of sources. Balanced..
Prepare for integrated marketing communications plan paper : Discuss the product or service you selected in your Purpose and Value of Integrated Marketing Paper. Select a product or service to use in your upcoming team assignments based on the different products or services your team members wrote about in t..
Create a query to display all passengers information : Create a Query to display all Passengers information by using agent number as a search key and to display passenger name by using reservation code as a search key.
What is the conversion price : Plunkett Gym Equipment, Inc. has a $1,000 par value convertible bond outstanding that can be converted into 25 shares of common stock. The common stock is currently selling for $34.75 a share, and the convertible bond is selling for $960. a. What is ..
Calculate and tabulate curve notes to run : Calculate and tabulate curve notes to run, by deflection angles and incremental chords, a 4°30' (arc definition) circular curve at full-station increments to connect the tangents.
Nurse working in a public health clinic : Many of your patients are teenagers who are coming to your clinic pragnant. - What are a few approaches to help reduce the issue in the area you are working?
About the duties of an agent : Describe an agency relationship you are presently in or one you have been in. Identify your principal clearly. Use the 5 duties of an agent in the chapter to describe what you specific duties might be under each of the "duties of an agent". Example: ..

Reviews

Write a Review

 

Database Management System Questions & Answers

  How does oracle process query

How does Oracle process this query? That is, what does Explain Plan tell you about how the query is processed - how would you recognize that the results were not correct?

  Eplain how you can use a cve number to learn more about

1- when you should test web applications for known vulnerabilities? provide at least two examples using the sdlc

  Design a single table to hold information required to store

Consider a typical job order that might include the following information. Design a single table to hold all the information required to store a job order including this information.

  Provide a description of relationships between organisation

Discuss how this organisation has responded to the introduction of Information Systems (IS) into their business paradigms. Highlight the advantages of IS, the disadvantages and the resultant shortfalls that must be addressed in this organisation.

  Design a database solution and the potential business rules

Design a database solution and the potential business rules that could be used to house the sales transactions of the department store

  Explain the concept of physical data independence

Explain the concept of physical data independence and its importance in database systems,  List four significant differences between a file-processing system and a DBMS.

  How can a semaphore be used

How can a semaphore be used to insure that Process First will complete before Process Second executes?

  Create a report where sales query is filtered for only az

Create a report where 'Sales Query' is filtered for only AZ. Make the report look nice. Save the report as a HTML file. Add the report to the PowerPoint presentation on slide 3.

  Explaining concept of organizational intelligence

Need a page and half on concept of organizational intelligence. It must specifically talk about organizational intellignece being outcome of organization's efforts to gather store, process and interpret data.

  Database design morgan importing problem

Phillip Morgan, the owner of Morgan Importing, makes periodic buying trips to various countries. During the trips, he keeps notes about the items he purchases and basic data about their shipments. He hired a college student as an intern, and she t..

  How could those redundancies lead to anomalies

What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file structure?

  Write a script that deletes the gettoplovendors procedure

Use the Management Studio to write a script that deletes the GetToplOVendors procedure and the ApClrObjectsEx assembly. Check that the procedure and assembly exist before deleting them.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd