Objectives of database manangement system, Database Management System

Assignment Help:

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.

Related Discussions:- Objectives of database manangement system

multiple-mode locks, Multiple-mode locks : It offers two locks: exclusive ...

Multiple-mode locks : It offers two locks: exclusive locks and shared locks. But why do we require these two locks? There are a lot of transactions in the database system that neve

Data fragmentation in distributed database system, brief history,definition...

brief history,definition,current trends and future trends if any of data fragmentation

Define join and outer join, Define Join and Outer Join and differentiate be...

Define Join and Outer Join and differentiate between them. Ans: Join - It generates all the combinations of tuples from two relations which satisfy a join condition. Oute

Explain the form of the create view command, We define a view in SQL throug...

We define a view in SQL through using the create view command. To describe a view, we must provide the view a name and must state the query in which computers the view. The form of

Which operations need the participating relations to union, Which operation...

Which operations need the participating relations to be union compatible? A UNION, INTERSECTION and DIFFERENCE operations need the participating relations to be union compatibl

Views, what is view?explain

what is view?explain

Explain the two types of participation constraint, Explain the two types of...

Explain the two types of participation constraint. Total: The participation of an entity set E in a relationship set R is said to be total if each entity in E participates i

Construct substantial data model, PART MARKING: We will only mark TWO of t...

PART MARKING: We will only mark TWO of the four questions below but you must submit answers to all four. We will choose the questions we mark randomly and we will supply you with

Describe the responsibilities of the dba and the database, Describe the res...

Describe the responsibilities of the DBA and the database designer ? The responsibilities of DBA and database designer are: 1. Planning for the database's future storage needs

Explain query tree represent relational algebra expression, How does a quer...

How does a query tree represent a relational algebra expression? Ans: This includes transforming an initial expression (tree) into an equivalent expression (tree) that is

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages