Question

What will be the degree of the table 'Book' with 200 rows having attributes as BookID, author, price and year?

• A. 200
• B. 1
• C. 4
• D. 3

Hint:

Remember:
- Degree = Number of columns/attributes.
- Cardinality = Number of rows/tuples.
Count the column header labels to find the degree!

Answer 1

The Correct Option is C

Step 1: Understanding the Question:
The question asks to find the degree of a relational table named 'Book', which contains 200 rows and contains the following attributes: BookID, author, price, and year.

Step 2: Defining Key Relational Terminology:
- Degree: The total number of columns (attributes) in a table.
- Cardinality: The total number of rows (tuples) in a table.

Step 3: Detailed Explanation:
Let us count the attributes and rows in our table:
- The attributes specified in the question are:
1. BookID
2. author
3. price
4. year
- Counting them, we find there are exactly 4 attributes.
- Therefore, the Degree of the 'Book' table is 4.
- The number of rows in the table is 200.
- Therefore, the Cardinality of the 'Book' table is 200.
- Since the question specifically asks for the degree of the table, the answer is 4.

Step 4: Final Answer:
The degree of the table is equal to the number of its attributes, which is 4.
Hence, option (C) is the correct choice.