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.

What are deadlocks, What are deadlocks? How can they be avoided? Ans:...

What are deadlocks? How can they be avoided? Ans: Deadlock considers to a particular condition when two or more processes are every waiting for another to release a resource,

Describe models which define the operations on classes, Describe briefly mo...

Describe briefly models which define the operations on classes. The three models which are used to define operations on classes are as: Object Model = data dictionary + Obje

Explain the structure of well formed formulae, Explain the structure of wel...

Explain the structure of well formed formulae in relational calculus. Ans: a. An atom is a formula b. If P1 is a formula, after that so are ¬P1 and (P1) c. If P1 and P2 a

Express the properties of strings, Express the properties of Strings? ...

Express the properties of Strings? Strings can be case sensitive (or not) which can change the outcome of string operations. You can evaluate whole strings \ just part

Briefly describe the different kinds of users of a dbms, Briefly describe t...

Briefly describe the different kinds of users of a DBMS. Ans: Different sorts of DBMS users are: (a) Software Engineers: These are the people accountable for developing ap

In which format database schema is written, In which format database schema...

In which format database schema is written ? Data base schema is written in the DDL format.

Relational schema., pine vally company

pine vally company

Normalise data to third normal form, A software contract and consultancy fi...

A software contract and consultancy firm maintains details of all the various projects in which its employees are currently involved. These details comprise: Employee Numbe

Compute the closure set, Compute the closure (F+) for the following set of ...

Compute the closure (F+) for the following set of the functional dependencies defined on R(a,b,c,d), where F - {c→ a, ab → d, a → b, d → c}, i.e. what are all of the FDs implied b

Alter table command, ALTER TABLE Command : This command is used for variati...

ALTER TABLE Command : This command is used for variation of existing structure of the table in the given situation: When a new column is to be added to the table structure.

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