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

Explain the terms primary key, Explain the terms primary key, candidate key...

Explain the terms primary key, candidate key, alternate key and secondary key. In the given table identify every key? STUDENT(SID,Regno, Name, City) Primary Key: The prim

Example of weak entity, Consider the entity type dependent related to emplo...

Consider the entity type dependent related to employee entity, which is used to keep track of the dependents of every employee. The attributes of dependents are: name, sex, birth d

Define deadlock term, a. Define the term "deadlock". There are four conditi...

a. Define the term "deadlock". There are four conditions that must hold before deadlock is possible. Name them. b. Outline an algorithm that detects whether there is a deadlock.

What is a data warehouse, Problem 1 What is a Data Warehouse? Mention i...

Problem 1 What is a Data Warehouse? Mention its advantages 2 Explain the Top-Down and Bottom-up Data Warehouse development Methodologies 3 What is Data Transformation? Ex

Commercial database architecture, At its most essential level the DBMS arch...

At its most essential level the DBMS architecture can be divide into two parts: the back end and the front end. The back end is responsible for managing the physical database an

Define the terms entity set and relationship set, Define the terms i) Entit...

Define the terms i) Entity set ii) Relationship set Entity set: The set of all entities of the similar type is termed as an entity set. Relationship set: The set of all rela

Compare three clustering algorithms in weka, Compare three clustering algor...

Compare three clustering algorithms in Weka. For this comparison, you will need to use at least two different datasets. Run the algorithms on the datasets, and use the visual

Explain equivalent relational schema, Question: (a) Use the following b...

Question: (a) Use the following business rules to produce the E-R diagram. You should clearly show all the minimum and maximum cardinality constraint on each side of the relati

What is the use of group by clause, What is the use of group by clause? ...

What is the use of group by clause? Group by clause is used to be relevant aggregate functions to a set of tuples. The attributes given in the group by clause are used to shape

Explain the check clause, Explain the Check Clause The CHECK clause is ...

Explain the Check Clause The CHECK clause is employed to at the end of a CREATE TABLE statement specify table constraints. This is known as table-based constraint because it ap

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