Create queries to prepare the data


The topic :Saudi Airlines
Flight Reservation System

Prototyping / Data Definitions - Design Phase Continued
Using Access 2007, demonstrate that components of your application project have the potential to work by creating at least two of the tables described in Part 3. Create a data entry screen (input form) for each of these tables. Use these data entry screens to input at least twenty-five sample data records for each of these tables.

Using these tables, create queries to prepare the data for two of the reports you described in Part 2. This should be the result of a process that queries both of the above tables, not a simple listing of the table contents. Give each query the same name as the report it will be used to produce. Also create the two reports.

For each table,
• The definition of the table.
o For the definition of a table:
? Include for Tables -- Properties Relationships
? Include for Fields -- Names, Data Types, Sizes
? Include for Indexes -- Names, Fields, Rational
• A minimum of twenty-five sample data records for each table.
• A custom input form for each table.

For each report
• The definition of the query used to select the data for the report.
• For the definition of a query:
o Include for the Query -- Properties - SQL
o Include for the Fields -- Names, Data Types, Sizes
o The results of the query.
• A print out of the actual report.

Include a written overview of what additional components such as tables, queries, forms (data / input) and reports (information / output) will be included in your final project.



FINAL PROJECT: Implementation Phase & Final Report 
DUE: January 2nd by 11:59 PM

During the implementation phase, the final system is built, tested, and installed. The objective of the activities of this phase is not only to produce a reliable, fully functional information system, but also to ensure that the users are all trained and that the organization is ready to benefit as expected from use of the system. All the prior activities must come together during this phase to culminate in an operational system. 

Five major activities make up the implementation phase:

• Construct software components
• Verify and test 
• Convert data
• Train users and document the system
• Install the system

Each final project should have a minimum of four tables, have a minimum of four different reports which are based on separate queries and adhere to the concepts of good database design. Each table should have a minimum of 30 records and have a separate form to easily provide input. There should be 4 queries using calculations and forms for each table. As this is an extension of Part 4 (Proof of Concept), the same requirements for the remaining tables/queries/reports apply.

Any project turned in after the due date will receive a "0" for this portion of the project. 

Prepare an executive overview (not more than two pages) of the application including the major inputs, outputs, and processes involved. Reference may be made to appropriate figures from Parts 1, 2, 3, and 4 as needed.

The final report should have a title page with the name of the organization, working title of the project, names of the group members, be properly indexed, contain an executive summary and any supporting documentation. 

With the final report, a CD-Rom or DVD which consists of your Access database should be turned in. The disk should be neatly labeled with the group name, names of group members, organization name and title of the application.

The final report should clearly document what the objectives of the application are and how those objects are met by utilization of your application.

The final project report should have the graded versions of each part in the order in which they were assigned included as part of the document and include them as an appendix. 

• Print out a copy of your relationships table for your final report.

• Include an ERD (Entity Relation Diagram), how it functioned, and suggested future improvements of the team and each individual member as part of the final document. 

• Include in your final report an overall evaluation of the project with your conclusions and recommendations. 

Request for Solution File

Ask an Expert for Answer!!
Database Management System: Create queries to prepare the data
Reference No:- TGS095622

Expected delivery within 24 Hours