Describe physical data independence, Database Management System

Assignment Help:

Describe Physical Data independence ?

Physical Data Independence - It is capacity to modify the internal schema without having to change conceptual schema. Therefore, the external schemas required not be changed as well. Changes to the internal schema might be required because some physical files had to be reorganized to improve the performance of retrieval or update. If the similar data as before remains in the database, the conceptual schema requires not be changed.

Related Discussions:- Describe physical data independence

How to operate database in access, how to operate database in access ?

how to operate database in access ?

Reasons for the growing popularity of data mining, Question: Data Minin...

Question: Data Mining is the process of extracting knowledge hidden from large volumes of raw data. (a) Using a suitable example, illustrate how Data Mining can be useful t

Define the phases of two phase locking protocol, Define the phases of two p...

Define the phases of two phase locking protocol Growing phase: a transaction may get locks but not release any lock. Shrinking phase: a transaction might be release locks bu

Management information system, management information system based on funct...

management information system based on functional organisation

Discuss the different layers of ansi sparc architecture, Q.1 Briefly discus...

Q.1 Briefly discuss the different layers of ANSI SPARC architecture. Ans: The three layers of ANSI SPARC architecture are like this: 1. Internal view is at the lowest leve

Relational algebra, Consider the relation schemas as follows. works (per...

Consider the relation schemas as follows. works (person name, company name, salary); lives (person name, street, city); located in(company name, city); managers (person name

Explain the integrity constraints, Explain the integrity constraints: Not N...

Explain the integrity constraints: Not Null, Unique, Primary Key with an example each. Is the combination 'Not Null, Primary Key' a valid combination. Justify. Not Null - Shou

Define 2nf normal form, 2NF Normal Form : A relation schema process R i...

2NF Normal Form : A relation schema process R is in 2NF if it is in 1NF and each non-prime attribute A in R is fully functionally related on primary key. Second normal form (2N

Update opreation, notes about update opreation

notes about update opreation

Describe drop table command or cascade of sql, Describe DROP TABLE command ...

Describe DROP TABLE command of SQL along with both the options - CASCADE and RESTRICT. DROP TABLE command - This command drops the specified table. Dropping a table also dro

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages