Question

For each part, please provide a concise or exact final answer. No need to justify the answer.


1. Suppose we have a relation assessment(score) that collect records of 100 students taking an assessment in Data Engineering course. Between set model and multi-set model, which model should you use in storing and calculating the scores of this assessment relation?


2. Suppose the relation Beer(brand, price) consists of 100 rows and 20 of those rows have price set to be NULL. What is the number shown in the result of


SELECT COUNT(*) FROM Beer;


Course: Data Management and Analysis
please answer fast

Answer 1

Answer:

For each part, please provide a concise or exact final answer. No need to justify the answer.

1. Suppose we have a relation assessment(score) that collect records of 100 students taking an assessment in Data Engineering course. Between set model and multi-set model, which model should you use in storing and calculating the scores of this assessment relation?

2. Suppose the relation Beer(brand, price) consists of 100 rows and 20 of those rows have price set to be NULL. What is the number shown in the result of

SELECT COUNT(*) FROM Beer;

Course: Data Management and Analysis

please answer fast