CS403 Current Midterm Paper Fall 2013 File 9

by Farhan Karim Shaikh on December 23, 2013 at 5:39pm

1. Define Cartisian Product   2
2. Project Operator statement was given, which is correct and justify.  2
3.
ID Field1   Field2     Field3                  3
1     I            II            III
2    IV           V            IIV
3    .              .              .
4    .              .              .
5    .              .              .
6    .              .              .

Find Cardinality and Degree

4. Two tables of Customer and Product were given, then semi-join to find?    3
5. Cross Reference Matrix to draw from 4 reports and their attributes?     5

6.
1 – Sigma                                   A - Procedural Query Language     5
2 - Table                                     B     - Select Operator
3 - Relational Algebra                C - Project Operator
4 - ∏                                           D - Relational Data Model
5 - Intersection Operator             E- Binary Operation

Paper was overall tough and many new mcqs.