Advertisements
Advertisements
Question
Observe the following tables VIDEO and MEMBER carefully and write the name of the RDBMS operation out of (i) SELECTION (ii) PROJECTION (iii) UNION (iv) CARTESIAN PRODUCT, which has been used to produce the output as shown below. Also, find the
Degree and Cardinality of the final result.
TABLE: VlDEO
| VNO | VNAME | TYPE |
| F101 | The Last Battle | Fiction |
| C101 | Angels and Devils | Comedy |
| A102 | Daredevils | Adventure |
TABLE: MEMBER
| MNO | MNAME |
| M101 | Namish Gupta |
| M102 | Sana Sheikh |
| M103 | Lara James |
TABLE: FINAL RESULT
| VNO | VNAME | TYPE | MNO | MNAME |
| F101 | The Last Battle | Fiction | M101 | Namish Gupta |
| F101 | The Last Battle | Fiction | M102 | Sana Sheikh |
| F101 | The Last Battle | Fiction | M103 | Lara James |
| C101 | Angels and Devils | Comedy | M101 | Namish Gupta |
| C101 | Angels and Devils | Comedy | M102 | Sana Sheikh |
| C101 | Angels and Devils | Comedy | M103 | Lara James |
| A102 | Daredevils | Adventure | M101 | Namish Gupta |
| A102 | Daredevils | Adventure | M102 | Sana Sheikh |
| A102 | Daredevils | Adventure | M103 | Lara James |
Solution
CARTESIAN PRODUCT : VIDEO × MEMBER
Degree : 5
Cardinality : 9
APPEARS IN
RELATED QUESTIONS
A collection of ______ is known as a relational database.
Which is the most commonly used data model?
Relations in database are ______.
Columns of a relation are known as ______.
Set of values for which an attribute can take values ______.
The number of tuples in a relation is called ______.
Which of the following rules are not imposed by relational data model on attribute of a relation?
Which of the following is not a rule governed by the relational data model on a tuple?
Give the term for the following:
Software that is used to create, manipulate and maintain a relational database.
| Student Project Database | ||||
| Table: STUDENT | ||||
| Roll No | Name | Class | Section | Registration_ID |
| 11 | Mohan | XI | 1 | IP-101-15 |
| 12 | Sohan | XI | 2 | IP-104-15 |
| 21 | John | XII | 1 | CS-103-14 |
| 22 | Meena | XII | 2 | CS-101-14 |
| 23 | Juhi | XII | 2 | CS-101-10 |
| Table: PROJECT | ||||
| ProjectNo | PName | SubmissionDate | ||
| 101 | Airline Database | 12/01/2018 | ||
| 102 | Library Database | 12/01/2018 | ||
| 103 | Employee Database | 15/01/2018 | ||
| 104 | Student Database | 12/01/2018 | ||
| 105 | Inventory Database | 15/01/2018 | ||
| 106 | Railway Database | 15/01/2018 | ||
| PROJECT ASSIGNED | ||||
| Registration_ID | ProjectNo | |||
| IP-101-15 | 101 | |||
| IP-104-15 | 103 | |||
| CS-103-14 | 102 | |||
| CS-101-14 | 105 | |||
| CS-101-10 | 104 | |||
For the above-given database STUDENT-PROJECT, can we perform the following operation?
Insert a project detail without a submission date.
