Create database and define relationships between tables, Database Management System

Assignment Help:

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.


Related Discussions:- Create database and define relationships between tables

Creating views with replace option, Creating views with Replace option : Th...

Creating views with Replace option : This option is used to alter the definition of the view without recreating and dropping it or regranting object privileges previously granted o

What are the problems in database normalization, What are the problems if o...

What are the problems if one were not to normalize?  When do these problems surface?           Ans:  Database normalization, sometimes considered to as  canonical synthesis, is

Explain relational model and their use in dbms, Explain Relational model an...

Explain Relational model and their use in DBMS? Relational Model - The relational model was first introduced through E.F. Codd of the IBM Research in the year of 1970. The mode

Extended star schema model, A customer places orders for parts and belongs ...

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

How can you map null values to other values while display, How can you map ...

How can you map NULL values to other values while display? IF( ) , IFNULL( ) keywords are used to do so. They are 'LIMIT' is used for the following kinds of problems: 1) Ans

Explain degree of relation, Explain degree of relation? Degree of a Re...

Explain degree of relation? Degree of a Relation - The degree or arity of a relation is the number of attributes n of its relation schema.

Explain the advantages of database management system, Advantages of Databas...

Advantages of Database management system Let us summarize the advantages. Reduction of Redundancy: This is perhaps the most important advantage of using DBMS. Redundancy i

Large Project, Can you help me with the following: Drop statements for all...

Can you help me with the following: Drop statements for all objects in the lab project. Create statements for all objects of the lab project Create indexes for foreign keys Cre

What is object oriented model, What is Object Oriented model? This mod...

What is Object Oriented model? This model is based on collection of objects. An object has values stored in instance variables with in the object. An object also having bodies

Write Your Message!

Captcha
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