give a simple example of physical and logical data
independence



give a simple example of physical and logical data independence..

Answer / Subhash Chandra Gupta

Physical data independence refers to the ability to manipulate the structure of a database without affecting the application that uses it. Logical data independence refers to the ability to modify the meaning of data without changing its representation in the database. A simple example would be a table 'Students' with columns 'Name', 'Age', and 'Grade'. Physically, the data may be stored in multiple files, but logically, it is viewed as a single table by the application. If a new column 'Email' is added or removed physically, it does not affect the application's view of the table, ensuring physical data independence. Similarly, if a decision is made to change the way grades are represented (e.g., numeric grades instead of letter grades), the structure of the database may need to be updated, but this should not affect how the 'Students' table appears to the application, ensuring logical data independence.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Databases AllOther Interview Questions

how to configure oracle 10g in java1.5 and tell me know how to set class path in system?

1 Answers  


How does database replication work?

1 Answers  


please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks

1 Answers  


What is ole db source in ssis?

1 Answers  


wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..

1 Answers  


WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?

2 Answers   HP,


How do I manually create a database?

1 Answers  


Display the employees whose salary is less than average salary.

1 Answers   Amazon,


What is the default identifier of structure in C?

3 Answers   CybAge,


Can we have a function Overloading with same number of arguments but with different return types of function

8 Answers   CybAge, Wipro,


What is the difference between primary and candidate key?

1 Answers   BirlaSoft,


how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.

1 Answers  


Categories