Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

DO NOT COPY OTHER CHEGG'S ANSWER I will report you if you copy answer from other chegg's answer. I want you to do yours, not

DO NOT COPY OTHER CHEGG'S ANSWER

I will report you if you copy answer from other chegg's answer. I want you to do yours, not copy from other people's answer.

Introduction

Founded in 2010, CSC353 Air is the largest airline company of UW with greater than 100,000 hours of flights, 3 million satisfied passengers from 9 different domestic destinations. It has the highest capacity aircraft, all equipped with modern technology stuffs ensuring quality & safe flying.

Air has several branches in different countries. Most branches are in UW on many states. Its dedicated employees are keen to prove the quality service often recommended by its customers. CSC353 Air is well known for low airfare for both way routes services across domestic customers. Highly dedicated in customer services, CSC353 Air offers several discount schemes for children and people with disabilities. CSC353 Air has won multiple awards for its safety & reliability records of flying from national and international organizations. Due to its high reliability, safety records and highly gained trusts from customers, CSC353 Air is having more transactions, cUWsing day to day expanding business activities hard to manage its operations. To ensure more flexible service for customers, its highly recommended to implement an Airlines Reservation System, a computerized system that will help manage all information related to the operation of the system.

You have been asked to build the CSC353 Airline Reservation System. To start, do a more detailed analysis of the above system and provide the following:

1. In detail, Identify all the appropriate entities (with keys), attributes, relationships, and constraints

2. Provide a complete ER diagram for the database (Use Visual Paradigm, or similar tool)

3. Make any assumptions that are relevant to the system. Clearly define your assumption.

(Only do the question 1 and 2)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database Systems

Authors: Sham Navathe,Ramez Elmasri

5th Edition

B01FGJTE0Q, 978-0805317558

More Books

Students also viewed these Databases questions