CSC3072 Quiz 3

Spring 2013
Herbert J. Bernstein ( )

CSC3072 Quiz 3
Spring 2013

 		 

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

This is quiz 3 to be taken by Friday, 22 February 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 8th IIT Madras Database Design video.

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

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

  4. According to Date, exactly what is a tuple

  5. According to Date, what is it that SQL supports instead of tuples?

  6. According to Date, what are some important consequences of the formal definition of a tuple? Explain in detail.

  7. According to Date, what is the definition of a relation?

  8. According to Date, what are further impotant consequences of the defintions in Chapter 3. Write a short paragraph on each consequence.

  9. According to Date, what is a powerful argument for prohibiting duplicate tuples. Explain in detail.

  10. According to Date, what is TABLE_DEE?

  11. According to Date, what does talk about updating some individual tuple really mean?

  12. According to Date, what is the precise definition of a candidate key? Explain in detail

  13. According to Date, what is the precise definition of a foreign key? Explain in detail

  14. According to Date, what is the priciple of interchangeability? Explain in detail

  15. Consider what Date wrote on the issues of not using nulls. Carefully consider what you should do in populating a database for which you do not yet have some of the data yet if you are not to use nulls for the data you dont have yet? What should you do?'

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

  17. When is your next scheduled Skype or face-to-face meeting with the instructor?

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

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

Revised 21 February 2013