CNTT1152E — Database Management Systems

This course provides basic knowledge about methods and skills to create data, search and exploit data, and perform administrative operations on the system. The database management use Microsoft SQL Server will be used as a tool to illustrate and simulate the problems that will be presented because it is a relatively complete database management system. The function of a database management to act as a data server. Write SQL commands to create databases, create tables, insert/update/delete/retrieve rows in a common database management system. This course, student learn about constraints, learn about how to create a constraint, types of constraints, and difference between unique, not null and primary key constraints. Student learn about types of SQL Statements, Databases in SQL Server. How to create a database, datatypes in SQL Server, and about DDL Statements, DML Statements. Learn how to create a stored procedure and difference between stored procedure and table, advantages of procedures and about types of parameters

9.1. Requirements for taking final /terminal exams Students are allowed to take the final exam if their attendance score reaches 5 points or more (on the scale of 10). 9.2. Requirements for attending classes Students are responsible for attending all classes. In case of absence from school due to force majeure reasons, sufficient and reasonable proofs must be provided. For each absence, 1 point will be deducted 1 point. Students who miss any classes more than 3 times, with or without reason, will be considered as failing to complete the course and have to re-register. Students will be awarded points for constructive comments these points are added to attendance points and group assignments. Groups who do not submit the group work will receive a score of 0 (zero). Late submissions will be deducted for each day of late submission. 9.3. Requirements for in-class behaviour The course is conducted on the principle of respecting learners and lecturers. Any behaviour that affects the teaching and learning process is strictly prohibited. Students must come to class on time. Students who are late more than 10 minutes after class starts will not be allowed to attend the class. Do not make noise and affect others during the learning process. Laptops and tablets are only used for the purpose of taking notes for and calculating for lectures and exercises, absolutely forbidden to use for other purposes.