Directions:  Write TRUE if the statement is true and FALSEif the statement is not true. USECAPITAL LETTERS!______6. SELECT title, author_lname, released_year FROM books_tbl WHERE author_lname=”Eggers” AND released_year > 2010; Your answer______3. The normalization process in database design aims to eliminate data redundancy and dependency. Your answer______7. Sharding is a technique used to horizontally partition a database, distributing different portions of a table across multiple servers. Your answer______4. SELECT -10 < -9;Your answer______5. In-memory databases store and manage data in the computer's main memory (RAM) rather than on disk for faster access. Your answer______10. SELECT title, released_year FROM books_tbl WHERE released_year NOT BETWEEN 2004 AND 2015;Your answer______1. In a graph database, relationships between data entities are as important as the entities themselves. Your answer______2. SELECT title, released_year FROM books_tbl WHERE released_year <= 2000;Your answer______8. SELECT -10 > -20 && 0 <= 0;Your answer______9. In a relational database, a foreign key establishes a link between two databases. Your answerBackSubmitClear form

What is database normalization

Directions: Write X when the syntax is CORRECT and Z whenthe syntax is INCORRECT. NO ERASURES!DB NAME: books_db   Table Name: books_tblAssume all column names are correct3. SELECT author_lname FROM books_tbl ORDER author_lname;Your answer7. SELECT title, released_year FROM books_tbl ORDER BY released_year DESC LIMIT 14; Your answer8. SELECT author_lname, title FROM books_tbl ORDER BY 2; Your answer5. SELECT author_lname FROM books_tbl ORDER BY author_lname BESC; Your answer10. SELECT title FROM books_tbl WHRE  title LIKE “the”;Your answer1. SELECT DISTINCTS CONCAT(author_fname,” “, author_lname) FROM books_tbl;Your answer6. SELECT title FROM books_tbl LIMIT 10;Your answer11. SELECT title, released_year FROM books_tbl WHERE released_year <= 2000;Your answer4. SELECT title FROM books ORDER BY title;Your answer15. SELECT title, released_year FROM books_tbl WHERE released_year NOT BETWEEN 2004 AND 2015;Your answer12. SELECT -10 < -9;Your answer2. SELECT DISTINCT author_fname, author_lname FROM books;Your answer9. SELECT title, stock_quantity FROM books_db;Your answer14. SELECT -10 > -20 && 0 <= 0;Your answer13. SELECT title, author_lname, released_year FROM books_tbl WHERE author_lname=”Eggers” AND released_year > 2010;

What is the primary goal of normalization in database design?a.Maximizing update anomaliesb.Maximizing redundancyc.Minimizing redundancy and update anomaliesd.Minimizing data integrity

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

1. What are the key considerations in designing a relational database schema, and how does normalization contribute to effective database design?