Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I want a unique answer, will upvote, please do not copy from the same question. For the Statement of Requirements (SOR) scenario below, create the
I want a unique answer, will upvote, please do not copy from the same question.
For the Statement of Requirements (SOR) scenario below, create the following:
- ERD (Entity Relationship Diagram)
- RDM (Relational Data Model)
- SQL Data Definition Language (DDL) statements to define this database structure
- SQL Data Manipulation Language (DML) statements to populate data into this database
- SQL Data Manipulation Language (DML) statements to generate some basic reports and queries given below.
Given the Statement of Requirements (SOR) scenario
The system should track the following data:
Airport Data
- Airport 3 Character Designator
- Airport Name
- Primary City and State serviced by the airport
- Airport Geographic Location
Flight Data
- Airline Name
- Flight Number
- Departure Airport Code
- Departure Airport Name
- Arrival Airport Code
- Arrival Airport Name
- Departure Date and Time
- Arrival Date and Time
Note: Each flight segment has a unique flight number.
The system should produce the information:
Timetable of All Flight Departures for a given airport for a given city and a given date
- Airline Name
- Flight Number
- Departure Date and Time
- Destination to Airport Name
Timetable of All Flight Arrivals for a given airport for a given city and a given date
- Airline Name
- Flight Number
- Arrival Date and Time
- Arrival from Airport Name
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started