ITSS 3300 DATA & DATABASES Exam Questions with Correct Answers Verified by Experts|
Latest Update
Primary Key Field in table used for key fields
Foreign Key Primary key used in second table as look-up field to identify records from
original table
Capabilities of DBMS •Data definition capability
•Data dictionary
•Querying and reporting
•Many DBMS have report generation capabilities for creating polished reports (Microsoft
Access)
Normalization Streamlining complex groupings of data to minimize redundant data
elements and awkward many-to-many relationships
Referential integrity Rules used by RDBMS to ensure relationships between tables remain
consistent
Cardinality Measure of the number of links in a particular relationship between database
one or more data entities
Main Operations Within DBMS read, insert, modify, delete data
Key SQL Script Commands •SELECT - What fields do you want to see?
Latest Update
Primary Key Field in table used for key fields
Foreign Key Primary key used in second table as look-up field to identify records from
original table
Capabilities of DBMS •Data definition capability
•Data dictionary
•Querying and reporting
•Many DBMS have report generation capabilities for creating polished reports (Microsoft
Access)
Normalization Streamlining complex groupings of data to minimize redundant data
elements and awkward many-to-many relationships
Referential integrity Rules used by RDBMS to ensure relationships between tables remain
consistent
Cardinality Measure of the number of links in a particular relationship between database
one or more data entities
Main Operations Within DBMS read, insert, modify, delete data
Key SQL Script Commands •SELECT - What fields do you want to see?
