Insulation between conceptual and physical structures, Database Management System

Assignment Help:

Insulation between conceptual and physical structures

It can be defined as:

1. The Database Administrator should be capable to vary the storage structures without affecting users' views.

2. The internal structure of the database should be unaffected by the varies to the physical aspects of the storage, like changing to a new storage device.

3. The DBA should be able to vary the conceptual structure of the database without affecting all users.

Related Discussions:- Insulation between conceptual and physical structures

Define the terms entity set and relationship set, Define the terms i) Entit...

Define the terms i) Entity set ii) Relationship set Entity set: The set of all entities of the similar type is termed as an entity set. Relationship set: The set of all rela

Employees and projects scenario, how many hourse have been spent on a certa...

how many hourse have been spent on a certain project

Give an example of operations from the state actions, Give an example of op...

Give an example of operations from the State Actions and Activities. For instance, in bank the activity verify account code and verify password

Increased parallelism-data replication, Increased parallelism : Since the r...

Increased parallelism : Since the replicated date has several copies a query can be distributed or can be answered from the smallest loaded site. Also, with more replicas you have

Fragmentation, let us consider a table having 2200 records and the fixed si...

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

Max. no. of structures in a table or structure, What is the max. no. Of str...

What is the max. no. Of structures that can be included in a table or structure. Nine.

Sql queries, find a name whose address is erode from student table

find a name whose address is erode from student table

Can a filed occur in several field groups, Can a filed occur in several fie...

Can a filed occur in several field groups. Yes. But it leads to redundant data redundancy.

Create a er diagram to show customer accounts, Information about a bank is ...

Information about a bank is about customers and their account. Customer has a name, address that consists of house number, area and city, and one or more phone numbers. Account ha

Extended e-r features, Although, the essential features of E-R diagrams are...

Although, the essential features of E-R diagrams are enough to design many database situations. Though, with more difficult relations and advanced database applications, it is need

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages