Advertisements
Advertisements
Questions
The number of tuples in a relation is called ______.
______ is a number of tuples in a relation.
Options
Attribute
Tuple
Cardinality
Degree
Domain
Solution 1
Number of tuples in a relation is called Cardinality.
Explanation:
Cardinality of the table refers to the quantity of rows or tuples in a relation.
Solution 2
Cardinality is the number of tuples in a relation.
APPEARS IN
RELATED QUESTIONS
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 |
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 ______.
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.
