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 1Question 2What is the first step to normalize the "Books" table into 1NF?Separate authors into individual rowsRemove the Genre columnCombine multiple titles into a single columnRemove the Author 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 1Question 2Question 3Following the first step, what is the final step to achieve 1NF for the "Books" table?Combine multiple titles into a single columnRemove the Author columnSeparate genres into individual rowsRemove the Title 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

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

What is the first step in the normalization process?ACreate a First Normal tableBIdentify transitive dependenciesCCreate an Un-Normalized table

What is normalization in database?AThe process of creating a table structureBThe process of converting data into a more structured formCThe process of deleting irrelevant data