Question 5 (ULOS 1, 2, 3, 4] 4 Marks Write SQL codes to perform the following actions in MS Access: a. Create a table "S
Posted: Tue Jul 05, 2022 10:26 am
Question 5 (ULOS 1, 2, 3, 4] 4 Marks Write SQL codes to perform the following actions in MS Access: a. Create a table "Student" using SQL code. Data types, any data constraints and primary key must be defined correctly defined. Attributes to be included in this table are: StudentID, LastName, FirstName, Country, DateOfEntrollment. 2 Marks b. Alter table "Student" by adding two more columns "Email" and "Age". 1 Marks c. Delete "Age" column and add column "DateOfBirth". 1 Marks