Trusted by millions of Kenyans
LoginRegister
Study resources on Kenyaplex

Get ready-made curriculum aligned revision materials

Exam papers, notes, holiday assignments and topical questions – all aligned to the Kenyan curriculum.

Browse exam papers
Or go directly to:
Class notes Holiday assignments Topical questions Other resources

Define the two principal integrity rules for the relational model. Discuss why it is desirable to enforce these rules.

Define the two principal integrity rules for the relational model. Discuss why it is desirable to enforce these rules.

Answers

kelvin
1.Entity integrity.In a base table, no column of a primary key can be null.
2.Referential integrity .If a foreign key exists in a table, either the foreign key value must match a candidate key value of some record in its home table or the foreign key value must be wholly null.

kevowmuchiri answered the question on July 4, 2018 at 15:36

Answer Attachments

Next: Discuss the differences between the candidate keys and the primary key of a table. Explain what is meant by a foreign key. How do foreign...

Previous: What are the two major components of SQL and what function do they serve?

View more Computer Science Questions and Answers  |  Return to Questions Index

Exams With Marking Schemes

Related Questions