SQL: Aggregate functions
by Aggregate Functions are all about Performing calculations on multiple rows Of a single column of a table And returning a single value. The ISO standard …
Category: Management Notes
Management Notes of Various Universities across india
SQL: Set Operations
SQL supports few Set operations which can be performed on the table data. These are used to get meaningful results from data stored in the …
SQL: Background, Basic Structure
SQL stands for Structured Query Language. It is used for storing and managing data in relational database management system (RDMS). It is a standard language …
ER-Model: Reduction of E-R Schema to Tables
A database that conforms to an E-R database schema can be represented by a collection of tables. For each entity set and for each relationship …
ER-Model: Design of an ER Database Schema
The data which is stored in the database at a particular moment of time is called an instance of the database. The overall design of …
Entity-Relationship (ER) Model, Entities, Attributes, Relationships, Constraints, ER diagrams, Extended features (Generalization, Specialization, Aggregation)
Entity-Relationship (ER) Model: Entities, Attributes, Relationships, Constraints, ER diagrams, Extended features (Generalization, Specialization, Aggregation)
ER-Model: Mapping Constraints
Mapping Constraints A mapping constraint is a data constraint that expresses the number of entities to which another entity can be related via a relationship …
ER-Model: Concepts, Design Issues
The ER model defines the conceptual view of a database. It works around real-world entities and the associations among them. At view level, the ER …
Types of DBMS: Object Relational
An object relational database management system (ORDBMS) is a database management system with that is similar to a relational database, except that it has an …
Types of DBMS: Object Oriented
It takes more than storage of programming language objects. Object DBMS’s increase the semantics of the C++ and Java. Introduction to Object based databases Object …
You must be logged in to post a comment.