Rdms, phase2 db1 Essay Example | Topics and Well Written Essays - 500 words

Rdms, phase2 db1 - Essay ExampleTwo types of single constraints entity integrity and referential integrity are taken in account for the design and development of database system.An Entity is normally thought of as a noun a person, place or thing. In a real sense, Entities reflect Tables in the database (Mickler, 2008). Entity integrity guarantees that there are no duplicate records within the bow and that the field that identifies each record within the elude is unique and never null. In general, Entity Integrity is the mechanism the system provides to preserve primary keys so that there is a unique identifier for rows in the prorogue (database.dev.co.uk, 2008). It is good practice to have primary key in every table so that each row can be identified uniquely. A primary key is typically only one field and that field is focalize to a special domain, or type (Mickler, 2008). A primary key, composed of one or more columns, uniquely identifies each row of a table and eliminates th e possibility of duplicate rows in a table (CTU Online, 2008).According to Hoffer, Prescott & McFadden (2007), A strange key is an attribute in a relation of a database that serves as the primary key of another relation in the same database. Referential integrity maintains the consistency among the rows of two relations. The referential integrity rule states that for every foreign key value in a table, there must be a corresponding primary key value in another table in the database (CTU Online, 2008). Problems arise when we fail to relate the tables properly and inadvertently delete data in a particular table that would result in rugged links or floating records (Mickler, 2008).For the new Student Class Registration System we have to make sure that entity and referential integrity constraints are applied. Entity integrity can be achieved by having a primary key not null field in each table of the database system that uniquely identifies each row. In case of our new Student Class R egistration