Problem Statement

Picture a database with 10 tables, fully normalized in structure. Getting the data you need requires joining 6 of these tables. What is the main downside in this situation? Insertion, updation and deletion cost will increase. Normalization simplifies the database design as well as queries. Cost will increase in terms of space and not time. As database is normalized, queries will be complex and time taking because of multiple joins. Consider a database built to hold records of authors and the books they've written. Which statement correctly describes how this should be modeled? A book is written by one author so there is one-to-one relationship between them. An author can write multiple books so there is one-to-many relationship between them. An author can write multiple books so there is many-to-one relationship between them. An author can write multiple books so there is many-to-many relationship between them. What does the following command accomplish? DROP DATABASE [database_name] D