Cooper_TermProject

docx

School

American Military University *

*We aren’t endorsed by this school

Course

222

Subject

Computer Science

Date

Jan 9, 2024

Type

docx

Pages

4

Uploaded by UltraLemur3395

Report
Assignment 8: Term Project Zachary Cooper Database Concepts: INFO222 Doctor Biz Nigatu July 30, 2023
2 Term Project 1. The pilot ID is is the primary key for the table. Each piece of information in the table will be dependent on this piece of information. The information provided shows pilot make more money and it is assumed that the higher the salary, the more likely that individual is a pilot as opposed to a co-pilot. Different pilots make various salaries from different airlines and it is not indicative of any information. It is observed that Northern airlines pays the highest salary while Southern airlines pays the lowest. The initial identities that were focused on are airlines and pilots. 2. Simply defined, functional dependency is a relationship between to different attributes. There is a determinant and dependent. The determinant is a set value that will provide the dependent. For example, the table has a pilot ID. The pilot ID may be the determinant while the last name may be the dependent. 3. The relationships can be explained in the functional dependencies. The airline ID is one-to-many in that there is one entity that correlates with many other fields. The pilot ID has two functional dependencies that relate to multiple other fields. This makes the pilot ID many-to- many. 4a. In Chapter 7, it states that First Normal form is the following: “A table is in first normal form (1NF) if it meets the following criteria: The data are stored in a two-dimensional table and there are no repeating groups.” No changes are necessary to change the table into 1NF. The data is shown in a two-dimensional table and there are no repeating groups, making it fir the criteria for 1NF. 4b. In Chapter 7, it states that Second Normal Form is the following:
3 Term Project Meets the criteria for 1NF and “all nonkey attributes are functionally dependent on the entire primary key.” Due to the table having functional dependencies and keys, pilot ID being the primary key and airline ID being a key, the table is already in 2NF. 4c. In Chapter 7, it states that Third Normal Form is the following: Meets the criteria for 2NF and “there are no transitive dependencies.” A transitive dependency is when one value is equal to another which is equal to another, making a loop of equality. For example, A is to B and B is to C so A is to C. The table has no transitive dependencies so no changes are needed for it to be in 3NF. 5. CREATE TABLE AIRLINES( PilotID INT NOT NULL, FName VARCHAR (20) NOT NULL, LName VARCHAR (20) NOT NULL, JobTitle VARCHAR(20), Salary VARINT(10), AirlineID VARCHAR(20), NPlanes VARINT(10), NRoutes VARINT(10), NPilots VARINT(10), PRIMARY KEY (PilotID) );
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
4 Term Project References Harrington, J. (2016). Relational Database Design and Implementation, 4th Edition. ISBN-13: 978-0128043998 Tutorialspoint. Accessed on 29 July 2023. Database - Third Normal Form (3NF) https://www.tutorialspoint.com/sql/third-normal-form.htm

Related Documents

ISSC262_Paper_Zachary_Cooper.docx
Cooper_Assignment #1.docx
Cooper_Assignment #3.docx
Cooper_Assignment #2.docx
Cooper_Assignment6.docx
Cooper_Assignment2.docx
Cooper_Assignment1.docx
Encryption Assignment (Windows).docx
UNIT VIII JOURNAL ASSIGNMENT HLS 6301 SLLOYD.docx
10.5.7 Practice Questions.docx
10.4.8 Practice Questions.docx
10.3.5 Practice Questions.docx
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
MIS
Computer Science
ISBN:9781337681919
Author:BIDGOLI
Publisher:Cengage
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
MIS
Computer Science
ISBN:9781337681919
Author:BIDGOLI
Publisher:Cengage
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
SEE MORE TEXTBOOKS