Answer: C) Both a and b
Explanation:
The main benefit of normalizing the database as it reduced the redundant data and due the lack of the redundant data, it saves lots of space in the database.
It also improve the update time in the database so it is easy to handle the database security in the system.
It is also has ability to store the dangling tuples so it can easily store all the information of the customer without introduce any inconsistencies in the database system.
Therefore, Option (C) is correct.
The number of records or rows in a table using MySQL can be got by using the COUNT statement.
Explanation:
- To counts all of the rows in a table, whether they contain NULL values or not, use COUNT
- That form of the COUNT() function basically returns the number of rows in a result set returned by a SELECT statement
- The SQL COUNT() function returns the number of rows in a table satisfying the criteria specified in the WHERE clause.
- It sets the number of rows or non NULL column values.
- COUNT() returns 0 if there were no matching rows.
- The SQL COUNT function is an aggregate function that returns the number of rows returned by a query. You can use the COUNT function in the SELECT statement to get the number of employees, the number of employees in each department, the number of employees who hold a specific job, etc.