Your role for this assessment item is that of an employee of Uptown IT completing a PD training program organised by the company for employees wishing to apply for senior roles within the Uptown IT Database Management Department. Your teacher/assessor will take on the role of an Uptown IT Database Senior Analyst for this project. Read and familiarise yourself with the Project Scenario or Case Study before proceeding with the portfolio parts and tasks. Confirm anything you are not sure about with your teacher. It is essential that you have a clear understanding of the scenario and tasks that you need to complete. This assessment instrument requires the student to submit a two (2) parts assignment. PART 1. Background knowledge of Structured Query Language (SQL) and database management system (DBMS)

• Task 1. DBMS and SQL knowledge of concepts and terminology
• Task 2. Selecting and setting up the DBMS environment

PART 2. Create a database, create tables, alter table structure and table properties and test database with specific queries

• Task 1. Create database and create tables
• Task 2. Alter tables
• Task 3. Populate database using CSV files
• Task 4. Testing tables with specific queries (6 queries)

Attachments:

ICTPRG431-AT1....docx