Answer the following questions according to the ERD of the Airport system:AIRPORTFLIGHTAIRPORTCODEFLIGHTNUMFK ARPORTICUSTOMERCUSTOMERNUMDTIMEAIRPOR NAMECITYSTATEDDATEATIMEADATEDESTINATIONARPORTPRICEARPLANENUMFKOAIRPORTCODEFK)FIRSTNAMEMDOLENAMELASTNAMESTREETNUMBERSTREETNAMECITYSTATEPHONEFKAIRPORT IFK AIRPLANEFK FLIOHTFK CUSTOMERAIRPLANEPAYMENTFLIOHTNUMEKOCUSTOMERNUMEK)AIRPLANENUMAIRPLANENAMECREDITCARDTYPECREDITCARDNUMCAPACITYAIRPORTCODE(FIOBOOKDATEHOLDDATEEXPIREDHOLDDATEA. 4How many primary key in the Flight entity?B.5How many tables in the system can Customer table retrieve data from?C.1How many attributes in the Airport Table?D.5How many tables in the system?E. 5How many relationships shown in the system?Click Save and Submit to save and submit. Click Save Al Answers to save all answers.> >> >

Answer to the above question is in step2.

AIRPORT AIRPORTCODE AIRPOR NAME FIGHT FLIGHTNUM CUSTOMER CUSTOMERNUM FIRSTNAME MIDDLENAME LASTNAME STREETNUMBER STREETNAME FK AIRPORTI DTIME DDATE ATIME ADATE DESTINATIONAIRPORT PRICE ARPLANENUM(FK AIRPORTCODE(FKO CITY STATE CITY STATE PHONE FK AIRPORT FK AIRPLANE FK FLIOHT FK CUSTOMER AIRPLANE PAYMENT FLIOHTNUMFIO CUSTOMERNUM(FKO CREDITCARDTYPE CREDITCARDNUM BOOKDATE HOLDDATE EXPIREDHOLDDATE AIRPLANENUN AIRPLANENAME CAPACITY AIRPORTCODE(FKO A. 4 How many primary key in the Flight entity? B. 5 How many tables in the system can Customer table retrieve data from? C. 1 How many attributes in the Airport Table? D.5 V How many tables in the system? E. 5 How many relationships shown in the system? > > > > >

AIRPORT AIRPORTCODE AIRPOR NAME FIGHT FLIGHTNUM CUSTOMER CUSTOMERNUM FIRSTNAME MIDDLENAME LASTNAME STREETNUMBER STREETNAME FK AIRPORTI DTIME DDATE ATIME ADATE DESTINATIONAIRPORT PRICE ARPLANENUM(FK AIRPORTCODE(FKO CITY STATE CITY STATE PHONE FK AIRPORT FK AIRPLANE FK FLIOHT FK CUSTOMER AIRPLANE PAYMENT FLIOHTNUMFIO CUSTOMERNUM(FKO CREDITCARDTYPE CREDITCARDNUM BOOKDATE HOLDDATE EXPIREDHOLDDATE AIRPLANENUN AIRPLANENAME CAPACITY AIRPORTCODE(FKO A. 4 How many primary key in the Flight entity? B. 5 How many tables in the system can Customer table retrieve data from? C. 1 How many attributes in the Airport Table? D.5 V How many tables in the system? E. 5 How many relationships shown in the system? > > > > >

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

Consider the obstacles that you will need to overcome in order to construct the framework, and after that, examine the difficulties and roadblocks that are associated with each prospective solution. Is it conceivable that moving our computer demands to the cloud via outsourcing may assist us in resolving these issues? Should this be taken into account, or is it not relevant to the discussion at hand?
Suppose you had an information/briefing session with college’s Chief Information Officer (CIO) on some of the key use cases of the Campus Access Control System (CACS). The CIO described the process that the student lab-access sub-system goes through to authorise student’s access to the laboratories. Essentially, the lab access sub-system interacts with CACS and retrieves a list of students that are authorised to access a particular lab. If the student who is currently swiping her access card is in this list, then the lab access sub-system will grant access, otherwise access is denied.Use Visual Studio modelling tools to create a Use Case Diagram and a Sequence Diagram for the above process as described.
What opinions do you have on the usage of email? What steps must be taken in order for an email to be delivered from A to B? Make a mental note of how much you understand right now. What does it mean precisely to distinguish between objects, and why is it so crucially necessary to do so? Take a look at how much minute detail has been included into each model (or abstraction).
The functional capabilities of a user interface that are essential for successful navigation should be listed and defined. Which skills are indispensable? Will there be parity across platforms? Please back up your assertions with an appropriate example.
Just what is the difference between a private business address and a reserved one?
The open systems interconnection (OSI) paradigm has seven distinct layers to its structure. What do you mean by that? Provide a condensed description of the function (or functions) that each layer is responsible for serving.
Air Sial, a recent addition in aviation industry of Pakistan is getting fame and has started airline operations domestically for selected routes. The airline is computerizing its passenger reservation system. At the end of the JAD meeting, it was finalized that the data items must include reservation number, flight number, flight date, origin, destination, departure time, arrival time, passenger name, and seat number. For example, flight number 508 leaves Karachi, daily at 9:00 a.m. and arrives in Lahore, at 10:15 a.m. A typical reservation code might be HXCGGTB, for passenger Tahir Khan, in seat 15A, on flight 508 on 21/2/2021. Design an ERD for the passenger reservations system. design 3NF table designs for the system ?
draw a use case diagram for university chatting group system. Admin: Administrator will be able to create an account. Administrator will be able to login. Administrator will be able to create different chat groups according to different disciplines or general such as Data base group, Networking group, Embedded system group, Assignment group, Machine learning group, Artificial Intelligence (AI) group, and Fun group etc. Administrator will be able to approve requests to enter a group. Administrator will be able to reject requests to enter a group. Administrator will be able delete a person from a chat group. Administrator will be able to devise rules and regulations for each chat group. If a user does not follow the rules and regulations of a certain group then administrator will be able to mute that specific user. User: User will be able to sign up to the application. User will be able to join a group of his/her own choice. Upon entering a chat group, general terms and conditions…
What are the seven distinct layers of the open systems interconnection (OSI) paradigm? Please provide a concise explanation of each layer's function(s).
In the discipline of computer science, where exactly does the practice of computing in the cloud fit into the larger picture of an organization's organizational structure and day-to-day operations?
In my opinion, a web server is a highly intricate system due to its multifaceted nature and the diverse range of tasks it performs. It is responsible for handling a variety of requests from clients, processing and delivering web pages, managing databases, and ensuring security. Additionally, web servers must be able to handle a large volume of traffic and provide reliable performance. Despite its complexity, a web server offers several advantages over other available solutions, such as the ability to support multiple programming languages and platforms, scalability, and flexibility.
How beneficial is a standard user interface in terms of the design of the SoS user interface? Which characteristics of a unified user interface influence its cost-effectiveness?