What is a database?

A structured collection of data that is designed to be easily accessed, managed, and updated

A Flat file of collection of data that is designed to be accessed, managed, and updated

A Table of symbols that can be accessed, managed, and updated

Raw data designed to be accessed, managed, and updated

Question $2$

$1$

Point

Which of the following is NOT an Enterprise DBMS$?$

MS SQL Server

MS Access

IBM DB$2$

Oracle

Question $3$

$1$

Point

Given the following SQL code snippet:

SELECT $*$ FROM Customers

WHERE Country$=$'USA';

Which statement represents the ENTITY or Table in the above

WHERE

SELECT

CUSTOMERS

FROM

Question $4$

$1$

Point

Given the following SQL code snippet:

SELECT $*$ FROM Customers

WHERE Country$=$'USA';

What is the result of the output?

Question $5$

$10$

Points

Why is normalization important?

Question $6$

$10$

Points

List and briefly explain $4$ benefits of a database system.

Question $7$

$1$

Point

Briefly state the importance of an ER diagram and statement the main components that they should have.

Question $8$

$1$

Point

State a USE CASE of your Choice in which you can depict the benefit of a database management system. Please state which Enterprise Database Management System was used or should be used in the scenario presented