CSC3072 Final

Spring 2013
Herbert J. Bernstein ( )

CSC3072 Final
Spring 2013


This web page is
Copyright © 2011, 2012, 2013 Herbert J. Bernstein and other parties. All rights reserved.

This is the Final to be taken under Skype supervision on Tuesday, 7 May 2013 and completed no later than by 11 pm. It should take you between 1 and 3 hours to answer the following questions, if you have kept up with the work for the course to this point, much longer, if not. It is an open book, open notes, open computer exam.

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

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

Please fill in the following information:



Skype ID:

Grades must be submitted shortly after this final is given. If you have not finished enough of the work for this course to earn at least a C-, you will be given an incomplete. Some people may prefer an incomplete to having a C- recorded. If you are unconditionally requesting an incomplete, say so here:

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

  1. Give the URL in your blog where you have detailed notes on all of the IIT Madras Database Design videos. This question is worth 1/6th of your grade on this final. The grade depends on how clearly and thoroughly you have taken those notes.

  2. Give the URL of your portfolio project, which should now be complete. Be certain that the posting includes a clear statement of what parts of this project are your own original creative effort and clearly identifies the sources for the parts that are not. Be sure your project explains the layout (the schema) of your database and discusses the normalizations done. This question is worth 1/6th of your grade on this final.

  3. Summarize Date's Database Principles, writing a short general paragraph about each one, and then a paragraph explaining how and why that particular principle does or does not apply to your project.

  4. Carefully and in detail, explain the process of normalization of a relational database. Be sure to define and explain each of the normal forms through BCNF.

  5. Carefully and in detail, explain the considerations in the design of a distributed database system that must support high performance transaction processing for simultaneous multiple readers and writers while maintaining the integrity and security of the database. Be sure to explcitly cite the sources you use for what you say. For places in which you use the IIT Madras lectures as a source, be sure to cite the particular lecture and what specifically it was that was said in that lecture that you are using to support your position. For places in which you use a text or a web site to support your position, be sure to cite the specific text page and words that support your position. If you do a good, scholarly job on this question in writing and can discuss it coherently with the instructor over Skype or Google Talk during the schedule finals period, you will get no worse than a B in the course.

  6. Carefully and in detail, expain relational algebra, the relational assignment and each of the major relational operators.

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

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

Revised 5 May 2013