CSC3072 Quiz 1

Spring 2013
Herbert J. Bernstein ( )

CSC3072 Quiz 1
Spring 2013

 


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


This is quiz 1 to be taken by Friday, 8 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. What is your gmail address and your Skype ID?

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

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

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

  5. What is a database?

  6. What is a database management system?

  7. What is a DBA?

  8. How do end users interact with a database?

  9. How do applications (not application programmers) interact with databases?

  10. Explain 1-, 2- and 3-tiers database systems.

  11. Why is a DBMS needed?

  12. Explain in detail the ANSI/SPARC arcitecture.

  13. Explain data independence.

  14. Explain in detail what a relation is, giving an example.

  15. What is a key? What is a candidate key? What is a primary key? What is a foreign key?

  16. What is the selction operator? What is the projection operator? What the equijoin (or natural join) operator?

  17. Explain the union, intersection, difference and cartesian product.

  18. According to Date, what is a type, exactly?

  19. What is the URL of your blog?

  20. Give your preliminary project proposal.

  21. Give your portfolio project URL. Give your assigment posting web site.

  22. When is your 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 5 February 2013