Main

Practice 1

Main.Practice1 History

Show minor edits - Show changes to output

March 30, 2009, at 04:53 PM by 128.213.6.8 -
Changed lines 7-8 from:
Here are some practice questions from the course book. Here are the [[http://www.cs.rpi.edu/~zaki/cs4380/Spring09/uploads/Main/Practice1/practice1.pdf|solutions]].
to:
Here are some practice questions from the course book. Here are the [[http://www.cs.rpi.edu/~zaki/cs4380/Spring09/HW/Practice1|solutions]].
Restore
February 17, 2009, at 09:06 PM by 128.213.6.8 -
Changed lines 7-8 from:
Here are some practice questions from the course book. I'll send solutions later.
to:
Here are some practice questions from the course book. Here are the [[http://www.cs.rpi.edu/~zaki/cs4380/Spring09/uploads/Main/Practice1/practice1.pdf|solutions]].
Changed lines 10-15 from:
* Q2.4.1 e), f), h). Here are the [[http://www.cs.rpi.edu/~zaki/cs4380/Spring09/uploads/Main/Practice1/q2.4.1.pdf|solutions]]

* Q2.4.5: The result of the natural join has only one attribute from each pair of equated attributes. On the other hand, the result of the theta-join has both columns of the attributes and their values are identical.

* Q2.4.7. Here are the [[http://www.cs.rpi.edu/~zaki/cs4380/Spring09/uploads/Main/Practice1/q2.4.7.pdf|solutions]]
to:
* Q2.4.1 e), f), h).
* Q2.4.5
* Q2.4.7
Restore
February 17, 2009, at 07:52 PM by 128.213.6.8 -
Changed lines 10-11 from:
* Q2.4.1 e), f), h). Here are the [[http://www.cs.rpi.edu/~zaki/cs4380/Spring09/uploads/Main/Practice1/q2.4.1|solutions]]
to:
* Q2.4.1 e), f), h). Here are the [[http://www.cs.rpi.edu/~zaki/cs4380/Spring09/uploads/Main/Practice1/q2.4.1.pdf|solutions]]
Changed lines 14-15 from:
* Q2.4.7. Here are the [[http://www.cs.rpi.edu/~zaki/cs4380/Spring09/uploads/Main/Practice1/q2.4.7|solutions]]
to:
* Q2.4.7. Here are the [[http://www.cs.rpi.edu/~zaki/cs4380/Spring09/uploads/Main/Practice1/q2.4.7.pdf|solutions]]
Restore
February 17, 2009, at 07:52 PM by 128.213.6.8 -
Changed lines 10-13 from:
* Q2.4.1 e), f), h)
* Q2.4.5
* Q2.4.7
to:
* Q2.4.1 e), f), h). Here are the [[http://www.cs.rpi.edu/~zaki/cs4380/Spring09/uploads/Main/Practice1/q2.4.1|solutions]]

* Q2.4.5: The result of the natural join has only one attribute from each pair of equated attributes. On the other hand, the result of the theta-join has both columns of the attributes and their values are identical.

* Q2.4.7. Here are the [[http://www.cs.rpi.edu/~zaki/cs4380/Spring09/uploads/Main/Practice1/q2.4.7|solutions]]
Restore
February 15, 2009, at 03:13 PM by 128.213.6.8 -
Changed line 10 from:
* Q2.4.1 e, f, h
to:
* Q2.4.1 e), f), h)
Changed line 21 from:
* Q 3.4.2 b)
to:
* Q3.4.2 b)
Changed line 33 from:
* Q6.1.2 c
to:
* Q6.1.2 c)
Changed line 35 from:
* Q6.2.1 d, e
to:
* Q6.2.1 d), e)
Changed line 38 from:
* Q6.4.6 d, j
to:
* Q6.4.6 d), j)
Restore
February 15, 2009, at 03:12 PM by 128.213.6.8 -
Changed lines 5-8 from:
!! Here are some practice questions.

I'll send solutions later.
to:
!! Practice Questions

Here are some practice questions from the course book. I'll send solutions later.
Restore
February 15, 2009, at 03:11 PM by 128.213.6.8 -
Changed lines 5-6 from:
!! Here are some practice questions. I'll send solutions later.
to:
!! Here are some practice questions.

I'll send solutions later.
Restore
February 15, 2009, at 01:50 PM by 128.213.6.8 -
Changed lines 5-6 from:
!! Here are some practice questions
to:
!! Here are some practice questions. I'll send solutions later.
Added line 36:
* Q6.4.6 d, j
Restore
February 15, 2009, at 01:48 PM by 128.213.6.8 -
Restore
February 15, 2009, at 01:44 PM by 128.213.6.8 -
Restore
February 15, 2009, at 01:22 PM by 128.213.6.8 -
Changed lines 28-36 from:
* Q4.5.1
to:
* Q4.5.1

!!! Chapter 6 (SQL)
* Q6.1.2 c
* Q6.1.5
* Q6.2.1 d, e
* Q6.3.3
* Q6.3.5 a)
* Q6.4.8
Restore
February 15, 2009, at 01:11 PM by 128.213.6.8 -
Added lines 7-11:
!!! Chapter 2 (relational algebra)
* Q2.4.1 e, f, h
* Q2.4.5
* Q2.4.7
Deleted line 12:
Added lines 24-28:

!!! Chapter 4 (ER modeling)
* Q4.1.3
* Q4.3.1 b)
* Q4.5.1
Restore
February 15, 2009, at 12:59 PM by 128.213.6.8 -
Added lines 1-19:
!! Exam I Syllabus

Exam I will cover all the material covered until 13th Feb. If you have questions, bring them to class on 17th, and I'll try to answer them.

!! Here are some practice questions

!!! Chapter 3 (functional dependencies & decompositions)

* Q3.1.3 a) and c)
* Q3.2.2 ii)
* Q3.2.4 b)
* Q3.2.10 b)
* Q3.3.1 e)
* Q3.4.1 b)
* Q 3.4.2 b)
* Q3.5.2
* Q3.6.3 c)
* Q3.7.1 b)
* Q3.7.4 b)
Restore