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 |
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
How does database replication work?
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
What is ole db source in ssis?
wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..
WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?
How do I manually create a database?
Display the employees whose salary is less than average salary.
What is the default identifier of structure in C?
Can we have a function Overloading with same number of arguments but with different return types of function
What is the difference between primary and candidate key?
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)