In the following ER diagram, the Key for LEG_INSTANCE must includeAirport_code City State NameCompanyType_name Max_seatsDateSeat_noAIRPORTLeg_noMCANLANDNAirplane_idNumberAIRPLANE_TYPETYPE1NAIRPLANESEATAirport_codeSeat_noScheduled_dep_timeTotal_no_of_seatsCustomer_nameScheduled_arr_timeScheduled_dep_timeDep_timeNDEPARTS1NASSIGNEDDEPARTUREAIRPORTNARRIVESNARRIVALAIRPORTRESERVATIONCphoneScheduled_arr_timeArr_timeNNINSTANCE_OFNInstancesNumberAirlineWeekdaysRestrictionsAmountCodeNo_of_avail_seatsLEG_INSTANCEDateLeg_noFLIGHT LEGNLEGSFLIGHT1FARESNFARENotes:A LEG (segment) is a nonstop portion of a flightA LEG_INSTANCE is a particular occurrenceof a LEG on a particular date.

As per the given information, we need to find the key attributes that should compose the LEG…

In the following ER diagram, the Key for LEG_INSTANCE must include Airport code City State Name Company AIRPORT Type_name Max_seats Date Seat_no Leg_no Number CAN LAND N Airplane_id M AIRPLANE TYPE TYPE N AIRPLANE SEAT Seat no Airport_code Total_no_of_seats Scheduled_dep_time Customer_name Scheduled arr time Dep_time Scheduled_dep_time DEPARTS N ASSIGNED DEPARTURE AIRPORT N RESERVATION ARRIVAL AIRPORT ARRIVES Scheduled_arr_time Cphone Arr_time N INSTANCE_OF Instances LEGS Number Airline Weekdays Restrictions Amount Code No_of_avail_seats LEG_INSTANCE Leg_no Date FLIGHT LEG FLIGHT FARES FARE 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.

In the following ER diagram, the Key for LEG_INSTANCE must include Airport code City State Name Company AIRPORT Type_name Max_seats Date Seat_no Leg_no Number CAN LAND N Airplane_id M AIRPLANE TYPE TYPE N AIRPLANE SEAT Seat no Airport_code Total_no_of_seats Scheduled_dep_time Customer_name Scheduled arr time Dep_time Scheduled_dep_time DEPARTS N ASSIGNED DEPARTURE AIRPORT N RESERVATION ARRIVAL AIRPORT ARRIVES Scheduled_arr_time Cphone Arr_time N INSTANCE_OF Instances LEGS Number Airline Weekdays Restrictions Amount Code No_of_avail_seats LEG_INSTANCE Leg_no Date FLIGHT LEG FLIGHT FARES FARE 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.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: 3. Write a query to display the book number, book title, and subject for every book sorted by book…

A: In the database management and information organization, a common scenario involves designing…

Q: Dete Adess Year of_death Purchase date Number_of entais Nane Year of Jath Code Times eted Number…

A: we need to convert given E-R diagram to Relational schema. For N: M relation we have created a New…

Q: 5. Write a query to display the checkout number, book number, patron ID, checkout date, and due date…

A: The problem involves retrieving key information from a database tracking book checkouts by patrons.…

Q: Costumer_ID Contact No Order_Total Order No COSTUMER 1 n ORDER Order Date n Name Mode_of_Payment…

A: It is evident by looking at the ERD that, there are no relationships between the attributes which…

Q: Based on the diagram. 30.Display the name of the passengers whose tickets include only one flight.

A: The above question is solved in step 2 :-

Q: .Display the seating capacity, fuel capacity, and miles per gallon for all aircraft manufactured by…

A: The correct answer is given below with an explanation. I cannot attach the output as I don't have…

Q: C++ Visual 2019 Insert into the PADDLING table the trip ID, trip name, state, distance, maximum…

A: the code is here

Q: A USE statement __________ None of these Identifies the database within which the query is…

A: D. All of these.

Concept explainers

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.

Question

In the following ER diagram, the Key for LEG_INSTANCE must include
Airport_code City State Name
Company
Type_name Max_seats
Date
Seat_no
AIRPORT
Leg_no
M
CAN
LAND
N
Airplane_id
Number
AIRPLANE_
TYPE
TYPE
1
N
AIRPLANE
SEAT
Airport_code
Seat_no
Scheduled_dep_time
Total_no_of_seats
Customer_name
Scheduled_arr_time
Scheduled_dep_time
Dep_time
N
DEPARTS
1
N
ASSIGNED
DEPARTURE
AIRPORT
N
ARRIVES
N
ARRIVAL
AIRPORT
RESERVATION
Cphone
Scheduled_arr_time
Arr_time
N
N
INSTANCE_OF
N
Instances
Number
Airline
Weekdays
Restrictions
Amount
Code
No_of_avail_seats
LEG_INSTANCE
Date
Leg_no
FLIGHT LEG
N
LEGS
FLIGHT
1
FARES
N
FARE
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.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Introduction

VIEW

Step 2: Choosing Keys Explanation

VIEW

Step 3: Why remaining options are not necessary

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Lab 8-1: KimTay Pet Supplies Task 6: Create the GET_INVOICE_DATE procedure to obtain the customer ID, first and last names of the customer, and the invoice date for the invoice whose number currently is stored in I_INVOICE_NUM. Place these values in the variables I_CUST_ID, I_CUST_NAME, and I_INVOICE_DATE respectively. When the procedure is called it should output the contents of I_CUST_ID, I_CUST_NAME, and I_INVOICE_DATE. IN SQL CODE. CUSTOMER CUST_ID FIRST_NAME LAST_NAME ADDRESS CITY STATE POSTAL EMAIL BALANCE CREDIT_LIMIT REP_ID 125 Joey Smith 17 Fourth St Cody WY 82414 jsmith17@example.com 80.68 500.00 05 182 Billy Rufton 21 Simple Cir Garland WY 82435 billyruff@example.com 43.13 750.00 10 227 Sandra Pincher 53 Verde Ln Powell WY 82440 spinch2@example.com 156.38 500.00 15 294 Samantha Smith 14 Rock Ln Ralston WY 82440 ssmith5@example.com 58.60 500.00 10 314 Tom Rascal 1 Rascal Farm Rd Cody WY 82414 trascal3@example.com 17.25 250.00 15 375 Melanie Jackson 42…
Access Assignment Problem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information. The following table contains the clients’ information. Client Number Client Name Street City State Postal Code Telephone Number Billed Paid Technician Number AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 $315.50 $255.00 22 AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 $535.00 $565.00 23 BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 $229.50 $0.00 23 DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 $485.70…
Please refer to the following diagram for Q19 to Q20. PERSON PK P_ID P_LNAME P_FNAME ΕMPLOYΕ P_ID EMP_HIRE_DATE STUDENT P ID STUDY ΜAIOR PK, FK1 PK, FK1 19. Which of the following statements is/are true? (1) A Person must be either a Student or an Employee. (2) A Person can neither be a Student nor an Employee. (3) A Person must be a Student or an Employee or both. a. (1) only b. (3) only c. (1) and (2) only d. (1), (2) and (3).
Customers CustomerID INT ◆ FirstName VARCHAR(50) ◆ LastName VARCHAR(50) H > Email VARCHAR(100) > Address TEXT Indexes F | Orders OrderID INT > CustomerID INT > OrderDate DATE ◆ TotalAmount DECIMAL (10,2) Indexes # ShippingInformation ShippingID INT > OrderID INT → ShippingAddress TEXT ShippingDate DATE -K > EstimatedArrivalDate DATE → ShipmentStatus VARCHAR(50) Indexes Reviews ReviewID INT > ProductID INT > CustomerID INT ◆ Rating INT Comment TEXT > DatePosted DATE Indexes OrderDetails OrderDetailID INT ▶I > OrderID INT HI-KO ProductID INT → Quantity INT Subtotal DECIMAL (10,2) Indexes T Categories CategoryID INT ◆ CategoryName VARCHAR(255) Indexes Products ProductID INT -H ProductName VARCHAR(255) > Description TEXT ◆ Price DECIMAL (10,2) -I+ CategoryID INT > DiscountID INT Indexes Discounts DiscountID INT ◆ Discount Code VARCHAR(50) ◆ Discount Percentage DECIMAL (5,2) > StartDate DATE > EndDate DATE Indexes For the design above, Write in SQL a query to print customer names who made…
Need help identifying and establishing Primary keys and foreign keys
ERD to Relational
ERD:- PK CHECKOUT Check Num FK1 Book_Num FK2 Pat_ID Check Out Date Check_Due Date Check_In_Date PK BOOK Book Num Book Title Book_Year Book_Cost Book_Subject FK1 Pat_ID -H- PATRON PK Pat ID Pat_FName Pat_LName Pat_Type WRITES PK,FK1 Book Num PK,FK2 Au ID AUTHOR PK AU ID Au_FName Au_LName Au_BirthYear