Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

versities (with attributes Name, Create an example with instances of students in

ID: 3581730 • Letter: V

Question

versities (with attributes Name, Create an example with instances of students in two different phone) Your most universities. frequen ail address of an that ask for the number and the owing in a individual given phone would store the database name. Show how Amns together Email, for the following decide to keep multip in a column-oriented database you can [2 pts] if needed.) a) How do NoSQL database scale to handle What is the erence extremely large datasets? example. between sharding and replication? in with a clear, simple Why is journaling used in MongoDB? 1 pt] Compare the pros and the cons of having the ACID properties versus the B erties. pts] what circumstances while doing a write would using "One" consistency Under sandra result in less data loss than when you use "Any" consistency. That is, sl situation when "Any" results in data loss but "One" does not. 1 ptsl What is consistent hashing? Where is it used? [1 pt] data

Explanation / Answer

1. ACID stands for Atomicity, Consistency, Isolation and Durability. and these properties make the database to run without errors.
BASE stands for basically available, soft state, eventually consistent.
2. ACID properties are used for RDBMS and BASE properties for NOSQL databases.
3. RDBMS data integrity is maintained but not scalable.NOSQL maintains scalability.
4. In RDBMS has Authentication mechanism where as No SQL doesn't have this mechanism,but can use external methods for this mechanism.
5.Confidentiality is achieved in RDBM,but not in NOSQL,because the data stored is huge and clear