Answer to Question 1
Student answers will vary. Some examples include:
Database may have initially been built to track customers and the orders they placed. Now you may want also to track marketing efforts and the quantity of customers who use coupons that were mailed or emailed to them. You would need to create a new table to track who redeemed coupons and when they were redeemed.
The Painted Paradise Resort and Spa's marketing department regularly updates their database with new marketing campaigns, customers, and redemption status of discounts. If the spa manager wants to ensure he has current data for decision making, he needs to regularly add new records to the table that is storing the marketing data in the Spa database. An Append query could help the spa's manager easily and regularly add new records to the existing table.
Perhaps an employee no longer works at the salon and there are dozens of future appointments that need to be changed to a different employee's name. If the same employee (perhaps the person you hired to fill that employee's position) is now going to handle these appointments, you could create an update query that changes the name of the employee for all future appointments from the employee who left to the new employee.
The spa manager may want to remove all coupons that were not redeemed and have now expired. This will keep the database cleansed, meaning that the Delete query will remove data that isn't useful or needed anymore.
Answer to Question 2
B
Action of aldosterone on distal convoluted tubule epithelial cells.
Localization of neurotransmitter action
Action! Children love to talk about the actions of adults and animals, which provides a natural way ...
Mechanisms of Action of Drugs Used to Treat Angina
Action of the Pyruvate Dehydrogenase Complex
Nick translation in removal of RNA primers by coordinated action of the 5’ exonuclease and ...