SIT103 Database assignment 代写

  • 100%原创包过,高质量代写&免费提供Turnitin报告--24小时客服QQ&微信：273427

    • SIT103 Database assignment 代写


    SIT103 Database

     
    Trimester 1                        Assignment 1                                                 2017

     
     
    RowHill Airport Management System
     
    Due Date: week 6 (16th Sunday 2017)

    Computer Sciences Department frequent fliers have been complaining to RowHill Airport officials about the poor organization at the airport. As a result, the officials decided that all information related to the airport should be organized using a DBMS, and you have been hired to design the database. Your first task is to organize 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).
     
    •       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 and traffic controllers) belong to a union. You must store the union membership number of each employee. You can assume that each employee is uniquely identified by a 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 air plane received on the test.

    Use the description provided above about RowHill Airport. You can make your own assumptions based on the requirements given. However, the assumptions should be clearly indicated / defined. Answer following questions.
     
    Provide the following:
     
    1.                            Identify business rules (5 marks)
     
    2.                            Design the database using Entity Relationship Diagram. Clearly indicate entities, attributes, relationships, cardinalities, primary keys and other special types of attributes relationships (e.g. multivalued attributes/ ISA relationships, etc).
    (30 marks)
     
    3.                            Develop relational schemas. (20 marks)
     
    4.                              Identify primary and foreign keys and clearly indicate them in the relational schema.
     
    (10 marks)
     
    5.                            Perform Normalization (up to 3rd Normal form). (10 marks)
     
    6.                            Justify the choices you have made? What assumptions have you made. (5 marks)
     
    7.                            Write 5 queries with where clause that would think used by the company. You are required to write what the functionality of each query. You will not be given marks, If you failed to explain what each query does. (20 marks)
     
     
     SIT103 Database assignment 代写
     
    Submission: Submit a copy of your solution – a single document (pdf format – 5 marks of penalty will be applied for other format of submissions), electronically on the course portal, on or before the due date. You must submit your Report with a
    •       Cover page (with student number, name and a signed statement that mentioned all the work is your own work.)- Failing of one of the items will applied for 5 marks of penalty form the final mark.
     
    •       Answers for above mentioned questions. The design should be very clearly documented. And answers should be written in the order of the questions. If not 5 marks of penalty will be applied.


    SIT103 Database assignment 代写