Question: Business Scenario A database is being constructed to keep track of the airports and airplanes. An airport is identified by airport code and has its

Business Scenario A database is being constructed to keep track of the airports and airplanes. An airport is identified by airport code and has its own name, city and state. Each airport is landed by a number of airplane type. An airplane type is identified by type name and lands in multiple airports. It also has maximum seats and company. Each airplane type belongs to many airplanes. Airplane is identified by airplane ID and includes total number of seats. An airplane is assigned to multiple leg instance. Leg instance has number of available seats. Multiple flight leg must depart or arrive at an airport. A flight leg includes number of legs. A flight has multiple legs A flight is identified by its number and includes airline name and date. Note: A leg instance is a particular occurrence of a leg on a particular date. A flight leg is a non-stop portion of a flight. Question 1 (25 Marks) a) Analyze the given business scenario and explain how do you carry out design and development of the relational database based on Database Development Life Cycle phases. (15 Marks) b) Identify strong and weak (if any) entities from the scenario. Clearly mention the attributes types of each entity

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

I need help on this database SQL questions refer to the table given. Thank you 1) Provide the average number of people that have been on each flight number. Hint Project the difference of the total...

Please help me with this database relational algebra(for example, I need answer to have this format. "concat(Fname, Lname)->fullname,Bdate,Sex Super_ssn=333445555 (Employee)" questions refer to the...

Develop an Entity-Relationship diagram for Scoundrel Airline's database for flight information and reservations. Scoundrel Airlines wants to keep information on its airplanes . They want to record...

need some help about how to go about doing this 11 B IV A - A. 3b. Design the Database (E-R Diagram): John took an MIS class at GVSU and he remembers that the first step in designing a database using...

Draw an E-R diagram that models the following situation: You were hired to maintain a database for an airport management company. They keep track of multiple airports, each of which has a unique...

Types 01 (10 Marks) Question 2 (25 Marks) For the given business scenario, you are required to provide the following. a) Create the E-R diagram with appropriate relationships and cardinalities. (You...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

1. Draw an entity-relationship diagram for the following case. The United Nations wants to develop a global database, tracking countries, cities, and multinational companies. For each country, the UN...

Assignment 2 uses structured design implemented in C. Array of records (structs) with file I/O is needed. The program takes two inputs at a time. The name of a person, and, the coin value as an...

10 V and R=1 kQ. Find a value for R, that gives a hysteresis In the circuit of Fig. 13.20(a) let I. of 100-mV width. R1 R2 O vo (a)

Briefly describe five situations where consumption timing is an important consideration. Please make sure to identify the timing of the cash flows, the nature of the problem ( saving / investing or...

What is one of the greatest benefits of using a materials requirements planning ( MRP ) system? The ability to eliminate stock - outs The ability to avoid facility shutdowns Stock - out costs are...

What should the union do now? Explain your answer. Perhaps the biggest stories about unions and the work environment over the past couple of years has been the issue of sexual harassment and how...

Should there be consequences for the employer for not dealing with the matter sooner? Why or why not? Perhaps the biggest stories about unions and the work environment over the past couple of years...

During a union organizing drive, labour and management will develop a plan to present their perspectives to employees. A goal of each side will be to collect information on the other that can be used...