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.

Rules of data normalisation, Rules Of Data Normalisation Let us now su...

Rules Of Data Normalisation Let us now summarise Normalisation with the help of various clean rules. The following are the necessary rules for the Normalisation process: 1.

Compare wait-die deadlock prevention with wait-wound scheme, Compare wait-d...

Compare wait-die deadlock prevention scheme with wait-wound scheme Ans: Wait-Die Scheme a) Based upon a nonpreemptive technique. b) If Pi requests a resource present

Key constraint - relational constraints, This constraint shows that the key...

This constraint shows that the key attribute value in each tuple must be unique, i.e., no two tuples have the similar value for the key attribute. This is because the value of the

Relational database, Convert the following ER - diagram (Entity Relationsh...

Convert the following ER - diagram (Entity Relationship Diagram) into a relational database (the primary keys are underlined): 2160_Convert the following ER - diagram into a

Functional dependencies, 1. Staff (staffID --> availabilityID) 2. Servic...

1. Staff (staffID --> availabilityID) 2. Services (servicesID --> itemBasedID --> timedBasedID) 3. TimedBased (timedbasedID--> priceid) 4. Clients (clientId, serviceId-->

Explain the uses of deadlock, Explain the uses of deadlock It will lea...

Explain the uses of deadlock It will lead to deadlock since this is the only place where incoming acknowledgements are processed. Without this code, sender will keep timing ou

What are the ways of obtaining the connection parameters, What are the ways...

What are the ways of obtaining the connection parameters? Hardwire the parameters into the program. Ask for the parameters interactively. Get the parameters

Define cardinality and participation constraints, Define cardinality and pa...

Define cardinality and participation constraints on a relationship type, completeness constraint on generalization. Ans: Cardinality defines the number of entities to wh

What are the parts of sql language, What are the parts of SQL language? ...

What are the parts of SQL language? The SQL language has various parts: data - definitition language Data manipulation language View definition Transaction contr

What is called mirroring, What is called mirroring? The simplest approa...

What is called mirroring? The simplest approach to introducing redundancy is to duplicate each disk. This method is called mirroring or shadowing.

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