For the Statement of Requirements (SOR) scenario below, create the following: 1. ERD (Entity Relationship Diagram)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
For the Statement of Requirements (SOR) scenario below, create the following: 1. ERD (Entity Relationship Diagram) 2. RDM (Relational Data Model) 3. SQL Data Definition Language (DDL) statements to define this database structure 4. SQL Data Manipulation Language (DML) statements to populate data into this database 5. 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 1. Airport 3 Character Designator 2. Airport Name 3. Primary City and State serviced by the airport 4. Airport Geographic Location Flight Data 1. Airline Name 2. Flight Number 3. Departure Airport Code 4. Departure Airport Name 5. Arrival Airport Code 6. Arrival Airport Name 7. Departure Date and Time 8. 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 1. Airline Name 2. Flight Number 3. Departure Date and Time 4. Destination to Airport Name Timetable of All Flight Arrivals for a given airport for a given city and a given date 1. Airline Name 2. Flight Number 3. Arrival Date and Time 4. Arrival from Airport Name For the Statement of Requirements (SOR) scenario below, create the following: 1. ERD (Entity Relationship Diagram) 2. RDM (Relational Data Model) 3. SQL Data Definition Language (DDL) statements to define this database structure 4. SQL Data Manipulation Language (DML) statements to populate data into this database 5. 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 1. Airport 3 Character Designator 2. Airport Name 3. Primary City and State serviced by the airport 4. Airport Geographic Location Flight Data 1. Airline Name 2. Flight Number 3. Departure Airport Code 4. Departure Airport Name 5. Arrival Airport Code 6. Arrival Airport Name 7. Departure Date and Time 8. 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 1. Airline Name 2. Flight Number 3. Departure Date and Time 4. Destination to Airport Name Timetable of All Flight Arrivals for a given airport for a given city and a given date 1. Airline Name 2. Flight Number 3. Arrival Date and Time 4. Arrival from Airport Name
Expert Answer:
Answer rating: 100% (QA)
Answer Create Airport Data Table CREATE TABLE Airpor... View the full answer
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date:
Students also viewed these databases questions
-
What might be a good government policy to solve the problem of the environmental externality that leads to high greenhouse gas emissions? Explain in detail.
-
ConAir (CA) commercial airlines company requires you experience in database design and have approached you to assist in the design of their new airline database system. They urgently need to have...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Which of the following options are available for creating a policy in Qualys Policy Compliance? (Choose three) A, Create from Host B, Create from Scratch C, Import from Library D, Import from CSV File
-
Determine the magnitude and coordinate direction angles of F3 so that the resultant of the three forces acts along the positive y axis and has magnitude F. Given: F = 600 lb F1 = 180 lb F2 = 300 lb...
-
(4 pts) Gravitational Acceleration: Setup h (mm) 2R 2L 3R 3L D (m) Slope ( 6Slope ( g (#) g (#) (5 pts for each graph) Include your SciDAVis graphs in your answer document. (You should have 5: One...
-
To build an information system, which do you need to identify first, classes or objects?
-
How would you handle the issue if you were in Ricardo's position? Develop an action plan to get your point of view across. What would you say? What do you expect the objections or push-back will be?...
-
Betty Corporation issued $ 4 4 0 , 0 0 0 of 4 % , 1 0 - year bonds on January 1 , 2 0 2 4 , for $ 4 0 5 , 7 0 4 . This price provided a yield of 5 % on the bonds. Interest is payable semiannually une...
-
Create a program that will scrape the sayings from: https://quotes.toscrape.com/page/2/ Set up your program to allow the user to input a page number (1-10) which will return the quotes from that...
-
Assume a corporation has just paid a dividend of $ 1.56 per share. The dividend is expected to grow at a rate of 3.2% per year forever, and the discount rate is 5.2%. What is the Capital Gains yield...
-
In eukaryotes, what is meant by the term DNA replication licensing? How does the process occur?
-
A double-stranded DNA molecule contains 560 nucleotides. How many complete turns occur in this double helix?
-
H ow are two topoisomers different from each other? How are they the same?
-
Compare the structural features of a double-stranded RNA molecule with those of a DNA double helix.
-
Single-strand binding proteins keep the two parental strands of DNA separated from each other until DNA polymerase has an opportunity to replicate the strands. Suggest how single-strand binding...
-
Guess the missing numbers 3, -6, 12, 4, 20, ? 13 14 6 16 7, 16, 8, 27, 9, ? 27 10 40 37 7, 21, 8, 72, 9, ? 81 243 123 136 2, 7, 26, 101, 400, ? 1595 800 695 1840
-
What impact has the Internet had on the globalization of small firms? How do you think small companies will use the Internet for business in the future?
-
What is the difference between F, F+, and Fc?
-
What is a unique identifier of an entity type? Is it possible for there to be more than one unique identifier for an entity type?
-
What do you think are the ultimate consequences of failure to "preserve information" in the data model mapping process?
-
If youd like to have $5,000,000 at retirement in 45 years and you expect to earn 10 percent annually, which is around the average return over the past 50 years, what lump sum would you have to invest...
-
Obaidullah Hamzah, who recently sold his Ford Mustang, placed $15,000 in a savings account paying annual compound interest of 7 percent. a. Calculate the amount of money that will be accrued if he...
-
How many years will the following take? a. \($550\) to grow to \($1,049.50\) if invested at 6 percent compounded annually b. \($37\) to grow to \($63.87\) if invested at 9 percent compounded annually...
Study smarter with the SolutionInn App