Knowledge in database warehouse

data structures: queues

Queue is a linear data structure where the first element is inserted from one end called REAR and deleted from the other end called as FRONT. ... In a queue, one end is always used to insert data (enqueue) and the other is used to delete data (dequeue), because queue is open at both its ends

Database Architecture - Database System

This PDF Contains basics of Database Architecture in Database Systems.

E-R model with data modeling

This PDF Contains basics of E-R model with data modeling in database systems.

Functional Dependecies and Relational Database normalization

This PDF Contains basics of Functional Dependecies and Relational Database normalization in database systems.

Relational Algebra and Calculas in database systems

This PDF Contains basics of Relational Algebra and Calculas in database systems.

Relational Database with E-R modeling in database systems

This PDF Contains basics of Relational Database with E-R modeling in database systems

Relational Database in Database systems

This PDF Contains basics of Relational Database in database systems.

SQl assertions and View in database systems

This PDF Contains basics of SQl assertions and View in database systems.

SQL schema and Queries in Database systems.

This PDF Contains basics of SQL schema and Queries

Type of database and Its user

This PDF Contains basics of Type of database and Its user

UML modeling in Database System

This PDF Contains basics of UML modeling in Database System

Users of DBMS

A typical DBMS has users with different rights and permissions who use it for different purposes. Some users retrieve data and some back it up. The users of a DBMS can be broadly categorized as follows −Administrators − Administrators maintain the DBMS and are responsible for administrating the database. They are responsible to look after its usage and by whom it should be used. They create access profiles for users and apply limitations to maintain isolation and force security. Administrators also look after DBMS resources like system license, required tools, and other software and hardware related maintenance.Designers − Designers are the group of people who actually work on the designing part of the database. They keep a close watch on what data should be kept and in what format. They identify and design the whole set of entities, relations, constraints, and views.End Users − End users are those who actually reap the benefits of having a DBMS. End users can range from simple viewers who pay attention to the logs or market rates to sophisticated users such as business analysts.