Submit a write up that describes the steps of creating a database of Certificates using MongoDb. Be sure to include any commands that need to be executed. Also include a description of how querying would be accomplished to select only those certificates with the word "Microsoft"

What exactly are triggers? What function do they serve? How do you use Access 2016 to get the functionality of a trigger?

In Oracle, a calculated field such as item_price * item_quantity differs from a table field in what way?   Question 26 options:   1)  A calculated field should be saved in the table after its value has been computed.   2)  There is no difference. They are just synonyms for the same concept.   3)  A calculated field's value appears in the output of a SELECT statement, but it is not physically stored as a field in the table.   4)  A sum cannot be computed for a calculated field.

Hello. I am having trouble with a question for my database devlopment class. I need help with this because I have been struggling with this and haven't found a clear answer. I would appreciate the help. Thanks. Display a list of all books in the BOOKS table. If a book has been ordered by a customer, also list thecorresponding order number and the state in which the customer resides. Use the tablesdb1.casteel.books, db1.casteel.orderitems, db1.casteel.orders, & db1.casteel.customers.[ HINT: You should get 35 rows and three columns ]

3. Assign privileges to the new account that allow connecting to the database, creating newtables, and altering an existing table.

Task 5: The Developers team also wants you to ensure that emails are converted to lowercase after an update operation. Currently, new insertions are guaranteed to have lowercase emails, but there is no such guarantee for legacy emails. Therefore, the team wants to ensure that emails are being retained in a lowercase irrespective of any changes in the database. Create a new TRIGGER called email_update for the USERS table that runs before an UPDATE operation. Task: Create a TRIGGER to run on the USERS table before any UPDATE operation.   (SQL Database Test): Create a TRIGGER before any UPDATE operations on the USERS table

The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the database. However, the team wants to calculate the VAT after the discounts are applied on the prices. In addition, it is important to remember if there is no discount/offers, then the value is NULL in the TRAVELS table. Create a procedure called VATCalculator to calculate the VAT amount and return with the corresponding travel ID. In addition, execute the procedure to account for NULL values and send the respective result to the team. The VAT value should be rounded to 2 decimals.

he Car Maintenance team wants to add new maintenance tasks to the MAINTENANCES table which was created in Chapter 8, Activity 1. However, the team also wants to insert the tasks in a batch into the database. In other words, they want to insert the rows all together without inserting one-by-one. Therefore, you will need to create a script to add the following tasks and ensure that they are added together: Car ID: 1001, Maintenance Type: 2, Due: 2022-06-01 Car ID: 1003, Maintenance Type: 2, Due: 2022-06-01

What are the INSERT TRIGGER, DELETE TRIGGER and UPDATE TRIGGER. Explain with examples.

Triggers? Why? What are the event triggers in Access 2016?