SQL & MYSQL
WHAT IS SQL? -Structured Query Language -is a special-purpose programming language designed for managing data held in a relational...
RELATIONAL ALGEBRA
RELATIONAL ALGEBRA -A query language (QL) is a language that allows users to manipulate and retrieve data from a database. -Relational...
NORMALIZATION
WHAT IS NORMALIZATION? -Normalization is a technique of analyzing and correcting table structure for producing a set of suitable ...
MAPPING OF ER DIAGRAM TO RELATIONAL DATABASE SCHEMA
-Before doing this topic, we need to understand ER Diagram. -Relational Database is a collection of NORMALIZED relations with distinct...
CONCEPTUAL MODELLING
-USING ERD (entity relationship diagram) -FOCUS ON CHEN NOTATION ERD -pictorial representation of database structure . -different shapes...
DATABASE ENVIRONMENT
ANTI SPARC ARCHITECTURE -ANSI-SPARC stands for American National Standards Institute, Standards Planning And Requirements Committee. -It...
INTRODUCTION TO DATABASE
INFORMATION APPLICATION SYSTEMS -Hardware -People -Software -Data DATA -Data is distinct pieces of information, usually formatted in a...