1.1) SQL Fundamentals 2 – Lesson 1 (Users) [20]
Write a summary report (2-4 pages) on the users of a database. Also show examples of the
SQL instructions used to manage users, privileges and roles.
1.2) SQL Fundamentals 2 – Lesson 2 (Changes to tables) [20]
Write a summary report (2-4 pages) to describe the below changes that can be made to
tables with examples of possible scenarios, the SQL instructions used and the results
thereof.
• Add-, alter-, and remove columns
• Change the name of columns
• Add-, and remove constraints
1.3) SQL Fundamentals 2 – Lesson 3 (Objects and data dictionary views) [20]
Write a summary report (2-4 pages) on the use of data dictionary views in your database.
Also show examples of the SQL instructions used to create and use them.
Sample Solution
