Database Management Systems

Step 1: Understanding Third Normal Form.
Third Normal Form (3NF) is a property of a relational database that ensures that a database is free of transitive dependencies. A relation is in 3NF if it is in Second Normal Form (2NF) and if no non-prime attribute (an attribute that is not part of any candidate key) is transitively dependent on the primary key.
Step 2: Example of 3NF.
To ensure a database is in 3NF, any non-prime attribute must depend only on the primary key and not on other non-prime attributes. For instance, if a table contains attributes such as Student ID, Student Name, and Department, where Student Name depends on Student ID, but Department depends on Student Name, this would violate 3NF. The table would need to be reorganized.
Step 3: Conclusion.
The main goal of 3NF is to eliminate redundancy and ensure that attributes only depend on the primary key.

Concept: MySQL provides several built-in aggregate functions that perform calculations on a set of values and return a single result. These functions are commonly used in database queries to summarize and analyze data stored in tables. 1. COUNT() Function The COUNT() function is used to count the number of rows or records in a table that satisfy a specified condition. Syntax: Example: This query counts the total number of student records in the \texttt{Student} table. 2. SUM() Function The SUM() function is used to calculate the total sum of numeric values in a column. Syntax: Example: This query calculates the total salary of all employees in the \texttt{Employees} table. 3. MAX() Function The MAX() function is used to find the maximum (largest) value in a column. Syntax: Example: This query returns the highest marks obtained by a student in the \texttt{Student} table.

Concept: In a relational database, keys are attributes or sets of attributes that help uniquely identify records in a table and establish relationships between tables. Keys play an important role in maintaining data integrity and ensuring efficient data retrieval. 1. Primary Key: A Primary Key is a field or a combination of fields that uniquely identifies each record in a table. It ensures that no two rows have the same value for the primary key. Characteristics of Primary Key:

• Each value must be unique.
• It cannot contain NULL values.
• There can be only one primary key in a table.

Example: In a \texttt{Student} table, the \texttt{Student_ID} can act as the primary key because it uniquely identifies each student. 2. Foreign Key: A Foreign Key is a field in one table that refers to the primary key of another table. It is used to establish a relationship between two tables. Characteristics of Foreign Key:

• It maintains referential integrity between tables.
• It can contain duplicate values.
• It may contain NULL values if the relationship is optional.

Example: In an \texttt{Orders} table, the \texttt{Student_ID} field may refer to the \texttt{Student_ID} in the \texttt{Student} table. 3. Candidate Key: A Candidate Key is an attribute or a set of attributes that can uniquely identify a record in a table. A table may have multiple candidate keys. From the set of candidate keys, one key is selected as the primary key. Characteristics of Candidate Key:

• Must uniquely identify each record.
• Cannot contain duplicate values.
• A table may have multiple candidate keys.

Example: In a \texttt{Student} table, both \texttt{Student_ID} and \texttt{Email} could uniquely identify a student. Thus, both are candidate keys, but one of them is chosen as the primary key.

Concept: A Database Management System (DBMS) is software that allows users to create, store, organize, retrieve, and manage data in a structured way. It acts as an interface between the database and users or application programs, ensuring that data is stored efficiently and accessed securely. Definition of DBMS: A DBMS is a collection of programs that enables users to define, create, maintain, and control access to a database. Examples include MySQL, Oracle, Microsoft SQL Server, and PostgreSQL. Advantages of DBMS over Traditional File System: 1. Reduced Data Redundancy In a traditional file system, the same data may be stored in multiple files, leading to duplication. A DBMS minimizes redundancy by storing data in a centralized database. 2. Improved Data Consistency When data is duplicated in different files, inconsistencies may occur. A DBMS ensures that updates are reflected everywhere, maintaining consistent data. 3. Better Data Security A DBMS provides security mechanisms such as authentication, authorization, and access control to protect sensitive data. 4. Data Sharing and Multi-user Access Multiple users can access and modify the database simultaneously in a controlled manner. 5. Data Integrity DBMS enforces rules and constraints that maintain the accuracy and reliability of data. 6. Backup and Recovery DBMS provides mechanisms for data backup and recovery in case of system failure.