Project DescriptionYour project will be a small database system developed using SQL. You are required to use all the knowledge acquired throughout this course. Task 1 – Project Scope (5 Marks)Write an...

1 answer below »
Project DescriptionYour project will be a small database system developed using SQL. You are required to use all the knowledge acquired throughout this course.
Task 1 – Project Scope (5 Marks)Write an introduction (1-2 pages) that includes the project idea, its main functionality, the goal and objectives of the project.
Task 2 – Project Design (10 Marks)Once your project proposal has been approved by your lecturer you can move on to design your project and develop the database system. In your design you should:1) Describe the Data model using ER Diagram.2) Apply your model at each stage of normalisation.3) Develop a database schema for DBMS of your choice4) List all the tables, relationships and constrains5) List all the procedures and triggers6) List at least three different reports
Task 3 – Project Implementation (20 Marks)In this task you need to write the SQL code to implement your design. Make sure to meet the database design and implementation principles such as:• Creating tables for the proposed schema• Creating indices for each table• Using different relationships for the related tables• Declaration, assignments, control statement, and exception in SQL language.• Using different single table and multi-table queries
Task 4 – Project Testing (5 Marks)Perform database testing on the main functionality of your database and document the testing results. The database testing should include testing of data integrity, data accessing, query retrieving, modifications, updating and deletion.
Task 5: Documentation and Final Submission (10 Marks)You are required to submit a report that includes the following items:1. Introduction2. ERD Diagram and other supported design documents3. SQL code4. Output Reports5. Testing result


Project 3:Oriental Health frequent fliers have been complaining to Auckland Airport officials about the poor organisation at the airport. As a result, the officials have decided that all information related to the airport should be organised using a DBMS, and you have been hired to design the database. Your first task is to organise the information about all the airplanes stationed and maintained at the airport. The relevant information is as follows:• Every airplane has a registration number, and each airplane is of a specific model.• The airport accommodates a number of airplane models, and each model is identified by a model number (e.g., DC-10) and has a capacity and a weight.• A number of technicians work at the airport. You need to store the name, SSN, address, phone number, and salary of each technician.• Each technician is an expert on one or more plane model(s), and his or her expertise may overlap with that of other technicians. This information about technicians must also be recorded.• Traffic controllers must have an annual medical examination. For each traffic controller, you must store the date of the most recent exam.• All airport employees (including technicians) belong to a union. You must store the union membership number of each employee. You can assume that each employee is uniquely identified by the social security number.• The airport has a number of tests that are used periodically to ensure that airplanes are still airworthy. Each test has a Federal Aviation Administration (FAA) test number, a name, and a maximum possible score.• The FAA requires the airport to keep track of each time that a given airplane is tested by a given technician using a given test. For each testing event, the information needed is the date, the number of hours the technician spent doing the test, and the score that the airplane received on the test.
Answered Same DaySep 04, 2021

Answer To: Project DescriptionYour project will be a small database system developed using SQL. You are...

Deepti answered on Sep 06 2021
145 Votes
Introduction
This project designs and implements Auckland Airport Online Database Management System (AAODBMS) to fulfill the requirement of orga
nizing the information about the airplanes that are stationed and maintained at Auckland Airport. The database is well designed with information about all the airplanes, employees and air plane tests at the airport. All the information is integrated and is available to be accessed centrally. Various combinations of search statements can fetch the relevant data.
Business Objective
The objectives of this system include eliminating mismanagement of information related to employees and airplanes at the airport. The system aims at increasing satisfaction level among airlines operating at the Auckland airport. It will further reduce the time that employees of airlines take to retrieve information regarding the maintenance of their airplanes and details of their employees.
Business Requirement
It is the need of every business model to adapt to web-based applications to gain competitive advantage as well as save time and money on certain business-related activities. Such application will facilitate the Auckland airport management authority to centralize the data about all the airplanes that station in its premises as well as the technicians, traffic controllers and other employees information so that it can be accessed from single point at any time. The system shall be able to display employee...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here