adspace


What is structural independence and why is it important?

Answer Posted / Chhavi Singh

Structural Independence in SQL refers to the ability of a table or database to be understood without referring to other tables. It means that each table should have all the necessary information for its own integrity, and any foreign keys referencing other tables should have defined relationships. Structural Independence is important because it helps ensure data consistency and makes the database easier to understand, manage, and maintain.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is your daily office routine?

2353


what are the advantages of sql ? : Sql dba

1154


what is bcp? When does it used? : Sql dba

1065


Is primary key always clustered index?

1101


how to escape special characters in sql statements? : Sql dba

1124


What is the current version of sql?

1106


what are all the common sql function? : Sql dba

1141


what is collation? : Sql dba

1242


Do we need to rebuild index after truncate?

1154


Is inner join faster than left join?

1287


what is sql server agent? : Sql dba

1189


how many tables will create when we create table, what are they? : Sql dba

1156


what is schema? : Sql dba

1163


Is primary key clustered index?

1028


Does group by remove duplicates?

1121