Database Fundamentals Assessment

A relational model is a method for storing data in files without relationships.

A relational model is a way to structure data in tables with defined relationships between them.

A relational model is a way to visualize data using graphs and charts.

A relational model is a programming language for database management.

SQL is primarily a programming language for web development.

SQL helps in creating graphics and animations.

The purpose of SQL in database management is to facilitate the manipulation and retrieval of data in relational databases.

SQL is used for designing user interfaces.

The main types of SQL commands are DQL, DDL, DML, and DCL.

DQL, DDL, DML, and DFL

DQL, DDL, DML, and DCLT

DQL, DDL, DML, and DCLX

Normalization is the process of organizing data in a database to minimize redundancy and dependency.

Normalization refers to the physical storage of data in a database.

Normalization is a method for encrypting sensitive data in databases.

Normalization is the process of increasing data redundancy.

1NF, 2NF, 3NF, 4NF, 5NF, 7NF

1NF, 2NF, 3NF, BCNF, 4NF, 5NF

1NF, 2NF, 3NF, 4NF, 5NF, 6NF

1NF, 2NF, 3NF, 6NF

To store data in a non-relational format.

To create relationships between different tables.

To uniquely identify each record in a database table.

To improve the performance of database queries.

The process of database design includes requirements gathering, conceptual design, logical design, physical design, implementation, testing, and maintenance.

Data visualization and reporting tools

Data entry and user interface design

Network configuration and security setup

An entity-relationship diagram is a visual representation of entities and their relationships in a database.

A chart that lists all the tables in a database without relationships.

A diagram showing only the physical layout of a database.

A flowchart depicting the process of data entry in a database.

Foreign keys are used to create indexes in a database.

Foreign keys are used to store large binary files in tables.

Foreign keys link tables and enforce referential integrity in relational databases.

Foreign keys are only applicable in NoSQL databases.

Limited data access

Advantages of using a relational database model include data integrity, ease of data retrieval, support for complex queries, normalization, and strong transactional support.

Inability to handle large datasets

High cost of implementation