CSC3072 Quiz 5

Spring 2013
Herbert J. Bernstein ( )

CSC3072 Quiz 5
Spring 2013

 		 

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

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

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

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

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

  5. According to Date, what is the precise definition of functional dependency? Give an example.

  6. According to Date, what is a superkey? Explain in detail.

  7. According to Date, what is BCNF? Explain in detail.

  8. According to Date, what is a non-loss decomposition? Explain in detail.

  9. According to Date, what is 5NF? Explain in detail.

  10. Explain in detail why normalization is good. Be sure to explain in detail problems that arise in denoralized databases.

  11. Summarize the basic security issues for databases.

  12. This is an important question. In order to provide security for another system, you will maintain a database of usernames and passwords. That will then make the security of your database a possible point of failure for the other system if somebody manages to read the table with the usernames and passwords. Do some research and discuss the issue of how best to maintain password security in databases.

  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 3 March 2013