Microsoft Azure Data Fundamentals DP-900 Practice Question
A table named Customers includes a single column called Address that stores combined values such as "12 Main St, London, NW1 1AA". Which normal form rule is violated by storing street, city, and postal code in one column rather than separate columns?
First normal form (1NF) requires that each column hold only atomic-indivisible-values. Storing multiple pieces of data (street, city, postal code) in a single column means the values are not atomic, so the table is not in 1NF. Second normal form deals with partial dependencies in composite keys, third normal form addresses transitive dependencies, and Boyce-Codd normal form refines third normal form-all of which assume the table already meets 1NF.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is First Normal Form (1NF)?
Open an interactive chat with Bash
Why is it necessary to adhere to First Normal Form (1NF)?
Open an interactive chat with Bash
How can we correct a table to meet First Normal Form (1NF)?
Open an interactive chat with Bash
Microsoft Azure Data Fundamentals DP-900
Identify considerations for relational data on Azure
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .