Design a database for an airline

Assignment Help Basic Computer Science

Reference no: EM131058153

Design a database for an airline. The database must keep track of customers and their reservations, flights and their status, seat assignments on individual flights, and the schedule and routing of future flights.

Your design should include an E-R diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.

Reference no: EM131058153

Questions Cloud

Conduct a critical literature review of your research topic : What have researchers said about your research topic? What types of studies have they done, and what have been the findings and what epistemological perspectives have served as the foundation for these studies?

List of the aliments and their cluster membership : Get the dataset "food.txt" from GauchoSpace and read it with R. Alternatively you can download this data set from the library cluster.datasets with the following code:

Mean life expectancy : The U.S. Center for Disease Control reports that the mean life expectancy was 47.6 years for whites born in 1900 and 33.0 years for nonwhites. Suppose that you randomly survey death records for people born in 1900 in a certain county.

Question regarding the sample proportion : Find the test statistic that would be used for a test of H0: p = 0.3 versus Ha: p ≠ 0.3, given a sample proportion of 0.35 from a sample size of 200.

Design a database for an airline : Your design should include an E-R diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.

How does seniority play a role in how overtime is scheduled : If an overtime list is created, how should it be managed since there are certain workers qualified for some tasks but not others? Should there be several task specific lists created, or an overall shop list? If a listed is created for overtime, ma..

Mean length of jail time : Suppose that it is somehow known that the population standard deviation is 1.5. If you were conducting a hypothesis test to determine if the mean length of jail time has increased, what would the null and alternative hypotheses be? The distributio..

Find all instructors earning the highest salary : Find the IDs of all students who were taught by an instructor named Einstein; make sure there are no duplicates in the result.

Need to write r code and proof : Problem 4: Antimicrobial resistance (AMR) is becoming a significant problem due to overuse of antimicrobial drugs. The level of AMR can be estimated by testing isolates obtained from samples (say from retail chicken). Suppose that Y isolates test ..

User Account

All Pages