Draw an ERD for below scenario by pen and upload the picture in the upload section below(4 marks); /Major airlines companies that provide passenger services in Oman are: OmanAir, SalamAir etc. Public Authority for Civil Aviation (PACA) keeps a database with lots of information on all airlines. Thisinformation is made accessible to all airlines in Oman with the intention of helping the Companies assess their Competitive position in the domestic market. the lnformation kept consists of: 8Lach alriine has an identification number, name of the contact person and telephone number. 5 Yor each aircraft identification number, capacity and model is recorded. o Each employee bas an employee idontification nomber, name, address, birthday, sex, position with the company and qualification. O Each routehas a route identification number, origin, destination, classification (into domestic or international route), distance of the route and price charged per passenger Each airline keeps information about their buy/sell tramactions tfor example, snlling an airplane ticket is a sell transaction, paying for maintenance is a buy tranaetion) o Each transaetion has a transaction identification number, date, desciption and amountof money pald/received.
Draw an ERD for below scenario by pen and upload the picture in the upload section below(4 marks); /Major airlines companies that provide passenger services in Oman are: OmanAir, SalamAir etc. Public Authority for Civil Aviation (PACA) keeps a database with lots of information on all airlines. Thisinformation is made accessible to all airlines in Oman with the intention of helping the Companies assess their Competitive position in the domestic market. the lnformation kept consists of: 8Lach alriine has an identification number, name of the contact person and telephone number. 5 Yor each aircraft identification number, capacity and model is recorded. o Each employee bas an employee idontification nomber, name, address, birthday, sex, position with the company and qualification. O Each routehas a route identification number, origin, destination, classification (into domestic or international route), distance of the route and price charged per passenger Each airline keeps information about their buy/sell tramactions tfor example, snlling an airplane ticket is a sell transaction, paying for maintenance is a buy tranaetion) o Each transaetion has a transaction identification number, date, desciption and amountof money pald/received.
Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter5: Advanced Data Modeling
Section: Chapter Questions
Problem 8C
Related questions
Question
4
Transcribed Image Text:Draw an ERD for below scenario by pen and upload the picture in the upload section below(4 marks);
Major airlines companies that provide passenger services in Oman are:OmanAir, SalamAir etc.
Public Authority for Civil Aviation (PACA) keeps a database with lots of information on all airlines.
Thisinformation is made accessible to all airlines in Oman with the intention of helping the Companies assess their Competitive position in the domestic
market.
The information kept consists of:
8Each airiine has an identification number, name of the contact person and telephone number.
6 Toreach aircraft identification number, capacity and model is recorded.
o Each employeebas an employee idontification nomber, name, address, birthday, sex, position with the company and qualification.
O Ench routehaya route identification number, origin, destination, classification (into domestic or international route), distance of the route and price
charged per passenger
o Each airline keeps information about their buy/sell transactionstfor example, anling an airplane ticket is a sell transaction, paying for maintenance is a
buy tranaction
o Each transaetion has a transaction identification number, date, desciption and amountof monty pald/received.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
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.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage