Line Coding
September 18, 2016Introduction The process of converting digital data to digital signals. Digital data – sequences of bits. Characteristics Data rate vs. signal... View Article
Archives
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
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
Sparse Matrix (Introduction)
September 15, 2016A Sparse Matrix is a special type of matrix in which maximum number of Elements are “Zero Elements” or In... View Article