what happens when we create our tables with relationships and then have to modify the relationship? can we do this if the data is in the tables?

State the difference(s) between the Short Table Look up and the Long Table Look up. How do you know which type of table look up you will need?

Errors occur when something doesn't perform properly. How does a test oracle really work? Testing what? This is a serious problem, but who is to blame for it?

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.