SecurityArena

Guide to Practical Info Security!

Who's Online

We have 5 guests online
CBK Applications and Systems Development Security (Part-1)
CBK Applications and Systems Development Security (Part-1) - Database Management System Print E-mail
Written by Administrator   
Thursday, 09 July 2009 08:54
Article Index
CBK Applications and Systems Development Security (Part-1)
Functionality vs Security
Database Management System
Database models
Database Interface Languages
Relational Database Components
Normalization
Integrity
Database Security Controls
Data Warehousing and Data Mining
Web Services
System Development
Functional Design Analysis and Planning
System Development Process Models
Verification vs Validation
Separation of Duties in System Development
Configuration management
All Pages
Page 3 of 17

Database Management System (DBMS)

A database management system (DBMS) is a suite of programs used to manage large sets of structured data with ad hoc query capabilities for many types of users. It also enforces access control restrictions, provides data integrity and redundancy, and sets up different procedures for data manipulation.

Types of databases:

  • Hierarchical
  • Mesh
  • Object-oriented
  • Relational

Important Database terms

  • Record: Collection of related data items.
  • File: Collection of record of the same type.
  • Database: Cross-referenced collection of files.
  • DBMS: Manages and controls the database.
  • Base relation: A table stored in a database.
  • Tuple: A row in a database.
  • Attribute: A column in a database.
  • Cell: Intersection of a row and column.
  • Primary key: Columns that make each row unique.
  • Foreign key: An attribute (column) in one relation that has values matching the primary key in another relation.
  • View: Virtual relation defined by the database to control subjects from viewing certain data.
  • Schema: Holds data that describes a database.
  • Data dictionary: Central repository of data element and their relationships.
  • Cardinality: The number of rows in the relation.
  • Degree: The number of columns in the relation.
  • Domain: It is a set of allowable values that an attribute can hold / take.
Last Updated on Friday, 28 August 2009 05:04
 
Please register or login to add your comments to this article.
Banner
Copyright © 2010 Information Security Arena. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.
 
Joomla 1.5 Templates by Joomlashack