UNF – Unnormalized Form — Learn free

Self-check

Questions 1–10 of 10

1. What does Unnormalized Form (UNF) represent?
Question 1A. The raw and unstructured state of data before any normalization rules are appliedB. The final, fully normalised state of a relational databaseC. A table that has had all transitive dependencies removedD. A schema in which every determinant is a superkeyE. A read-only archive of historical records
2. Which of the following is a typical characteristic of a table in Unnormalized Form?
Question 2A. Every column holds a single atomic valueB. Repeating groups and multi-valued attributes within a single rowC. A formally enforced composite primary keyD. Every non-key attribute depends on the whole keyE. Each entity is stored in its own separate table
3. In the loan approval example of Unnormalized Form, what problem do columns such as RepayDates, RepayAmounts and RepayStatuses illustrate?
Question 3A. A transitive dependency between customer and loan attributesB. A missing foreign key relationshipC. Several values stored in one cell, separated by commas or line breaksD. A partial dependency on a composite keyE. Duplicate primary key values across rows
4. What does the term "entity mixing" describe in an Unnormalized Form table?
Question 4A. Joining two normalised tables in a queryB. Storing the same entity under two different namesC. Splitting one entity across several tablesD. Customer, loan, decision and repayment attributes coexisting in the same structureE. Using a lookup table to resolve entity types
5. In an Unnormalized Form loan table, what happens when a customer changes their address?
Question 5A. The change propagates automatically through a foreign keyB. Only the Customer table needs a single updateC. The address is rejected because it is not atomicD. The change is recorded as a new version rowE. Every related row must be updated manually
6. Which of the following does Unnormalized Form NOT guarantee?
Question 6A. Rapid data captureB. Atomicity of column valuesC. Structure of some kindD. A reflection of how data was collectedE. A starting point for normalisation
7. From which kinds of sources do Unnormalized Form data collections typically originate?
Question 7A. Spreadsheets, CSV extracts, operational exports and loosely designed legacy systemsB. Fully normalised transactional databasesC. Star schemas in a data warehouseD. Data vault hubs and linksE. Graph databases with typed relationships
8. Why do many real-world systems begin in Unnormalized Form?
Question 8A. Because relational databases cannot store atomic valuesB. Because normalisation is only possible after data is archivedC. Because capturing information quickly is often prioritised over designing it correctlyD. Because regulators require raw data to remain unstructuredE. Because UNF eliminates update anomalies
9. How are composite keys typically present in an Unnormalized Form table?
Question 9A. They are always declared explicitly with database constraintsB. They are forbidden in UNFC. They are replaced by surrogate keysD. They may appear implicitly, but without formal constraint enforcementE. They are generated by the normalisation process
10. What is the intended role of Unnormalized Form in the normalisation journey?
Question 10A. The recommended design for transactional systemsB. An optional intermediate step after Third Normal FormC. The point at which dependency integrity is enforcedD. The final form reached after removing join dependenciesE. The starting mess from which normalisation begins, never the stopping point