Question: Submit Relational Model of ER diagram of Figure 7.29 in the Book (Q2 from Week 4 Lab) Q 2. Solve question 7.32 from textbook -

Submit Relational Model of ER diagram of Figure 7.29 in the Book (Q2 from Week 4 Lab)

Q 2. Solve question 7.32 from textbook - Consider the ER diagram of Figure 7.29, which shows a simplified schema for an airline reservations system. Extract from the ER diagram the requirements and constraints that resulted in this schema. Try to be as precise as possible in your requirements and constraints specification. An ER diagram for an AIRLINE database schema Airport_code City State Name DEPARTURE AIRPORT N Leg.no AIRPORT Scheduled_dep_time Scheduled_arr_time FLIGHT_LEG N LEGS FLIGHT M ARRIVAL N CAN AIRPORT Instances LAND N Number Type_name Max_seats INSTANCE OF Company Airline AIRPLANE Arr_time TYPE Weekdays DEPARTS ARRIVES Restrictions N (Dep_time) N Amount TYPE N Code FARES FARE Airplane_id Total_no_of_seats No_of_avail_seats Date LEG_INSTANCE AIRPLANE ASSIGNED Customer_name Cphone Seat no RESERVATION N SEAT Notes: A LEG (segment) is a nonstop portion of a flight A LEG_INSTANCE is a particular occurrence of a LEG on a particular date

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 Databases Questions!

SIT103 Data and Information Management T2, 2023 Summative assessment task-2: A real-world database design and implementation project Due dates: Part-1: Project proposal, due date: Wednesday 10th May...

My question is how should this look. Below this is my chart but not sure if I am corrrectly? The purpose of this assignment is to practice on the creation of a Relational Data Model from an Entity...

Please answer this question fully with every step. I will give a thumbs up if right. This is Database. Problem 3 Consider the bookstore E-R in Fig 6.30 in the 7 th ed of textbook (Figure 7.29 in 6th...

ER Modeling Question 1: [10 Marks] Assume your company is developing a generic digital camera online purchasing system that can be sold to different camera stores. An initial analysis phase of the...

6.1. Carbondale Company has the following credit policy 2/10, net 30. Carbondale also charges 1% per month interest on all accounts after 30 days. The following table shows the collection schedule of...

8.1. Dulles Electric Company buys 1 million tons of coal annually to burn at its power plant. The company wants to invest in a unit train that will haul coal from the mine to the power house, where...

Project Introduction This assignment allows students to demonstrate their skills in designing relational databases to satisfy specific business rules and requirements. The deliverables for this...

Submit Relational Model of ER diagram An ER diagram for an AIRLINE database schema Airport_code City State Name DEPARTURE AIRPORT N Leg.no AIRPORT Scheduled_dep_time Scheduled_arr_time FLIGHT_LEG N 1...

I want an electronic drawing of the ER diagram, & MAP diagram, & code SQL , and a screenshot of the output and this data below ER Diagram: [Customer(Customer ID, Name, Phone, City)] --[Has...

What types of interviews are common in todays business environment and how do they different from one another?

Calculate the O:Si ratio when 30 wt% Y2O3 is added to SiO2. Will this material provide good glass-forming tendencies?

When technical analysts suggest that a share has good relative strength , explain how should an investor interpret it .

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

KEY QUESTION Between 1990 and 2005 the U.S. price level rose by about 50 percent while real output increased by about 56 percent. Use the aggregate demandaggregate supply model to illustrate these...

Productivity often rises during economic expansions and falls during economic recessions. Can you think of reasons why? Briefly explain. (Hint: Remember that the level of productivity involves both...

What is meant when economists say that the U.S. economy has a higher safe speed limit than it had previously? If the New Economy has a higher safe speed limit, what explains the series of...