How many rows will be returned by the following query? SELECT name FROM student WHERE major BETWEEN ‘Data Science’ AND ‘Computer Science’;

Questions 16 to 18: Primary Keys & Normalization Concepts   Question 18 You have a Phone_Numbers column that contains values like “123-456-7890, 987-654-3210”. Under what condition does this violate 1NF?

How many rows will be returned by the following query? SELECT name FROM student WHERE major LIKE ‘%o%’;

Questions 7 to 9: String Functions on Database Rows   Question 9 What will the following command return? SELECT SUBSTRING_INDEX(name, ‘ ‘, -1) AS ‘Last_Name’ FROM student WHERE id = 101;

Questions 10 to 15: Standalone String Functions   Question 12 What will the following command return? SELECT SUBSTRING(‘192.168.1.100’, 5, 3);

Questions 10 to 15: Standalone String Functions   Question 13 What will the following command return? SELECT SUBSTRING(SUBSTRING_INDEX(‘apple-banana-cherry’, ‘-‘, -2), 1, 6);

Questions 19 to 20: Evaluating 1NF Compliance   Question 20 Below is a table description and its data: mysql> DESC projects; +———+————–+——+—–+———+—————-+ | Field | Type | Null | Key | Default | Extra | +———+————–+——+—–+———+—————-+ | id      | int     | NO  | PRI | NULL    | auto_increment | | title  | varchar(50) | YES |   | NULL |   | | members | varchar(100) | YES | | NULL | | +———+————–+——+—–+———+—————-+   mysql> SELECT* FROM projects; +—-+——————+_______________+ | id | title | members | +—-+——————+_______________+ | 1 | Mobile App | Alice, Bob, Charlie | | 2 | AI Chatbot | Diana, Evan | +—-+——————+_______________+ Is the above table in First Normal Form (1NF)?

How many rows will be returned by the following query? SELECT name FROM student WHERE gpa IN (3.5, 4.0);

A story whose events are arranged so that the audience can follow their temporal order is told in [BLANK-1] time.

Part II: Fill in the Blank5 questions • 1 point each • Write the McKee term that best completes each statement.