Homework2 - Database Management Systems (COP 5725) (Spring...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Database Management Systems (COP 5725) (Spring 2012) Instructor: Dr. Markus Schneider TA: Nam Nguyen Homework 2 Name UFID Email Address Pledge (Must be signed according to UF Honor Code) On my honor, I have neither given nor received unauthorized aid in doing this assignment. ______________________________________________ Signature For scoring use only: Maximum Received Exercise 1 20 Exercise 2 30 Exercise 3 30 Exercise 4 20 Total 100
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Exercise 1 (Knowledge Questions) [20pts] Answer the following questions: 1. State and define the basic operations in Relational Algebra [4pts] 2. What is Tuple Relational Calculus? How are queries expressed in Tuple Relational Calculus? [4pts] 3. What is Domain Relational Calculus? How are queries expressed in Domain Relational Calculus? [4pts] 4. What is a 1: m relationship set R between two entity sets E1 and E2? [4pts] 5. Explain the various Join operations in Relational Algebra [4pts]
Background image of page 2
Exercise 2 (Relational Algebra) [30pts] Consider the following schema:
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/14/2012 for the course COP 5725 taught by Professor Staff during the Spring '08 term at University of Florida.

Page1 / 5

Homework2 - Database Management Systems (COP 5725) (Spring...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online