CSC3072 Quiz 2Spring 2013

This web page is http://www.bernstein-plus-sons.com/.dowling/CSC3072S13/CSC3072_Quiz_2.html

This is quiz 2 to be taken by Friday, 15 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. Explain in detail the three most important things you learned in the 4th IIT Madras Database Design video.

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

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

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

5. According to Date, what are the three major components of the original realtional model?

6. According to Date, what is entity integrity? Explain in detail.

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

8. According to Date, what is the relational assignment operator and what is the relational algebra? Explain in detail.

9. According to Date, what is the divide operator? Explain in detail with a worked example.

10. According to Date, what in a nutshell distnguishes the model from the implementation? Explain in detail.

11. According to Date, what are the properties of relations? Explain in detail.

12. According to Date, what is a relvar and what is a variable? Explain in detail.

13. Consider what Date wrote on the issue of having a database with suppliers and customers in two different domains and wanting to be able to do a search to find which suppliers are also customers. Dont just repeat what Date says. Think about it and write a detailed essay on how best ot handle such issues.'

14. According to Date, what is first normal form? Explain in detail. Be sure to explain atomicity.

15. According to Date, what is involved in defining a new type? Explain in detail.

16. What is the URL of your blog entries that covers notes on the first 2 assignments?

17. Give the URL of your portfolio project after you have updated the proposal on that site.

18. 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 11 February 2013