Scribd Logo
Upload

Welcome to Scribd!

  • 32 views

    Week Eight Term Project

    Uploaded by

    CHRISTINE KARENDI
    This document contains a student's term project for a database design course. It summarizes the key relationships and normal forms in a pilot database table. The table relates airlines to pilots with a one-to-many relationship, where each pilot can only work for one airline but an airline can have multiple pilots. The document also discusses how to normalize the table into second normal form by splitting it into two tables based on the functional dependencies of airlineID and pilotID.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Week Eight Term Project

    Uploaded by

    CHRISTINE KARENDI
    32 views5 pages
    This document contains a student's term project for a database design course. It summarizes the key relationships and normal forms in a pilot database table. The table relates airlines to pilots with a one-to-many relationship, where each pilot can only work for one airline but an airline can have multiple pilots. The document also discusses how to normalize the table into second normal form by splitting it into two tables based on the functional dependencies of airlineID and pilotID.

    Original Description:

    DA

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains a student's term project for a database design course. It summarizes the key relationships and normal forms in a pilot database table. The table relates airlines to pilots with a one-to-many relationship, where each pilot can only work for one airline but an airline can have multiple pilots. The document also discusses how to normalize the table into second normal form by splitting it into two tables based on the functional dependencies of airlineID and pilotID.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    32 views5 pages

    Week Eight Term Project

    Uploaded by

    CHRISTINE KARENDI
    This document contains a student's term project for a database design course. It summarizes the key relationships and normal forms in a pilot database table. The table relates airlines to pilots with a one-to-many relationship, where each pilot can only work for one airline but an airline can have multiple pilots. The document also discusses how to normalize the table into second normal form by splitting it into two tables based on the functional dependencies of airlineID and pilotID.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 5

    1

    Week Eight Term Project

    Student’s Name:

    Professor:

    Course:

    Date:
    2

    1. Going off this table, there are several relationships in the pilot's report, and all of their

    information takes place. Every airline can have several pilots, but the pilots are the ones

    who can only work for one airline. The pilotID identifies every entry in the database, and

    this connection can be one of the many if needed, so this is not a dependency

    relationship. In this table, the primary key for the database is the pilotID. This report

    focused on the airline (thing) and pilot (person) as the initial entities.

    2. A functional dependency is a relationship between two or more attributes in a database

    table where one attribute's value determines another's value (Thomas Connolly, 2014). In

    other words, if two attributes are functionally dependent, one attribute's value uniquely

    determines the other's value. For instance, in this table are a few, namely airlineID - - >

    NPlanes, NRoutes, and NPilots. With this, NPilots, NRoutes, and NPlanes depend

    functionally on the airlineID, making the airlineID determinant of NPilots, NRoutes, and

    NPlanes.

    3. Multiplicity refers to the number of instances of an entity that can be associated with

    instances of another entity through a relationship. The relationship between the initial

    entities is one-to-many, which means that each instance of the first entity can be

    associated with multiple instances of the second entity. Still, each instance of the second

    entity can only be associated with one instance of the first entity. For instance, pilotID

    can be connected with other fields, but the pilot can only work for one airline, so it is

    impossible to connect them technically to other airlines. In this table, below are a few

    examples of how one-to-many can be linked.


    3

    4. A). First Normal Form (1NF) is a property of a relational database table where each

    column contains atomic (indivisible) values.

    This relational table schema is already in 1NF. This is because no values repeat themselves in

    the columns; the values are separated in every row. A person is capable of visualizing this by

    checking on Sally and John. Both entities have their own set of values attributed to them and

    are separated in rows.

    B. Second Normal Form (2NF)

    2NF is a property of a relational database table where each non-key column is functionally

    dependent on the table's primary key.


    4

    To assist in making the original table in the 2NF, I was able to split the table into two separate

    tables. These tables are separated by their functional dependencies and primary keys. I came up

    with one for the airlineID and its correlating dependencies and one for pilotID and its

    dependencies. I could do this because the airlineID and pilotID entities uniquely identify their

    dependencies.
    5

    Reference

    Thomas Connolly, C. B. (2014). Retrieved from Database Systems: A Practical Approach to

    Design, Implementation, and Management:

    You might also like