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
What is your daily office routine?
what are the advantages of sql ? : Sql dba
what is bcp? When does it used? : Sql dba
Is primary key always clustered index?
how to escape special characters in sql statements? : Sql dba
What is the current version of sql?
what are all the common sql function? : Sql dba
what is collation? : Sql dba
Do we need to rebuild index after truncate?
Is inner join faster than left join?
what is sql server agent? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
what is schema? : Sql dba
Is primary key clustered index?
Does group by remove duplicates?