Problem Statement

Consider 10 tables in a database where the table structure is hundred percent normalized. To get the required data we need to join 6 tables. What is the major problem in this scenario? 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. A database is designed to store information of all authors and books written by them. Which of the following is correct while designing a database? 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 will the following command do? DROP DATABASE [database_nam