Conceptual and Logical Data Design Flashcards
6 cards from real DMC practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Conceptual and Logical Data Design flashcards as text
Which of the following best distinguishes a logical data model from a conceptual data model?
Answer: A logical model adds attributes, primary keys, and data types without specifying a DBMS
A logical data model refines the conceptual model by adding detailed attributes, primary and foreign keys, and data types while remaining DBMS-independent.
In logical data modeling, what is normalization primarily used to achieve?
Answer: Eliminate data redundancy and update anomalies
Normalization is the process of organizing data to eliminate redundancy and dependency anomalies, ensuring each fact is stored in one place.
What is a functional dependency in the context of normalization?
Answer: A situation where the value of one attribute determines the value of another
A functional dependency (A → B) means that knowing the value of attribute A uniquely determines the value of attribute B.
Which normal form eliminates partial dependencies on a composite primary key?
Answer: Second Normal Form (2NF)
2NF requires that every non-key attribute is fully functionally dependent on the entire primary key, eliminating partial dependencies.
Third Normal Form (3NF) eliminates which type of dependency?
Answer: Transitive dependencies
3NF removes transitive dependencies, ensuring that non-key attributes depend only on the primary key and not on other non-key attributes.
What makes Boyce-Codd Normal Form (BCNF) stricter than 3NF?
Answer: BCNF requires every determinant to be a candidate key, including in cases 3NF misses
BCNF strengthens 3NF by requiring that every determinant in the relation is a candidate key, handling edge cases where 3NF still allows anomalies.
How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- technicspub.com — Test delivery, eligibility, fees, exam format, passing score, retake policy, score release, time limit, exam information · verified Oct 2026