There are 2 questions in the following screenshot. The second question is all i

Question

There are 2 questions in the following screenshot. The second question is all i need to be answered, and please include scenerios. Thanks

This airlines database contains several entities and several relationships between them 1. Your boss wants to investigate moving to a simpler, more streamlined way of doing business. He has asked you to fill out the following flat file, with an alternate arrangement of the flight data. Use your airlines database and populate itwith the first five flights in the ai nes database. You can use any criteria you like to define first. If you have questions about some of the fields, make sure include those in your memo. In the meanwhile, assume what you need to assume to generate the fields. Put your answers directly in the light blue area below. Airporucode-Destination Departure oaterime ArvaUDeterime Arportcode Fight ID Airport Code origin 2. You have some concerns about moving your entire airline operations out of SQL to this flat file format. Write your boss a memo, outlining any concerns or hesitations you have about moving to this format for management of your data. Include the pros and cons of the relational database format and the flat file format. Be sure to critically, and include any problema Put the text of your memo in the text box below. You are welcome to expand the text box or append another text box if you need more space. Answer goes here Dashboard Readme SQL template Setup Problem 1 Problem 2 Problem 3 Problem 4 Problem 5 Problem 6 Problem 7 Problem 8 Problem 9 Problem 10 Ready

Explanation / Answer

Solution:

  Memorendum

To: xyz, CTO (depending on the designation of your boss)

From: xyz, Your designation

Date: 06/10/2017

Subject: Moving the database to flat file format

Mr. xyz,

I hope you are doing fine.

This memo is regarding moving data from SQL file format to flat file format, to be honest I don't have a good feeling about it. But the best thing we can do is to make a copy of a data and save it for the worst case scenario considering if something goes wrong. A relational database contains number of tables containing data and those tables relate to each other through special key fields. Relational databases are far more flexible (though harder to design and maintain), whereas flat database uses only single table to maintain the relation.

For example if there are two E-commerce companies names as company A and company B and company A uses ralational database format containing two tables named as order and customer and company B uses flat file format containing only one table named as orders which will contain all the information about the order as well as the customer, now suppose the customer want to re order using Company B then what will happen is he needs to fill his details again in which the customer related information like his name address contact number will be repeated again in the table which will create redundancy and lots of memory wastage as well. So my request to you is to please let the file format of database be relational database.

I hope this helps.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.