Main

Practice 1

Main.Practice1 History

Hide minor edits - Show changes to markup

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 solutions.

to:

Here are some practice questions from the course book. Here are the 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 solutions.

Changed lines 10-15 from:
  • Q2.4.1 e), f), h). Here are the 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 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 solutions
to:
  • Q2.4.1 e), f), h). Here are the solutions
Changed lines 14-15 from:
  • Q2.4.7. Here are the solutions
to:
  • Q2.4.7. Here are the 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 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 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