Normalisation
EMUI Themes
00:50:00
0
Normalization is a method to remove all these anomalies and bring the database to a consistent state. · First Normal ...
Read More
Post Top Ad
Showing posts with label DBMS. Show all posts
Showing posts with label DBMS. Show all posts
Codd's Rule
EMUI Themes
00:44:00
0
The Codd's are as follows Rule zero Rule 1 : Information rule Rule 2 : Guaranted Access Rule 3 : Systemetic treatment of ...
Read More
Key
EMUI Themes
23:28:00
0
A key is a field that you use to sort data . Following are the different types of keys. 1. Candidate key. A candidat...
Read More
RDBMS
EMUI Themes
23:31:00
0
A relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database. The le...
Read More
Generalization Specialization and Aggregation in DBMS
EMUI Themes
22:03:00
0
Generalization Specialization and Aggregation in DBMS are abstraction mechanisms used to model information. Generalization in DBMS...
Read More
ER Diagram
EMUI Themes
23:57:00
0
ER Model is represented by means of an ER diagram. The ER model defines the conceptual view of a database. It works around real-world ...
Read More
Database Languages
EMUI Themes
01:19:00
0
Database languages are special-purpose languages, which do one or more of the following: · Data definition language – defin...
Read More
Types of DBMS
EMUI Themes
02:38:00
0
Relational D atabase : A DBMS is said to be a relational DBMS or RDBMS if the database relationships are treated in the for...
Read More
Three Views & Schemes of DBMS
EMUI Themes
07:57:00
0
Database Schema A database schema is the skeleton structure that represents the logical view of the entire database. A database ...
Read More
DBMS Data Models
EMUI Themes
02:29:00
0
A database model shows the logical structure of a database, including the relationships and constraints that determine how data can be ...
Read More
DBMS vs Files
EMUI Themes
21:35:00
0
DBMS (Database Management System) and File System are two ways that could be used to manage, store, retrieve and manipulate data. A Fil...
Read More
Database Management System
EMUI Themes
01:45:00
0
A database management system ( DBMS ) is a computer software application that interacts with the user, other applications, and the data...
Read More
