Reference no: EM131167257
Given the following incomplete description of operations, get all applicable business rules to establish entities, relationships, optionalities, connectivities, and cardinalities. Draw the fully labeled and implementable Crow's Foot ERD based on the business rules of this problem. Include all entities, relationships, optionalities, connectivities, and cardinalities.
The FLYING Charter2 Company is required to maintain a detailed record of all crew credentials and all training mandated by Part 135. The company must keep a complete record of each requirement and of all compliance data. To conduct a charter flight, the company must have a properly maintained aircraft available. A pilot who meets all of the FAA's licensing and currency requirements must fly the aircraft as Pilot in Command (PIC). For those aircraft that are powered by piston engines or turboprops and have a gross takeoff weight under 12,500 pounds, single-pilot operations are permitted under Part 135 as long as a properly maintained autopilot is available. However, even if FAR Part 135 permits single-pilot operations, many customers require the presence of a copilot who is capable of conducting the flight operations under Part 135.
The FLYING Charter2 operations manager anticipates the lease of turbojet-powered aircraft, and those aircraft are required to have a crew consisting of a pilot and copilot. Both pilot and copilot must meet the same Part 135 licensing, ratings, and training requirements. The company also leases larger aircraft that exceed the 12,500-pound gross takeoff weight. Those aircraft can carry the number of passengers that requires the presence of one or more flight attendants. If those aircraft carry cargo weighing over 12,500 pounds, a loadmaster must be assigned as a crew member to supervise the loading and securing of the cargo. The database must be designed to meet the anticipated additional charter crew assignment capability.
|
What is your own stand on off-shoring
: Are the views expressed there contradictory or complementary to the views in your textbook? Give a brief comparison of the two. What is your own stand on off-shoring? Give economically sound arguments to support your position
|
|
Inverse of the contrapositive
: 1. State in English the inverse of the contrapositive of "If it is raining, then my lawn is wet." 2. Let S be a set, R be a binary relation on S, and x an element of S. Translate the following into a logical expression with the same meaning: the ne..
|
|
Probability that sample indicate that smith is preferred
: If 1500 voters are sampled randomly, what is the probability that the sample will indicate that Smith is preferred to Jones?
|
|
Extended advertising campaign on prime-time television
: Assume you are a brand manager for a food product that is consumed by all Americans---blacks, whites, Hispanics, Asians, and others. You are considering running an extended advertising campaign on prime-time television that uses Latino actors and app..
|
|
Incomplete description of operations
: Given the following incomplete description of operations, get all applicable business rules to establish entities, relationships, optionalities, connectivities, and cardinalities. Draw the fully labeled and implementable Crow's Foot ERD based on t..
|
|
List some points on the new demand curve for wheat
: Now suppose that in the spirit of Christmas, a coalition of rich people decide to buy wheat and resell it to poor people for half of whatever the rich people have to pay. List some points on the new demand curve for wheat
|
|
To what value should the mean amount put in each bottle
: soft-drink factory fills bottles of soda by setting a timer on a filling machine.- To what value should the mean amount put in each bottle be set?
|
|
Concept of ethics change in international environment
: What is ethics? How does the concept of ethics change in an international environment? What impact does diversity have on the development and implematation of an organizational ethics program?
|
|
Evaluating networking options
: Imagine that you are moving into a new house and need to consider the home network that you will use. Outline the main considerations that you need to take into account when evaluating your networking options.
|