Creating and Modifying a Database · CSEC Information Technology

4 past-paper questions on Creating and Modifying a Database, part of Database Management, from every CSEC Information Technology paper on Quelpr.

1. 8(e)2 marks· CSEC Information Technology · 2011 · Paper 2In the COURSE table it is required to insert a calculated field named FEE to compute the fee for EACH course. If the cost per credit is $250, write the formula for the calculated field.
2. 8(a)3 marks· CSEC Information Technology · May/June 2013 · Paper 2Complete the database structure table by specifying Field Name, Data Type, and Field Description to store the given customer data.
3. Q451 mark · multiple choice· CSEC Information Technology · May/June 2018 · Paper 1Which of the following sequences of steps is correct for deleting a field in a database table?
4. 7(b)(i)2 marks· CSEC Information Technology · May/June 2019 · Paper 2Complete the table to show two field names and their data types that could be used in an Instructor table.