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 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

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

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

You are working with a data set including order records and their ID numbers. While profiling the data, you noticed that there are duplicate values in the "ID" field for each order. You need to create a data set that only shows one record per order, which would create a data set with distinct orders. What keyword can you include in the query to provide a unique list of orders?Select an answer:REMOVE DUPLICATESDELETEDISTINCT

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