CSC3072 Quiz 4

Spring 2013
Herbert J. Bernstein ( )

CSC3072 Quiz 4
Spring 2013

 		 

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

This is quiz 4 to be taken by Friday, 1 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 11th IIT Madras Database Design video.

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

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

  4. According to Date, what is the closure proprty and what does it let us do?

  5. According to Date, what three relational operators in addition to relational assignment are not part of the algrebra and why?

  6. According to Date, how does RENAME differ from SQL's ALTER TABLE? Explain in detail.

  7. According to Date, what is the semijoin operator? Explain in detail.

  8. According to Date, which operators are primitive. Explain in detail.

  9. According to Date, are the relational comparisons relational operatots as such? Explain in detail.

  10. Explain the processes of flattening the table and of decomposition and give examples or each one.

  11. Explain the three general categories of data anomalies that may result from redundancies in 1NF

  12. Explain 2NF, give an example and briefly discuss the data anomalies to which it may be subject.

  13. Explain 3NF, give an example and briefly discuss the data anomalies to which it may be subject.

  14. Explain BCNF, give an example and briefly discuss the data anomalies to which it may be subject.

  15. Briefy discuss the preservation of functional dependencies.

  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? 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 28 February 2013