Database Management Systems : Role Of Database

1939 Words Apr 18th, 2016 8 Pages
Chapter 5

Topic 1

DATABASE MANAGEMENT SYSTEMS:

ROLE OF DATABASE IN SQL SERVER:

A database management system (DBMS) is a collection of programs that enables you to store, modify, and extract information from a database. There are many different types of database management systems, ranging from small systems that run on personal computers to huge systems that run on mainframes

1) It is a suite of programs for constructing and maintaining the database.

2) Offering ad hoc query facilities to multiple users and applications.

3) A query language provides a uniform interface to the database for users and multiplications.

4) Database systems provide efficient access to large volumes of data and are vital to the operation of many organizations.

It also usually enables access controls to be specified over a wider range of commands, such as to select, insert, update, or delete specified items in the database. Thus, security services and mechanisms are needed that are designed specifically for, and integrated with database systems.

Statements from database management systems generally plays protecting role for the digital assets. In this the operating systems mechanisms typically control read and write access to entire files So they could be used to allow a user to read or to write any information.

TOPIC 2:

PRIMARY KEY AND FOREIGN KEY:

PRIMARY KEY:

A table typically has a column or combination of columns that contain values that uniquely identify each row in the…
Open Document