You have an Azure SQL Database server named Server1 that contains a database named DB1. You create an auditing policy for DB1. After a few weeks, you create five more databases in Server1. You then create a new auditing policy for Server1. You notice that auditing entries for DB1 are duplicated. You need to ensure that auditing entries for all existing and future databases are not duplicated. What should you do? 1     Configure the policy used in DB1 with the same settings as the policy on Server1.       Configure the policy used on Server1 with the same settings as the policy in DB1.      Create a policy for each of the five new databases.       Disable auditing for DB1.

You will need to initiate a transaction in the database before you can go on. In the next discussion, we are going to focus mostly on the positive features of the firm, so stay tuned for that!

Consider the following set of requirements to maintainaSmartBuy store database:   •You should record the store with store ID,store name,and location.There are more than one       stores inacity,one store isasupervised store.   •Stores sell items.You should record each item as item code,name,and price.Different stores       may supply different prices for same item.       The database should also maintain customer information.You should record the name,address,       and phone number of each customer.       An invoice is written forasingle customer,butacustomer can have many invoices.You should       record invoice number and the date of an invoice issued.   •You should record items of each invoice which describe the items bought by the customer.You       should record the quantity of each item.According to the information above,answer the following questions:   a)Indicate the name of entities,attributes,and relations.You must use uppercase to name your       entities.   b)Draw and then…

There was an error processing your database query. Write-through methods and deferred-write recovery in databases: how do they work?