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

Define- relational algebra, Define- relational algebra. The relational ...

Define- relational algebra. The relational algebra is a procedural query language. It having of a set of operations that take one or two relation as input and make a new relati

Explain mechanism of nested queries, Explain mechanism of nested queries? ...

Explain mechanism of nested queries? SQL gives a mechanism for nesting subqueries. A subquery is a select from where expression that is nested within one more query. A common u

I need label printing program, Project Description: Hi I'm seeking someo...

Project Description: Hi I'm seeking someone to make my dBase application work. I know it's not a 'modern' language but it's what I know. I have written an order program and I ne

Multi-list file organisation, Multi-list file Organisation Multi-list f...

Multi-list file Organisation Multi-list file organisation is a multi-index linked file organisation. A linked file organisation is a logical organisation where physical orderin

Design and implement a database system, Safe Banking is a Canberra based cr...

Safe Banking is a Canberra based credit union, which has several branches around Canberra and Queanbeyan. YOU have taken over Safe Banking. YOU need to create a database that organ

Relation instance or relation state, A relation instance indicates as r is ...

A relation instance indicates as r is a collection of tuples for a given relational schema at a exact point of time. A relation state r of the relation schema R (A 1 ,A 2 ,.....

Describe the concept of aggregation, Aggregation Aggregation is strong...

Aggregation Aggregation is stronger form of association. It represents the "has-a" or "part-of" relationship. An aggregation association depicts a complex object which is comp

Describes the several relationship constraints, Describes the several relat...

Describes the several relationship constraints through giving suitable example? Constraints on relationships: There are two kinds of constraints on relationships. 1) Mapping

Data models, After going by the database architecture, let us now dwell on ...

After going by the database architecture, let us now dwell on an important query: how is the data organised in a database? There are a lot of basic structures that exist in a datab

Normalization e, explain normalization,and give the examples 1NF,2NF,3NF,BC...

explain normalization,and give the examples 1NF,2NF,3NF,BCNF.AND FUNCTIONAL DEPANDENACY AND DECOMPOSITION TECHNIQUES.

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