Head of Department and Lecturer Interview Questions and Answers

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

• Normalization helps to eliminate data redundancy and inconsistencies.

• It involves breaking down a table into smaller tables and defining relationships between them.

• Normalization is usually done in a series of steps called normal forms, with each step addressing a specific type of data redundancy.

• The most commonly used normal forms are first normal form (1NF), second normal form (2...read more

A database is a structured collection of data that can be accessed, managed, and updated.

• A database is used to store and organize data.

• It can be accessed and manipulated using queries.

• Examples include MySQL, Oracle, and MongoDB.

• Data can be stored in tables, documents, or key-value pairs.

• Indexes can be created to improve performance.

• ACID properties ensure data consistency and integrity.