Extended Entity Relationship Model (EER Diagram)
September 17, 2016The E-R model that is supported with the additional semantic concepts is called the extended entity relationship model. Specialization: It... View Article
Categories for Database Management System
Types of keys in E-R modeling
September 17, 2016Super key: Allows us to identify uniquely an entity in the entity set. Example: Roll_No attribute of student distinguishes student... View Article
Constraints of E-R Modeling
September 17, 2016An E-R enterprise schema may define certain constraints to which the contents of a database system must conform. Mapping Cardinalities... View Article
Data Models
September 17, 2016Entity relationship model Keywords: Entity, Relationship, Attributes Advantages: Easy to develop, Mapping cardinalities, primary key, generalization and specialization Disadvantages: not... View Article
Database Administrator
September 17, 2016A person who has central control over the system is called a Database Administrator (DBA). The functions of DBA include:... View Article
Database Languages
September 17, 2016A database system provides a data definition language to specify the database schema and a data manipulation language to express... View Article
Views of Data
September 17, 2016A major purpose of DBMS is to provide users with an abstract view of the data. There are 3 levels... View Article
Database Management System (DBMS)
September 17, 2016Introduction Database is a collection of data. It contains information about one particular enterprise. DBMS is a set of prewritten... View Article
Join Introduction [MySQL]
September 15, 2016Joins tables Many forms: INNER JOIN (include only matching columns) OUTER JOIN (include all columns) LEFT OUTER JOIN NATURAL JOIN... View Article
NoSQL Performance Tuning
September 13, 2016Source: http://www.slideshare.net/ronwarshawsky/rw-nosql-2013presentatonv1 OS Tuning : Try “tuned” – best when used in staging/load testing environment under realistic load. Storage Tuning... View Article