|
IntegrityConstraints
Entity integrity A Student should have a matriculation number which is unique and not null. For searching for Student Information, there should be a registered student in the database. Similarly, every Subject has a Unique ID to identify and avoid duplicate values. Referential integrity Entity Course contains a Unique ID as primary key and Matriculation Number which is the Primary Key of the Entity Student. A course for a Student exist only if the student exist. |