Data Modeling Flashcards
7 cards from real 1Z0-006 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Data Modeling flashcards as text
A table stores OrderID, ProductID, ProductName, and Quantity. OrderID+ProductID form the primary key. ProductName depends only on ProductID. Which normal form is violated?
Answer: 2NF, because ProductName is partially dependent on the composite key
ProductName depends only on ProductID (part of the composite key), creating a partial dependency that violates 2NF.
Which ERD notation uses 'crows foot' symbols combined with a vertical bar and circle to show minimum and maximum cardinality?
Answer: IE (Information Engineering) / Crow's Foot notation
Information Engineering (Crow's Foot) notation uses symbols at each end of a relationship line to indicate minimum (optional/mandatory) and maximum (one/many) cardinality.
What is a self-referencing (recursive) relationship in an ERD?
Answer: A relationship where an entity relates to itself
A recursive relationship occurs when an entity has a relationship with itself, such as an EMPLOYEE who manages other EMPLOYEEs.
In Oracle SQL Developer Data Modeler, what is the difference between a 'logical' and a 'relational' model?
Answer: A logical model uses entity/attribute terminology; a relational model maps these to tables/columns with keys
The logical model uses abstract entity and attribute concepts, while the relational model transforms these into tables, columns, primary keys, and foreign keys for implementation.
Which of the following best describes entity integrity?
Answer: No primary key column can contain a NULL value
Entity integrity requires that primary key columns never contain NULL, ensuring every row can be uniquely identified.
What is an associative entity (also called an intersection entity)?
Answer: An entity created to represent a many-to-many relationship, containing foreign keys to both related entities
An associative entity resolves a many-to-many relationship by acting as a junction, holding foreign keys to both parent entities and often adding its own attributes.
Which statement about First Normal Form (1NF) is correct?
Answer: Each column must contain atomic (indivisible) values and each row must be unique
1NF requires that each column holds a single, atomic value and that there are no repeating groups, ensuring the table structure is flat and relational.