If you need to store the following data in a relational database and MongoDB, how would you implement in each of them. List the design and queries to store these records in relational database and MongoDB separately. (Queries: using SQL in Relational database, MongoDB NoSQL syntax for MongoDB)

{no:1,name:"ST",salary:2000,role:"OB"},

{no:2,name:"MSD",salary:1500,role:"WK"},

{no:3,name:"YS",salary:1000,role:"ALR"},

6. Answer the following questions:

a. What are the major differences between MongoDB and relational databases?

b. What type of situation using MongoDB is better than relational databases? Why? Provide example to support your opinion.

c. What type of situation using relational databases is better? Why? Provide example to support your opinion.

pur-new-sol

Related Questions