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 instance and schema, Define instance and schema? Instance: Colle...

Define instance and schema? Instance: Collection of data stored in the data base at a certain moment is Schema: The overall design of the data base is known as the data base

MIS, We face problem of stock Opening balance and closing balance in Minus...

We face problem of stock Opening balance and closing balance in Minus

Information system fundamentals, A full discription of the new, a discripti...

A full discription of the new, a discription of its components, and the bebefit it will provide a company. A disscussion of the information usedin the system. A disscussion of any

What are axioms, What are axioms? Axioms or rules of inference give a s...

What are axioms? Axioms or rules of inference give a simpler technique for reasoning about

What is database trigger, What is database Trigger? A database trigger ...

What is database Trigger? A database trigger is a PL/SQL block that can explained to automatically execute for insert, update, and delete statements against a table. The trigge

Which is the properties of entities, Which is the properties of entities? ...

Which is the properties of entities? Attributes is the properties of entities.

Explain the term- query, Explain the term- Query. Queries are used to re...

Explain the term- Query. Queries are used to repossess and show specific records in a table. They can also be used to show specific fields of specific records, which meet the co

What is serialization and where it is used, What is serialization? Where it...

What is serialization? Where it is used and why?  Serialization is a basic term used for mechanisms which enable objects and object structures to be converted into portable for

Shared lock or read lock, Shared lock or Read Lock It is requested ...

Shared lock or Read Lock It is requested by a transaction that needs to just read the value of data item. A shared lock on a data item does not permit an exclusive lock

Data warehouse, #queDefine a job scheduling strategy that will meet busines...

#queDefine a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pic

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