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

List the drawbacks of relational database system, List the drawbacks of rel...

List the drawbacks of relational database system A) Repetition of data B) Inability to s certain information.

Log, what is the need of a log in dbms

what is the need of a log in dbms

Explain the deferred update, Explain the Deferred Update The deferred ...

Explain the Deferred Update The deferred update methods do not physically update the database on disk till after a transaction reaches its commit point; after that the updates

Type of views-data control, Type of views : Simple views and Difficult ...

Type of views : Simple views and Difficult Views Feature Simple Views Complex Views Number of tables One

advantages of database over file system, Q. Why would you choose a datab...

Q. Why would you choose a database system instead of simply storing data in operating system file? Define at a base concept in details. Sol. Advantages of Database over Fil

Er diatgrams, Ask q“A database will be made to store information about pati...

Ask q“A database will be made to store information about patients in a hospital. On arrival, each patient’s personal details (name, address, and telephone number) are recorded wher

What do you understand by a view, What do you understand by a view? What do...

What do you understand by a view? What does WITH CHECK OPTION clause for a view do? - A view is a virtual table which comprises fields from one or more real tables. - It is

Central database schema, Show a centralised schema to support the operation...

Show a centralised schema to support the operation of the system you have chosen, including in particular: the product catalogue; the outlets and respective stocks; customer record

Give expression in tuple calculus and domain calculus, Consider the subsequ...

Consider the subsequent relation schemes: Project (Project#, Project_name, chief_architect) Employee (Emp#, Empname) Assigned_To (Project#, Emp#) Give expression i

Whenever the limit clause will be used, Whenever the LIMIT clause will be u...

Whenever the LIMIT clause will be used? LIMIT is used for the following kinds of problems: 1) Answering questions about first or last and largest or smallest 2) Splitting

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages