Answer to Question #171179 in Databases | SQL | Oracle | MS Access for lee nakana

Question

Question 2

Types of Databases (Marks: 10) After carefully studying the infographic, Dineo now needs to choose whether to use a relational database or a NoSQL database. She says that she needs to store the following information:

• For each launch, she needs to know who built the vehicle, where it was launched from and when. For crewed missions, she needs to know who the astronauts were that were on board.

• Each launch also has multimedia that should be included – a text description, photos, maybe even videos. Explain to her which type of database (relational or NoSQL) you would recommend, and why, for each of the following types of data.

Q.2.1 Launch data. (5)

Q.2.2 Multimedia related to the launch. (5)

Answer 1

1. For launch data she will use a relational database because of pre defined relationship between the builder of the vehicle and when it was launched and where; this is because all these data can be linked to one another and presented on a table. This will enable her to retrieve an entirely new table with a single query as the data can be linked to each other.

2. For multimedia related to the launch a NoSQL DB will be used since no relationships need to be expressed and the data is highly dynamic and frequently changes ; due to their high-performance and non-relational data stores. They are easy to use, scalable, resilient and availabile,Instead of joining tables of normalized data, NoSQL stores unstructured or semi-structured data, often in key-value pairs or JSON documents. Since multimedia has high volume workloads involving text descriptions, photos that require large scale a NoSQL will be most suitable to store them.