{"cards":[{"text":"The minimum number of attributes required to uniquely identify a row in a table.","answer":"Prime Key","tip":"

Two words. <\/p>\n"},{"text":"A prime key that consists of more than one attribute","answer":"Composite Key","tip":"

two words<\/p>\n"},{"text":"An attribute, or a set of attributes, in a table that has a corresponding data value in another table. Referential Integrity is ensured when data in the second table has a matching value in the first table.","answer":"Foreign Key","tip":"

two words<\/p>\n"},{"text":"A rule on data values, defined by a user, and enforced by the DBMS","answer":"constraint","tip":"

one word, begins with C<\/strong><\/p>\n"},{"text":"A number assigned to uniquely identify a record. May serve as a prime key. It could be, a serial number with no significance to the data.","answer":"Surrogate Key","tip":"

two words s________ k__<\/p>\n"},{"text":"Data represented in two dimensional format as rows and columns.","answer":"Table","tip":"

usually used with a chair<\/p>\n"},{"text":"A table that has the prime key defined","answer":"relation","tip":"

one word, begins with r<\/strong><\/p>\n"}],"progressText":"Card @card of @total","next":"Next","previous":"Previous","checkAnswerText":"Check","showSolutionsRequiresInput":true,"defaultAnswerText":"Your answer","correctAnswerText":"Correct","incorrectAnswerText":"Incorrect","showSolutionText":"Correct answer","results":"Results","ofCorrect":"@score of @total correct","showResults":"Show results","answerShortText":"A:","retry":"Retry","caseSensitive":false,"cardAnnouncement":"Incorrect answer. Correct answer was @answer","pageAnnouncement":"Page @current of @total","description":"Database Design - Identify Definitions with Terms"}

Database Design - Terms of Reference

Saif Terai