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

Describe the composite key, Describe the Composite Key Composite Key: ...

Describe the Composite Key Composite Key: Sometimes one key is not enough to uniquely recognize a row. E.g. in a single class Roll is enough to search a student, but in the w

Variable length record, what are the reasons having variable length records...

what are the reasons having variable length records

Describe how you can simplify operations, Describe how you can simplify Ope...

Describe how you can simplify Operations. To simplify operation, one should use inheritance, where possible to use, to reduce the quantity of distinct operations. Introduce new

What is known as a search key, What is known as a search key? An attrib...

What is known as a search key? An attribute or set of attributes used to look up records in a file is known as a search key.

What was the method in which records are physically stored, What was the me...

What was the method in which records are physically stored in a specified order according to a key field in each record ? A method in which records are physically stored within

What is substitutability, What is substitutability? Any method of a cla...

What is substitutability? Any method of a class-say A can equally well be adjured with any object belonging to any subclasses B of A. This characteristic leads to code reuse, a

Participation constraints, explain participation constraints with examples

explain participation constraints with examples

Define direct file organization, Define Direct file organization? The d...

Define Direct file organization? The direct file organization is employed to enhance the performance in accessing the records than sequential file organization. In direct file

User error-database errors, User error : This contains errors in the progr...

User error : This contains errors in the program (e.g., Logical errors) with errors made by online users of database. These types of errors can be avoided by applying some check

Prepare an erd for the scenario, Question: (a) Prepare an ERD for the s...

Question: (a) Prepare an ERD for the scenario given below. (b) Convert the ER diagram produced in (a) above into its physical design. You have to choose an appropriate Pri

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages