Database Systems Exam 1 Questions With Correct Answers

super key {Ans: Any key that uniquely identifies each row}constraints {Ans: a restriction placed on data}Data dictionary {Ans: - Provides detailed accounting of all tables found within the user/designer-created database - Contains ( ) at least) all the attribute names and characteristics for each table in the system - Contains metadata: data about data}entity {Ans: is a anything about which data can be collected (person, place, thing etc.)}Subtype discriminator determines : {Ans: which entity subtype the supertype occurrence is related to}a data model should contain {Ans: • A description of the data structure that will store the end-user data. • A set of enforceable rules to guarantee the integrity of the data. • A data manipulation methodology to support the real-world data transformations.}