Question

When a new student is added to a new database, you want new records to be created in the related tables such as Exam, Score, and Attendance. How would you accomplish this?

a) Using a stored procedure
b) Using a trigger
c) Using a view
d) Using a subquery

Answer 1

To have new records created automatically in related tables when a new student is added to a database, the use of a trigger is the best approach.

Step-by-step explanation:

When a new student is added to a database and you want new records to be automatically created in related tables such as Exam, Score, and Attendance, the best way to accomplish this would be b) Using a trigger.

A trigger is a database object that is tied to a specific table and is automatically executed or fired when certain events occur. For example, when a new student record is inserted into the Students table, a trigger can be set up to automatically insert corresponding entries into the related Exam, Score, and Attendance tables.

Triggers are useful in this scenario because they ensure data integrity across related tables without the need for manual intervention each time a record is added. It also ensures that all the necessary data in related tables is consistently maintained, creating a robust database system where related records are always in sync.