The need for three level architecture, Database Management System

Assignment Help:

The need for three level architecture

The aim of the three level architecture is to divide each user's view of the database from the way the database is physically shown.

Support of multiple user views: Every user is able to access the similar data, but have a different customized view of the data. Every user should be able to change the way he or she analysis the data and this change should not affect other users.

Insulation between user programs and data that does not concern them: Users should not directly govern with physical storage details, such as hashing or indexing. The user's interactions with the database have to be independent of storage considerations.

Related Discussions:- The need for three level architecture

In case of entity integrity the primary key may be declared, In case of ent...

In case of entity integrity, the primary key may be declared? In a case of entity integrity primary key may be not Null.

Describe the types of attributes, Describe the types of attributes? Ty...

Describe the types of attributes? Types of attributes: An attribute's category determines the type of values that are permitted in the attribute. For instance, the value vers

What are the categories of sql command, What are the categories of SQL comm...

What are the categories of SQL command? SQL commands are separated in to the following categories: 1. Data - Definitition Language 2. Data Manipulation language 3. Dat

Inheritance, what is relationship inheritance and attribute inheritance

what is relationship inheritance and attribute inheritance

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

Define first normal form and second normal form, First Normal Form and seco...

First Normal Form and second normal form First Normal Form (1NF) A relation is said to be in 1NF if it having no non-atomic values and each row can give a unique combinat

Hello, Java program for horrizontal fragmentation in distributed database

Java program for horrizontal fragmentation in distributed database

Case snerio, each publisher has uniqe name a mial addrs are also kept on ea...

each publisher has uniqe name a mial addrs are also kept on each pubisher.a publisher publish one book.a book publish y one publisher.book identified by isbn.each book writn by one

Boyce-codd normal form (bcnf), Boyce-Codd Normal Form (BCNF) The relati...

Boyce-Codd Normal Form (BCNF) The relation NEWSTUDENT (Enrolmentno, Sno, Sname, Cname, Cno,) has every attributes participating in candidate keys as all the attributes are assu

How the one-to-one associations have to be implemented, Discuss how the one...

Discuss how the one-to-one associations have to be implemented. Some of properties of associations can be implemented directly by providing suitable declarations of the data me

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages