CSC3072 Quiz 6

Spring 2013
Herbert J. Bernstein ( )

CSC3072 Quiz 6
Spring 2013

 		 

This web page is http://www.bernstein-plus-sons.com/.dowling/CSC3072S13/CSC3072_Quiz_6.html
Copyright © 2011, 2012, 2013 Herbert J. Bernstein and other parties. All rights reserved.

This is quiz 6 to be taken by Friday, 22 March 2013. It should take you between half an hour and 2 hours to answer the following questions. You should be sure to do all the rest of the assignment before doing the quiz.

  <==== Do this AFTER you've answered all the questions

You probably DON'T want to do this ===>  

Please fill in the following information:

Name:


Email:

Skype ID:

Please answer the following questions on this form (or on a paper copy of this form).


  1. Explain in detail the three most important things you learned in the 18th IIT Madras Database Design video.

  2. Explain in detail the three most important things you learned in the 19th IIT Madras Database Design video.

  3. Explain in detail the three most important things you learned in the 20th IIT Madras Database Design video.

  4. Explain in detail the three most important things you learned in the 21st IIT Madras Database Design video.

  5. According to Date, what are the five components of the relational model?

  6. According to Date, what is the only required system-defined scalar type?

  7. According to Date, SQL violates the Assigment Principle. Discuss with examples.

  8. According to Date, the only kind of variable permitted in a relational database is the relvar. Discuss with examples.

  9. According to Date, what are uses for the relational algebra?

  10. Summarize Date's Database Principles.

  11. For credit worth 1 full quiz extra credit, discuss in detail the relational model versus other proposed database models.

  12. For credit worth 1 full quiz of extra credit, discuss in detail the use of SQL to access the database for your project with SQL code fragment examples to illustrate your discussion.

  13. Give the URL of your portfolio project after you have updated the proposal on that site for the current assignment.

  14. When is your next scheduled Skype or face-to-face meeting with the instructor? If you have been ducking those meetings, explain why.

  <==== Do this AFTER you''ve answered all the questions

You probably DON'T want to do this ===>  

Revised 21 March 2013