Consider the following relation: AIRPORTS AND GATES AirlineNumberOf NumberOfGates AirportID AirportCity CityPopulation AirlineName Employees Assigned Chicago, IL Chicago, IL Chicago, IL ORD 3.1 million United 20000 12 ORD 3.1 million Jet Blue 6000 2 ORD 3.1 million American 22000 10 ATL Atlanta, GA 1.2 million Delta 17000 12 ATL Atlanta, GA 1.2 million Jet Blue 6000 3 LAX Los Angeles, CA 4.0 million United 20000 10 MDW Chicago, IL 3.1 million Delta 17000 3 MDW Chicago, IL 3.1 million Southwest 20000 15 Some of the requirements that this table is based on are as follows: • Each airline has a unique AirlineName and an AirlineNumberOfEmployees • Each airport has a unique AirportID and a name of the city (AirportCity) where it is located. • Each city has (one, of course) CityPopulation. • A city can have more than one airport. • Each airport assigns certain number of gates (NumberOfGatesAssigned) to the airlines that serve it. 1) Copy the figure below and indicate functional dependencies by drawing lines with arrows. AirlineNumberOf NumberOfGates AirportID AirportCity CityPopulation AirlineName Employees Assigned

Consider the following relation: AIRPORTS AND GATES AirlineNumberOf NumberOfGates AirportID AirportCity CityPopulation AirlineName Employees Assigned Chicago, IL Chicago, IL Chicago, IL ORD 3.1 million United 20000 12 ORD 3.1 million Jet Blue 6000 2 ORD 3.1 million American 22000 10 ATL Atlanta, GA 1.2 million Delta 17000 12 ATL Atlanta, GA 1.2 million Jet Blue 6000 3 LAX Los Angeles, CA 4.0 million United 20000 10 MDW Chicago, IL 3.1 million Delta 17000 3 MDW Chicago, IL 3.1 million Southwest 20000 15 Some of the requirements that this table is based on are as follows: • Each airline has a unique AirlineName and an AirlineNumberOfEmployees • Each airport has a unique AirportID and a name of the city (AirportCity) where it is located. • Each city has (one, of course) CityPopulation. • A city can have more than one airport. • Each airport assigns certain number of gates (NumberOfGatesAssigned) to the airlines that serve it. 1) Copy the figure below and indicate functional dependencies by drawing lines with arrows. AirlineNumberOf NumberOfGates AirportID AirportCity CityPopulation AirlineName Employees Assigned

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

Similar questions

153. In the network model, the one to many relationship is denoted by a. 1:N b. 1:M c. 2:M d. 3:M
Define Normalization & Normalize the following table to 3rd NF
Write a SQL statement to create the table Task.
Question 13 sum .Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line
The spreadsheet contains codes (BA, DA, SA) to represent agent roles (Buyer's Agent, Dual Agent, Seller's Agent). You want to switch the codes for the actual descriptions. In cell E12 of the Details sheet, insert the SWITCH function to evaluate the agent code in cell D12. Include mixed cell references to the codes and roles in the range J2:K4 for the values and results arguments. use all cell references in the function. Copy the function to the range E13:E39. Now you want to calculate the number of days between the list date and sale date. In cell J12, insert the DAYS function to calculate the number of days between the Listing Date and the Sale Date. Copy the function to the range J13:J39. You want to calculate agent commissions based on their role. In cell K12, insert the IFS function to calculate the agent's commission based on the agent code and the applicable rates in the range L2:L4. Use relative and mixed references correctly. Copy the function to the range K13:K39. You want to…
Make it this schema diagram to ER diagram
Relational Database Consider the following relation: Invoice(Order_ID, Order_Date, Customer_ID, Customer_Name,Customer_Address,Product_ID, Product_Desc, Price, Order_Quantity) FD1 - Order_ID -> Order_Date, Customer_ID, Customer_Name, Customer_Address FD2 - Customer_ID -> Customer_Name, Customer_Address FD3 - Product_ID -> Product_Description, Price FD4 - Order_ID, Product_ID -> Order_Quantity Give reasons to explain if this is in 2NF or not. If not, decompose it to 2NF. Give reasons to explain if this is in 3NF or not. If not, decompose it to 3NF.
Manufacturer Name(PK) Country ContactName ContactPhone 11 Makes RentalDate ReturnDate TotalCost Car Customer VIN(PK) Model Cust Num(PK) Rents Name Year Address Class Phone 11 Has Maintenance Events RepairNum (PK) Date Procedure Mileage Answer the following questions: 1. What is Maintenance Events in this diagram?
Consider the following ER diagram. Attribute 'Code' is an example of a for entity FARE. Airport_code City State Name AIRPORT Company M CAN_ LAND N Type_name Max_seats AIRPLANE TYPE TYPE N Airplane_id AIRPLANE Seat_no SEAT Scheduled_dep_time Dep_time Total_no_of_seats Customer_name DEPARTS N N ASSIGNED DEPARTURE AIRPORT N ARRIVES ARRIVAL AIRPORT RESERVATION N Cphone Scheduled_arr_time Arr_time N N INSTANCE_OF Instances N 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.
Please provide answer and explanation as well
Relational Database Consider the following relation: Invoice(Order_ID, Order_Date, Customer_ID, Customer_Name,Customer_Address,Product_ID, Product_Desc, Price, Order_Quantity) FD1 - Order_ID -> Order_Date, Customer_ID, Customer_Name, Customer_Address FD2 - Customer_ID -> Customer_Name, Customer_Address FD3 - Product_ID -> Product_Description, Price FD4 - Order_ID, Product_ID -> Order_Quantity What are the candidate keys of this relation? Give reasons to explain if this is in 1NF or not. If not, decompose it to 1NF.
1. Converting ERDto Relations STORE H StoreID StoreName CUSTOMER CustomerID CustomerName INVENTORY QuantityOnHand DELIVERY Delivery Date PURCHASE Purchase Date PET PetID PetName PetDescription Price Cost SupplierName Shipping Time H