ISTM 250 PRACTICE FINAL REVIEW 2026 QUESTIONS WITH CORRECT ANSWERS GRADED A+

ISTM 250 PRACTICE FINAL REVIEW 2026
QUESTIONS WITH CORRECT ANSWERS
GRADED A+

>> Database Concepts
Answer: Tables, rows, columns


>> Entity
Answer: Real-world object


>> Attribute
Answer: Characteristic of entity


>> Primary Key
Answer: Unique identifier


>> Composite Key
Answer: Multiple attributes as key


>> Foreign Key
Answer: References primary key in another table


>> Relational Model
Answer: Proposed by E.F. Codd


>> Normalization
Answer: Eliminate redundancy

, >> 1NF
Answer: Atomic values


>> 2NF
Answer: No partial dependency


>> 3NF
Answer: No transitive dependency


>> Boyce-Codd Normal Form (BCNF)
Answer: Stronger 3NF


>> SQL
Answer: DDL, DML, DCL


>> SELECT
Answer: Retrieve data


>> FROM
Answer: Table name


>> WHERE
Answer: Filter condition


>> ORDER BY
Answer: Sort results


>> GROUP BY
Answer: Aggregate by category