Objectives of database manangement system, Database Management System

OBJECTIVES

After going through this unit you should be capable to:

  • Explain the File Based system and its limitations;
  • Explain the structure of DBMS;
  • Explain the functions of DBA;
  • Describe the three-tier architecture of DBMS, and
  • Recognize the need for three-tier architecture.

 

Posted Date: 3/5/2013 4:25:18 AM | Location : United States







Related Discussions:- Objectives of database manangement system, Assignment Help, Ask Question on Objectives of database manangement system, Get Answer, Expert's Help, Objectives of database manangement system Discussions

Write discussion on Objectives of database manangement system
Your posts are moderated
Related Questions
Create table employee and enter employee data in SQL? Consider the following relational schemas: EMPLOYEE (EMPLOYEE_NAME, STREET, CITY) WORKS (EMPLOYEE_NAME, COMPANYNAME, SAL

Security: Data not needed by local applications is not stored at the site, therefore no unnecessary security violations may exist. But how can we carry out fragmentation? Fragm

What is meant by data-transfer rate? The data-transfer rate is the rate at which data can be retrieved from or kept to the disk.

let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation

Define the phases of two phase locking protocol Growing phase: a transaction may get locks but not release any lock. Shrinking phase: a transaction might be release locks bu

Demonstrate the Design of associations During object design phase we must design a strategy to implement associations. Association may be unidirectional or bi-directional. Wha

Define Deadlock prevention These protocols make sure that the system will never enter a deadlock state. There are two methods to deadlock prevention. One approach makes sure t

Define an abstraction by which relationships are treated as higher level entities Ans: Aggregation.  It is an abstraction by which relationships are treated as higher level


Heap files (unordered file) Mostly these files are unordered files. It is the easiest and most basic type. These files having of randomly ordered records. The records will have