Answer the following A) Explain one difference between Key/V…

Answer the following A) Explain one difference between Key/Value stores and relational databases in terms of schema B) Explain one difference between Key/Value stores and relational databases in terms of queries C) Give an example (application) where a key/value store would be an appropriate solution, and justify why key/value store is ideal for this example. D) Show a sample key/value pair E) Describe a sample query that you would run on this key/value store (pseudo code is acceptable)

  Attribute DataType Description StudentID Number ID of…

  Attribute DataType Description StudentID Number ID of the university student LName String Last Name DateOfBirth Date Date of birth HomeZip Number 5 digit Zip code of Home address CuGPA Number Current GPA at the university Consider the above StudentInfo table, which stores student information. The Primary Key of this table is (StudentID). All attributes will have values (in other words, none of the attributes can have NULL). Update the query below to return the student count by letter grade using the grade scale below A 4.0 A- 3.667 B 3.0 B- 2.667 C Below 2.667 For example, a student with a 3.8 GPA should have an A-. SELECT Count(StudentID) as StuCount FROM StudentInfo;