Create database and define relationships between tables, Database Management System

Instructions:

Follow the instructions below for completing this project:
1. Creating the Database:
· Use the physical table descriptions given below to define and create each table in Access.
· Define relationships between related tables. Don't enforce integrity rules.
2. Creating Forms:
· For each table, create a form to manage its data (don't use sub-forms).
· Forms should present one record at a time.
3. Adding Sample Data:
· For each table, use the form to load (insert) a mimimum of 5 sample records (any
data)
· Make sure to observe referential integrity rules (FKs must exist as PKs)
· Add more records, with variations, to test your queries.
4. Creating Queries:
· Create each of the following queries (query definitions):
A. List of reservations (all attributes) that have not been confirmed ( Unconfirmed ) .
Note: RStatus should include only two values-"Confirmed" or "Unconfirmed".
B. List of flights (all attributes) to Doha (Qatar) with DCode = "DOH"
C. List of flights and destinations (Flight: all attrbutes, Destination: DName & DCountry)
D. List of passengers, their reservations, flight and destination details.
Note: Include the following attributes (Passenger: PName), (Reservation: RNo, RStatus), (Flight:FNo, FDate, FTime), (Destination: DName, DCountry).
5. Creating Reports:
· Create a report for each query created in (4) above .
6. Create a menu-driven application to control access to, and manage, the database.
· Design your menu system using the switchboard manager.
· Create a Main Menu that includes the following submenu options: Forms Menu, Queries Menu,
Reports Menu, Exit.
· The Forms Menu should provide a selection option (menu item) for each form, in edit mode
· The Queries Menu should provide a selection option (menu item) for each query
· The Reports Menu should provide a selection option (menu item) for each report
· The Exit option should close the system
· Each of the submenus (Forms, Queries, & Reports) should have a "Return" option that takes youback to the Main Menu
· Set your application to run auomatically, hiding all database objects, dialogs, commands, andoptions from the user
· The menu system should have the following title: Flight Reservation Sysem

Required:

1. A complete and functional database application, submitted on a CD or flash memory. No project will be accepted through Email or Blackboard.

2. Presentation from all group members on the presentation day. Individuals and groups who don't participate in the presentation of their project will lose 15-20% of the project score.

3. Attendance is compulsory for all students, whether you are presenting or not, for ALL presentations. Unexecused absence will cost 5-10% off from the project score.

Posted Date: 3/23/2013 1:34:18 AM | Location : United States







Related Discussions:- Create database and define relationships between tables, Assignment Help, Ask Question on Create database and define relationships between tables, Get Answer, Expert's Help, Create database and define relationships between tables Discussions

Write discussion on Create database and define relationships between tables
Your posts are moderated
Related Questions
List some instances of collection types? a) sets b) arrays c) multisets

Define the terms 1) physical schema 2) logical schema. Physical schema: The physical schema explains the database design at the physical level, which is the lowest level of abs

Convert the following ER - diagram (Entity Relationship Diagram) into a relational database (the primary keys are underlined): 2160_Convert the following ER - diagram into a

Compare wait-die deadlock prevention scheme with wait-wound scheme   Ans:  Wait-Die Scheme  a) Based upon a nonpreemptive technique.  b) If Pi requests a resource present

Data Handling and Research Methods: The dataset encompassing 130 participants contains several variables measuring detrimental health related behaviours referring to the use o

These are designed to reduce the effects of a database failure and make sure a database is restored to a consistent state if a failure does arise. Manual backup/restore utilities n

Related fields in a database are grouped in which form? Related data fields in a database are grouped to form a data record. (A record is a collection of related fields)

Create student database and retrieve course name taught by king? STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (secti

A customer places orders for parts and belongs to a particular industry group. An individual order is taken by a particular sales representative on a specific date and the sales re

What is Nested Queries explain in details? Nested Queries - A SELECT query could have subquery(s) in it. While a SELECT query having another SELECT query in it, is known as n