Explain the components of database system in details., Database Management System

Assignment Help:

Explain the components of Database System in details.

Related Discussions:- Explain the components of database system in details.

Assigning responsibility for operation, Assigning Responsibility for Operat...

Assigning Responsibility for Operation Many operations might have obvious target objects, but some of these operations could be used at numerous places in an algorithm, by one

Column constraints, Column Constraints: NOT NULL, UNIQUE, CHECK, PRIMARY K...

Column Constraints: NOT NULL, UNIQUE, CHECK, PRIMARY KEY, DEFAULT, REFERENCES, On delete Cascade : Using this key whenever a parent row is removed in a referenced

Explain sorted file with advantages, Explain sorted File with advantages? ...

Explain sorted File with advantages? Sorted file The sort utility shall perform one of the subsequent functions: 1.Sort lines of all the named files together and write the

The maximum no of key fields that can be used in a header, The Maximum no o...

The Maximum no of key fields that can be used in a header is?? 50

Explain the benefit of oom, Explain the benefit of OOM. Main benefits o...

Explain the benefit of OOM. Main benefits of object oriented modeling are development of system become fast, quality of the system get improve. It gives freedom of use of alrea

Describe the grant function and explain security, Describe the GRANT functi...

Describe the GRANT function and explain, how it associates to security. What kind of privileges may be granted? How are they revoked? Ans: Since more than one user can aacce

Primary and foreign key, Primary Key The primary key is the candidate k...

Primary Key The primary key is the candidate key that is selected by the database designer as the principal denotes of identifying entities within an entity set. The left candi

Entity set or entity type, A collection of a same kind of entities is known...

A collection of a same kind of entities is known as an Entity Set or entity type. Example: For the COLLEGE database defines earlier objects of concern are Students, Faculty,

What is known as fudge factor, What is known as fudge factor? The numbe...

What is known as fudge factor? The number of partitions is enhanced by a small value called the fudge factor, which is usually 20 percent of the number of hash partitions compu

Normalization, how to design tables

how to design tables

12/5/2013 4:25:50 AM A complete database system in an organization contains four *components*. a() Hardware: The hardware is a set of physical devices on which a database resides. It consists of one or additional computers, disk drives, CRT terminals, printers, tape drivers, connecting cables and so on. The computers used for processing the data in database may be mainframe, mini computers and personal computers. Mainframe and mini computers have usually been used on a stand-alone basis to support multiple users accessing a ordinary database. Personal computers are regularly used with stand-alone databases controlled and accessed by single user. Disk drivers are the key storage mechanism for databases. Desktop computers, CRT terminals and printers are used for entering and retrieving information from database. The success of database system has been a lot dependent on advances in hardware technology. A very large quantity of main memory and disk storage is necessary to keep and control a huge quantity of data stored in database. b() Software: A database system includes two kinds of software: 1()General Purpose database management software typically known as database management system (DBMS). 2()Application software that uses DBMS facilities to control the database to attain a specific business functions. Application software is normally written by programmers to solve specific company problem. It may be written in languages like COBOL or C or it may be written in a language supplied by DBMS like SQL. Application software utilizes the facilities of DBMS to way in and manipulate data in the database providing reports or documents needed for the information and processing needs of the company. The DBMS is system software alike to an operating system. It provides a lot of services to end users and programmers. DBMS usually provides most of the following services. a.1.) a central data definition and data control facility known as a data dictionary/directory or catalogue. b.2.) Data security and integrity mechanisms. c.3.) Concurrent data access for multiple users. d.4.) User-oriented data query, manipulation and reporting capabilities. e.5.) Programmer-oriented application system development capabilities.

12/5/2013 4:25:50 AM

A complete database system in an organization contains four components.

a() Hardware: The hardware is a set of physical devices on which a database resides. It consists of one or additional computers, disk drives, CRT terminals, printers, tape drivers, connecting cables and so on.

The computers used for processing the data in database may be mainframe, mini computers and personal computers. Mainframe and mini computers have usually been used on a stand-alone basis to support multiple users accessing a ordinary database. Personal computers are regularly used with stand-alone databases controlled and accessed by single user.
Disk drivers are the key storage mechanism for databases. Desktop computers, CRT terminals and printers are used for entering and retrieving information from database.

The success of database system has been a lot dependent on advances in hardware technology. A very large quantity of main memory and disk storage is necessary to keep and control a huge quantity of data stored in database.

b() Software: A database system includes two kinds of software:

1()General Purpose database management software typically known as database management system (DBMS).

2()Application software that uses DBMS facilities to control the database to attain a specific business functions.

Application software is normally written by programmers to solve specific company problem. It may be written in languages like COBOL or C or it may be written in a language supplied by DBMS like SQL. Application software utilizes the facilities of DBMS to way in and manipulate data in the database providing reports or documents needed for the information and processing needs of the company.

The DBMS is system software alike to an operating system. It provides a lot of services to end users and programmers.

DBMS usually provides most of the following services.

a.1.) a central data definition and data control facility known as a data dictionary/directory or catalogue.
b.2.) Data security and integrity mechanisms.
c.3.) Concurrent data access for multiple users.
d.4.) User-oriented data query, manipulation and reporting capabilities.
e.5.) Programmer-oriented application system development capabilities.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages