CISC 3140 FINAL ACTUAL EXAM PAPER 2026 QUESTIONS WITH ANSWERS GRADED A+

CISC 3140 FINAL ACTUAL EXAM PAPER
2026 QUESTIONS WITH ANSWERS
GRADED A+

>> CISC 3140
Answer: Database Systems (often CISC 3140 or similar course code)


>> Database
Answer: Organized collection of structured data


>> DBMS
Answer: Database Management System


>> Relational Database
Answer: Tables with rows and columns


>> Schema
Answer: Logical structure of the database


>> Entity
Answer: Real-world object or concept


>> Attribute
Answer: Property of an entity


>> Primary Key
Answer: Unique identifier for each record

, >> Foreign Key
Answer: Links tables via primary key reference


>> Candidate Key
Answer: Any attribute(s) that could be primary key


>> Super Key
Answer: Any set containing a candidate key


>> Composite Key
Answer: Primary key made of multiple attributes


>> Surrogate Key
Answer: Artificial key (e.g., auto-increment ID)


>> Natural Key
Answer: Key from real-world data


>> Normalization
Answer: Process to reduce redundancy and dependency


>> 1NF
Answer: First Normal Form – atomic values, no repeating groups


>> 2NF
Answer: Second Normal Form – 1NF + no partial dependency


>> 3NF
Answer: Third Normal Form – 2NF + no transitive dependency