Database Fundamentals

Database Fundamentals

Table of Contents
Introduction.................................................................................................................................................3
Overview.................................................................................................................................................3
Creation of ERD with entities as well as relationship..............................................................................3
Conversion of ERD diagram within set of relational tables till 3NF as well as dependency diagram......5
Create of database by making use of MS-Access through usage of distinct constraints..........................8
Creation of form, queries and report......................................................................................................11
Conclusion.................................................................................................................................................13
REFERENCES..........................................................................................................................................14

Introduction
Database refers to a data structure that is liable for storing organized information.
Basically, it is a systematic gathering of data which stores as well as manipulates data. Entity
relationship diagram illustrates relationship among entities which are stored within the database.
This provides a visualized view of entities or objects through which it becomes easy to
understand relationship among them. Different languages or methodologies are being utilized for
manipulating data so that it can be understood in a better way. This report is based on airline firm
which is headquartered in Sydney NSW and they operate their flights in Australia only. This
report comprises of ERD diagrams, relational database and database will be created through the
usage of Microsoft Access. In addition to this, form will be created, entries will be made within
database and distinct queries will be utilized for making alterations within table.
Overview
Airline firm furnish their services in Australia and have 15 airplanes which varies from
10 to 90 seats. Each flight possesses unique airplane number, type, capacity along with their
manufacturing company. They are being scheduled on daily basis and day for which flights are
being scheduled. Furthermore, the time is also different. Database comprises of all the details of
airport and customers who are opting for services that are being offered by them. Each ticket
which is being offered comprises details of flights and their customers.
Creation of ERD with entities as well as relationship
There will be four objects or entities within this scenario and each have different attributes
which differentiates them as well as formulate relationship among them. They are airplanes,
flights, airport and customers. The tables are illustrated beneath with respect to this.
Airplanes
Attributes Types
Airplane_Number Integer
Airplane_Type Integer
Manufacturing_Firm Varchar

Flights
Attributes Types
Airplane_Number Integer
Dept_Airport Char
Dept_Time Integer
Arrival_Airport Char
Arrival_Time Integer
Airport
Attributes Types
Airport_Code Varchar
Airport_Name Varchar
Airport_City Char
State Char
Customers
Attributes Types
Airplane_Number Integer
Cust_Id Varchar
Cust_Name Char
Cust_Title Char
Cust_DOB Varchar
Cust_Address Varchar
The different entities are illustrated above which possess by different attributes and on
that basis there exist relationship among them. It is being represented through usage of entity
relationship diagram (ERD). The structural diagram which is being used for database design,