Theory question 105
Database ManagementPaper 2, Section B: Test of Practical Work
A class captain was asked to create a database in MS Access for all the students in the class without using any template and name it Student_Record. The table created is to be named Students and should have five columns/fields with the following names: ID_Number, Full Name, Date of Birth, Age, Home_Address. (a) Highlight the procedures the captain will follow to create the database. (b) List the steps the captain would take to create the table in Design View. (c) Give the data type suitable for each column/field provided. (d) Which field can be used as the primary key? (e) Mention one importance of primary keys. (f) List three SQL command statements the class captain can perform on the database. (g) Give the SQL query the captain will use to display all the columns in table Students.
Show the model answer
(a) Open MS Access; click Blank database; type Student_Record as the file name; choose where to save; click Create.
(b) Click Create → Table Design; type each field name (ID_Number, Full Name, Date of Birth, Age, Home_Address) and choose its data type; set the primary key; click Save, type Students and click OK.
(c) ID_Number – Number (or Text/AutoNumber); Full Name – Text; Date of Birth – Date/Time; Age – Number; Home_Address – Text (or Memo).
(d) ID_Number.
(e) It identifies each record uniquely, so no two records can have the same value (no duplicates) and tables can be linked.
(f) Any three: SELECT; INSERT; UPDATE; DELETE; CREATE; ALTER.
(g) SELECT * FROM Students;
SELECT * means all columns.