CSC3072 Midterm

Spring 2013
Herbert J. Bernstein ( )

CSC3072 Midterm
Spring 2013


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

This is the Midterm to be taken by 9 am on Monday, 18 March 2013. 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:

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 first 17 IIT Madras Database Design videos. This question is worth 1/6th of your grade on this midterm. The grade depends on how clearly and thoroughly you have taken those notes.

  2. Give the URL of your portfolio project, which should explain the project in detail and which should include a solid BCNF organization of the necessary relations. 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. This question is worth 1/6th of your grade on this midterm.

  3. Carefully and in detail, explain what a relational database is, why relational databases are needed, and how users use relational databases.

  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 basic security issues for databases, and discuss how best to maintain password security in databases. Be sure to cite your specific sources for anything you say.

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

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

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

Revised 11 March 2013