Suppose we have the following structure for the "Orders" table:Order ID Customer Name Order Details1001 John Doe Laptop, Monitor, Mouse, Keyboard1004 Jane Smith Smartphone, Tablet, Headphones1003 Alice Brown Chair, Desk, Lamp, Bookshelf, Coffee Table1002 Alice Brown NULLAnswer the following questionsQuestion 1This table violates 1NF because:The "Customer Name" column contains duplicate valuesThe "Order Details" column contains multiple values (multiple order details) in the same cell.The "Order Details" column contains NULL valuesOrder is not maintained in the column "Order ID"All of theseSave

uppose we have the following structure for the "Orders" table:Order ID Customer Name Order Details1001 John Doe Laptop, Monitor, Mouse, Keyboard1004 Jane Smith Smartphone, Tablet, Headphones1003 Alice Brown Chair, Desk, Lamp, Bookshelf, Coffee Table1002 Alice Brown NULLAnswer the following questionsQuestion 1This table violates 1NF because:The "Customer Name" column contains duplicate valuesThe "Order Details" column contains multiple values (multiple order details) in the same cell.The "Order Details" column contains NULL values

Suppose we have a table named "Books" with the following structure:Book ID        Title Author Genre1 The Great Gatsby F. Scott Fitzgerald, Orwell Fiction, Dystopian2 Pride and Prejudice Jane Austen Romance, Thriller3 The Catcher in the Rye J.D. Salinger Fiction, SuspenseAnswer the following questionsQuestion 1This table violates 1NF because:The "Author" column contains multiple values (multiple authors) in the same cell.The "Genre" column contains multiple values (multiple genres) in the same cell.Both a and bTable is in 1NF only

Suppose we have the following structure for the "Orders" table:Order ID Customer Name Order Details1001 John Doe Laptop, Monitor, Mouse, Keyboard1004 Jane Smith Smartphone, Tablet, Headphones1003 Alice Brown Chair, Desk, Lamp, Bookshelf, Coffee Table1002 Alice Brown NULLAnswer the following questionsQuestion 1Question 2What is the first step to normalize the "Orders" table into 1NF?Remove the Order Details columnSeparate orders into individual rowsSeparate each item in the Order Details into individual rowsCombine multiple items into a single columnSave

Why is it important for every column in a table to have a unique name in 1NF?To prevent data inconsistencyTo ensure data redundancy

What SQL constraint prevents duplicate values from being stored in a specific column?*1 pointDEFAULTUNIQUEFOREIGN KEYINDEX