Data Independence it s types

0 votes
Hi!!

Can someone tell me what exactly is data independence and its various types?
Aug 30, 2018 in Database by Sahiti
• 6,370 points
5,423 views

1 answer to this question.

0 votes

Data Independence refers to the ability to modify the schema definition in one level in such a way that it does not affect the schema definition in the next higher level.

The types of Data Independence are:

  • Physical Data Independence: It modifies the schema at the physical level without affecting the schema at the conceptual level.
  • Logical Data Independence: It modifies the schema at the conceptual level without affecting or causing changes in the schema at the view level.
answered Aug 30, 2018 by CodingByHeart77
• 3,740 points

Related Questions In Database

+1 vote
1 answer

What are the data types in MySQL?

The Data Types of MySQL are as ...READ MORE

answered Dec 12, 2018 in Database by DataKing99
• 8,240 points
2,828 views
0 votes
0 answers

Backup a single table with its data from a database in sql server 2008

I want to use a script to ...READ MORE

Aug 29, 2022 in Database by Kithuzzz
• 38,010 points
269 views
0 votes
1 answer

SQL Server: Extract Table Meta-Data (description, fields and their data types)

Unfortunately, you have to utilize sysobjects/syscolumns to ...READ MORE

answered Sep 17, 2022 in Database by narikkadan
• 63,420 points
489 views
0 votes
1 answer

Data model operations in Hbase

1. Get(returns attributes for a specified row, Gets ...READ MORE

answered Jul 16, 2018 in Database by Data_Nerd
• 2,390 points
577 views
0 votes
1 answer

Using Real Time flume Data for Analysis

By using MorphlineSolrSink we can extract, transform ...READ MORE

answered Jul 17, 2018 in Database by kurt_cobain
• 9,390 points
584 views
0 votes
1 answer

Data Models operations HBase

Put Method – To store data in ...READ MORE

answered Aug 9, 2018 in Database by kurt_cobain
• 9,390 points
377 views
0 votes
1 answer

What is Data Redundancy?

Duplication of data in the database is ...READ MORE

answered Aug 17, 2018 in Database by Sahiti
• 6,370 points
1,049 views
0 votes
2 answers

Types of relationships in Database

There are 3 types of relationships in ...READ MORE

answered Aug 17, 2018 in Database by zombie
• 3,790 points
2,293 views
+1 vote
1 answer

Cursor and Its Types

The cursor is a temporary work area ...READ MORE

answered Aug 9, 2018 in Database by CodingByHeart77
• 3,740 points
637 views
0 votes
2 answers

Database Lock and its types.

Hello Dataking99, A database lock is used to ...READ MORE

answered Apr 20, 2020 in Database by Niroj
• 82,880 points
17,219 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP