INFO 321 American Military University Week 8 Airline Industry Database Report

I don’t understand this Computer Science question and need help to study.

Don't use plagiarized sources. Get Your Custom Essay on
INFO 321 American Military University Week 8 Airline Industry Database Report
Just from $13/Page
Order Essay

Note : Need Original Work

ASSIGNMENT INSTRUCTIONS

You were just hired by an airline industry to create a database to record the various airlines and the pilots that work for them
Discussions with the industry representatives focused on two initial entities, Airlines and Pilots; the following key points were agreed:
1. Each pilot is assigned a unique PilotID.
2. Each AirlineID is unique
3. Each pilot may work for one airline, each airline can have many pilots.
4. FName, LName, JobTitle and Salary describe each pilot (with the obvious meaning)
5. AirlineID, NPlanes, NRoutes, NPilots describe each airline (NPlanes number of planes, NRoutes number of routes, NPilots number of pilots)
6. No fields beyond those in the report are needed.

The objective of this exercise is to demonstrate an understanding of some basic concepts covered in the course. The exercise is a straight forward application of those concepts – there are no “hidden” complexities – should you identify something in the key points or data that adds complexity, contact the instructor before submission – you may be over thinking the exercise.
The sample data may not represent all possible values of each field – consider each field’s domain during the design.
The objective is to replace the following report with a relational database. The submission will consist of a word compatible document to record the design process, and an Access DB.

Here is the relational schema (table notation) for the above report / table:
PilotAirlines (PilotID, FName, LName, JobTitle, Salary, AirlineID, NPLanes, NRoutes, NPilots)

The functional dependencies are:
PilotID – – > FName, LName, JobTitle, Salary, AirlineID, NPLanes, NRoutes, NPilots
PilotID – – > FName, LName, JobTitle, Salary, AirlineID
AirlineID – – > NPLanes, NRoutes, NPilots

The specific tasks are listed below, the percentage in parenthesis corresponds to the grade weight for each task.
Name your document Last Name_TermProject (i.e. Smith_TermProject). When you are asked to provide an explanation or description, include enough content to demonstrate that you understand the definition, term, concept, etc. and how it applies to this exercise.

SUGGESTION: Review the Terms and Concepts Forum, especially the One-to-Many Normalization Process: Parts and Suppliers example. There is also a normalization MP4 file that can be downloaded from the Resources section.

Incorporate the following outline in your submission – include the section numbers – not the questions or other content from the instructions.
1) Review the existing report, functional dependencies provided and the sample data (as well as field domains and common knowledge) and document any assumptions you feel are appropriate (beyond those in the key points) and identify initial entities (person, place, thing). (10%)

2 Define functional dependency, and explain one row of the functional dependencies provided above in plain English (use field names). (15%) (you do not need to explain partial or transitive dependency)

3) Based on multiplicity – explain the relationship between the initial Entities in plain English – (either one-to-many, or many-to-many). (15%)

4) Design: specify all tables and fields at each normal form level
a) First Normal Forum (1NF) assessment / action – if needed 10%
Copy the 1NF definition from the text (include quotes and page number)
Assess the UNF table provided and if necessary, make the changes needed to conform to the 1NF definition. Document the resulting 1NF table(s) using relational schema notation or spreadsheet format (see the above example or page 111 Figure 4.2.6 of the text).
Explain how each table(s) meets the 1NF definition (use field names)
b) Second Normal Form (2NF) assessment / action – if needed 10%
Copy the 2NF definition from the text (include quotes and page number)
Assess the 1NF table(s) in the previous section and if necessary, make the changes needed to conform to the 2NF definition. Document the resulting 2NF table(s) using relational schema notation or spreadsheet format.
Explain how each table meets the 2NF definition (use field names)
c) Third Normal Form (3NF) assessment / action if needed 10%
Copy the 3NF definition from the text (include quotes and page number)
Assess the 2NF table(s) in the previous section and if necessary, make the changes needed to conform to the 3NF definition. Document the resulting 3NF table(s) using relational schema notation or spreadsheet format.
Explain how each table meets the 3NF definition (use field names)

5) Use the 3NF tables in your design, to create an new MS Access database, load the sample data provided,
Name your database Last Name_TermProject (i.e. Smith_TermProject). (5%).
6) Create a Query, that provides the results for the following request: List each PilotID, FirstName, LastName, the Airline each pilot works for, sorted by pilot. (5%)
7) Create a Form: New Pilot Input (5%)
8) Create a Report: Pilot List – list all pilots, their first and last names, and Salary (5%)
Upload the database to the assignment area as one of the deliverables
9) Submission content organization, clarity, spelling and grammar (10%)
Contact the instructor with any questions.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with AssignmentsPros
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Technology
Life Saver!!!!
Customer 452443, February 6th, 2021
Literature
YES! Thanks a lot!!!
Customer 452443, January 31st, 2021
Psychology
Thank you!!!
Customer 452443, August 2nd, 2021
Art (Fine arts, Performing arts)
Thank you.
Customer 452453, March 13th, 2021
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
Live Chat+1 (985) 289-4677WhatsApp

Order your essay today and save 30% with the discount code ESSAYHELP