Reference no: EM132356163

Environment and Computing Assignment - Data and Information Retrieval

Part 1: Normalisation

1. Explain why the table is not normalized. (attached).

2. Identify and state the functional dependencies in the table.

3. Generate 1NF, 2NF and 3NF normalised relations. - Justify clearly every step - Produce the corresponding tables.

4. Comment critically on the normalisation process.

5. Produce SQL statements to create the 3NF relations (tables), and include SQL insert statements for each of the tables.

SQL statements to create Country table:

SQL statements to create Egency table:

SQL statements to create Equipment table:

SQL statements to create Mission table:

SQL insert statements:

6. Generate the ER diagram corresponding to the table.

Part 2: Database Design

1. The database solution of your choice.

2. Justification for the choice of the database.

NoSQL: Features

3. A detailed explanation of how the data will be stored and accessed in the database you choose.

4. The benefits and drawbacks of this solution in relation to the type of data above and the size of the data set.

5. The quality of service (QoS), such as scalability that should be provided to the user should this solution be adopted.

Part 3: Sequential and parallel processing

Assuming that the data is stored in a relational database produce, with justification, the SQL statement to create the table.

Assuming that the data is too large to be processed in a centralised manner, and that it is stored in an ordinary file, produce a distributed solution which applies MapReduce to the data processing.

a) Justify your decisions and all the steps of your solution, and specify clearly the map and reduce functions.

b) Identify the advantages and drawbacks of this solution.

Assuming that the monitors wish to determine the number of delayed flights for a specific year or month for example, comment on the general applicability of your solution. general applicability for determine the number of delayed flights for a specific year or month are following

1: data structure is properly define for attributes

2: database table is normalised

3: database design will good and professional

4: sql query well good design to insert data in columns month and year

5: not data redeny in exit in table

6: null&empty data is not exit in these columns

Part 4: Big Data and recommendation

a) You should pay particular attention to the rationale, the architecture, the processes, the effectiveness, the implications of recommendation systems and relevant issues within a Big Data context. Your arguments should be supported by specific examples and case studies and should be properly referenced. Use suitable diagrams if required.

b) Produce in your own words a well-structured and adequately referenced report that should be no more than 1000 words.

Attachment:- DATABASE Assignment File.rar