DBMS

Entity An entity is ‘thing’ or ‘object’ in the real world that is distinguishable from all other objects. Object may be person, place, event etc. Types of Entity Strong Entity: Entities having its own attribute as primary keys are called strong entity. For example, STUDENT has STUDENT_ID as primary key. Hence it is a strong […]

Schema A schema is plan of the database that give the names of the entities and attributes and the relationships among them. A schema includes the definition of the database name, the record type and the components that make up the records. Alternatively it is defined as a framework into which the values of the […]

Data Base Management System Architecture (DBMS) DBMS is program or group of programs that work in conjunction with the operating system to create, process, store, retrieve, control and manage the data.The architecture is a framework for describing database concepts and specifying the structure of database system. DBMS architecture is the way in which the data […]

Data Models Underlying structure of the database is called as data model. It is a collection of conceptual tools for describing data, data relationships, data semantics and consistency constraints. Data models define how data is connected to each other and how they are processed and stored inside the system. Types of data models are: Entity relationship model […]