Final Exam – Concept Study Questions with Answers

Final Exam – Concept Study Questions with Answers A table is a 3-dimensional object made up on rows and columns - False The order of rows and columns in a relation is ________ (important or insignificant) - insignificant Primary purposes of a database management system (DBMS) - securing data, storing data, updating data; NOT integrated development environment the term integrity refers to the ________ of the data - accuracy A domain constraint refers to: - ensuring all data in a column conform to the same data type Which primary key would go to the other entity as a foreign key? - One goes to many single line vs double line in relationship diagram - single-line means that entities can exist at super entity level, double-line means they cannot (MUST belong to one of sub-entities) overlap vs disjoint in relationship diagram - disjoint = either/or, cannot belong to multiple sub-entities overlap = can be in multiple sub-entities, no limit for membership composite key - combining two or more attributes to uniquely identify each row in the table (as a primary key) ex: order_id & product_id entity integrity rule - no primary key attribute can be null