Create a database to record the various airlines

Assignment Help Management Information Sys

Reference no: EM133437995

Question: 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.

Reference no: EM133437995

Questions Cloud

What you consider to be key stress management strategies : Define work stress, explain its impact on the individual and outline and justify what you consider to be key stress management strategies that leaders may

Perform a vulnerability assessment of your place : Perform a Vulnerability Assessment of your place of employment or living area. If you use your work area make sure you inform the Security Manager

Analyze the impact of your leadership using self-reflection : Analyze the impact of your leadership using self-reflection (you may use any self-reflection tools). i need explanation in table form

How have sun tzu strategies in the art of war been adopted : How have Sun Tzu's strategies in The Art of War been adopted by American business? Identify which particular strategies would benefit business practices.

Create a database to record the various airlines : 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

Time forensics, registry forensics and email forensics : Topic Time forensics, Registry forensics and Email forensics", can someone give me a ppt on this topic

Describe how your values or ethics align with theirs find : discuss how the company markets themselves and see if it aligns with their values look and see if there finances align with their values through donations

What is relative risk of skin cancer : What is the relative risk of skin cancer from high exposure after the 2-year follow-up?

Restart the system to apply the changes : Then, run an nmap scan against the 192.168.0.30 box and make sure your second firewall rule is also working properly.

User Account

All Pages