CT 201 INTRODUCTION TO DATABASE

This course covers a wide array of topics such as characteristics and advantages of the database management systems (DBMS), concepts of database and its architecture, data models, database schemes and instances, database models, relational data model (ER-diagram) and SQL (Structured Query Language); including data definition, queries, update, statements, and views in SQL, database design; functional dependencies, normal forms, and relational algebra, relational model constraints; domains, keys, and integrity constraints.


Reference Book: Avi Silberschatz, Henry F. Korth, and S. Sudarshan, ―Database System Concepts‖, 6th Edition, McGraw-Hill, 2010.

Lecture Timing: Tuesday, 8 - 10 AM
Lab Timing: Monday, 1 PM - 3 PM

Mid Term 1: 16th October 2018 (Lab 1 is also included)
Mid Term 2: 27th November 2018 (Lab is also included)

 Lab Exam: 26th November 2018 (01:00 to 3:00 PM)

 Assignment 1: Link (Submission Date: 13th November, 2018)
Assignment 2: Link (Submission Date: 20th November, 2018)


Week
Date
Lecture Slides
Lab Slides
Additional Resources
1
11/09/2018
Unit 1 Database


2
18/09/2018
Unit 2 Database


3
25/09/2018
ER Model
Lab 1

4
23/10/2018
Relational Data Model
Lab 2

5
30/10/2018
Basic SQL
Lab 3

6
06/11/2018
Relational Calculus & Join


7
13/11/2018
Intersection, Union etc.


8
20/11/2018
File Organization and Normalization


9
04/12/2018
Storage


10




11




12




13




14




15




16




17




Comments

Post a Comment

Popular posts from this blog

SPY 2005 Digital Forensics 1

The course on digital forensics and its applications in cybersecurity covers a range of topics including an introduction to digital forensics, computer and network architecture, digital evidence collection and preservation, file systems and disk analysis, network forensics and traffic analysis, malware analysis and reverse engineering, incident response and digital forensics, basic cryptography, operating system forensics, and anti-forensics techniques. The course aims to equip students with the knowledge and skills necessary to conduct a forensic investigation of digital devices and networks in the context of cybersecurity.   Mid Term 1: 13th April 2025 at 12:30 PM (Assignment Due Date: 24th April 2025) Assignment 1:   Link Assignment 2:   Link Week Date Lecture Slides Lab Slides Additional Resources 1 Week 1 2 Week 2 3 Week 3 Lab Experiments 4 Week 4 5 Week 5 6 Week 6  7 Week 7 8 Week 8 9 Week 9 10 Week 10 11 12 13 14 15 16 17
Read more

CSC 421 Cryptography

This course is an introduction to the basic theory and practice of cryptographic techniques used in computer security. We will cover topics such as encryption (secret-key and public-key), message integrity, digital signatures, user authentication, key management, cryptographic hashing, Network security protocols (SSL, IPsec), public-key infrastructure, digital rights management, and a bit of zero-knowledge protocols. Lecture Time:  Sunday-10:00 to 10:50 AM Lab Time:  Tuesday-10:00 to 10:50 AM Mid Term 1:  Exam for Qavaiyyah Students on 16th October 2024 at 11:00 AM - 12:00 PM. Mid Term 2:  Exam for Qavaiyyah Students on 25th November 2024 at 11:00 AM - 12:00 PM. Exam for Dawadmi Students on 25th November 2024 at 12:30 PM - 01:30 PM, F-211. (Assignment Due Date: 18th November, 2024) Assignment 1:   Link Assignment 2:   Link Week Date Lecture Slides Lab Slides Additional Resources 1 Week 1 2 Week 2 3 Week 3 & 4 Lab Experiments 4 Week 5 5 Week 6 6 Week 7 7...
Read more

SPY 2026 Professional Cybersecurity

This course is based on CND. The Certified Network Defender (CND) program is designed to train students in defending, detecting, and responding to network threats and to be familiar with network components, traffic, reliability, and utilization, network topology, system location, and security policies, among other things. Students will learn network defense fundamentals, the application of network security controls, protocols, perimeter appliances, secure IDS, VPN and firewall configuration. They will then learn the intricacies of network traffic signature, analysis and vulnerability scanning which will help them when they design greater network security policies and successful incident response plans. Mid Term 1: 8th October, 2024 Mid Term 2: 19th November, 2024 (Assignment Due Date: 19th November, 2024 ) Assignment 1:   Link Assignment 2:   Link Week Date Lecture Slides Lab Slides Additional Resources 1 Week 1 2 Week 2 3 Week 3 Lab Experiments 4 Week 4 5 Week 5 6 Week 6...
Read more