What do you understand by the term “Referential integrity” in a database? Explain “cascading update” and “cascading delete” option with respect to relationship between tables.
Answers
Answer:
Referential integrity refers to the relationship between tables. Because each table in a database must have a primary key, this primary key can appear in other tables because of its relationship to data within those tables. Referential integrity is the logical dependency of a foreign key on a primary key.
CASCADE. It is used in conjunction with ON DELETE or ON UPDATE. It means that the child data is either deleted or updated when the parent data is deleted or updated.
Answer:
In the following report, I will be talking about the main reasons why we use databases, the benefits of using them and a brief history of old database designs to the current database designs we have today. I will explain some terminology about relational databases and the current attributes within them. I will relate to Microsoft SQL Management Studio 2005 with some visual screenshots and syntax quotes, these will be formatted accordingly.
Mark me as brainlieast