DBMS

is a software system that is designed to manage and organize data in a structured manner

• Database Management System

• Database

• Data Definition Language

Normal forms ensure that data is consistent and does not contain any redundant information. This helps to prevent inconsistencies and errors in the database.

• Database Maintenance

• Query Performance

• Data Consistency

deals with database schemas and descriptions, of how the data should reside in the database.

• Transactional Control Language

• Data Control Language

• Data Definition Language

Normal forms minimize data redundancy by organizing data into tables that contain only unique data. This reduces the amount of storage space required for the database and makes it easier to manage.

• Query Performance

• Data Redundancy

• Data Consistency

Normal forms make it easier to maintain the database by reducing the amount of redundant data that needs to be updated, deleted, or modified. This helps to improve database management and reduce the risk of errors or inconsistencies.

• database maintenance

• database normalization

• data control language

Normal forms can improve query performance by reducing the number of joins required to retrieve data. This helps to speed up query processing and improve overall system performance.

• Data Redundancy

• Query Performance

• Data consistency

acts as an access specifier to the database.(basically to grant and revoke permissions to users in the database.

• data control language

• data manilpulation languag

• transactional control language

acts as an manager for all types of transactional data

and all transactions.

• transactional control language

• data control language

• data manipulation language

a type of flowchart that illustrates how “entities” such as people, objects or concepts relate to each other within a system.

• entity type

• ER diagram

• entity integrity constraints

are a series of guidelines that help to ensure that the design of a database is efficient, organized, and free from data anomalies.

• data normalization

• Data accuracy

• tuple uniqueness constraints