Introduction to DataBases

Course Description:
This course introduces students to the basic and fundamental concepts of Databases with real-world applications, to practice theoretical concepts with a problem-solving approach. The students will have group-based projects. They will also learn SQL language and use it for various Database design tasks/steps.

Course Info:

  • Lectures in Room#    ; Wednesday @8:10am-10:30am 
  • Lab#   ;  in Wednesday @ 10:30 am – 1:30 pm 
  • Office Hours: Monday 10 Am – 12 PM
  • Teaching Assistants/Contacts: Ahmed A.
  • ​Appointment (use email): ; emailing Form in Contact page
  • Way of Contact: 
    • Announcement will be on this page.
    • Whenever needed, I will broadcast emails to you. 
    • Make sure your email are working properly and given to me.
    • ​Check your emails and this page frequently! for lecture notes + assignment and lab materials + due dates … etc.

Important Dates (tentative): TBA

  • Midterm 1: Dec 10th
  • Course Projects (steps/due dates):
    • Project proposals due
    • Project review meeting
    • Draft paper/report due
    • Project progress 1st presentations
    • Project progress 2nd presentations
    • Project progress 3rd presentations
    • Project progress 4th presentations
    • (before the final exam): Final Submission Due (paper/report + Code)
    • Project final presentations
  • Final Course Exam: May 25th
  • ​Note: course deadlines are solid/exceptions need solid verification.


1Provide your email in lect#1Oct. 8th, 2018

Course Schedule:

WeekTopic(s)Lab WorkNotes
1Course Introduction
​Introduction to Databases 
Lab Policy
Start Microsoft Access: Environment Setup and GUI
Chapter 1
2Database System Concepts and ArchitectureDBMS Access – Experiencing Database System Concepts and ArchitectureChapter 2
3The Relational Data Model and Relational
Database Constraints
Tables and AttributesChapter 3
4Basic SQL
Starting SQLChapter 4
5More SQLPracticing Complex Queries, Triggers, Views, and Schema Modification
Chapter 5
6Data Modeling Using the Entity-Relationship (ER) ModelCreating Course Database Project Schema and InstancesChapter 7
7Tables and KeysCreate Tables, Properties of Tables, Types of KeysValue
8Forms Creating Forms, Design Forms, Form Types, Tools and Properties
9 Functional Dependency , Normalization for Relational Database First Normal Form ( 1NF )
 Second Normal Form ( 2NF )
 Third Normal Form ( 1NF )

Chapter 15
10QueriesSQL, Quering
11ReportsSQL, Reporting
12MacrosConcept of Macros and their creation
13Web-Based DatabaseMicrosoft SharePoint 

Note: Lecture notes are partially based on the slides of the textbook below.
​Homework:Students will be provided with small weekend assigments and will be graded on the understanding and knowledge of the students for the given week material and earlier material.

Projects:Students will perform a number of individual and group course projects for different Data Mining tasks, like pre-processing, or cluster analysis. 

Grading (tentative) 100%:

  • Homework Assignments: 30% (including a weekly small project 10%)
  • Class Participation/Effort: 5%
  • Midterm #1: 10%
  • Midterm #2: 10%
  • Course Project & Presentation: 25% (presentation counts 10%)​
    • Towards the end of the course you will work on a data-mining project. The goal of the project is to go through the complete knowledge discovery process to answer one or more questions you have about a topic of your own choosing. You will acquire the data, formulate a question of interest, perform the data analysis, and communicate the results.
  • Final Course Exam: 20%
  • NOTE: all submission online.

Books and Other Resourses:

  • Books: 
    • Textbook: Fundamentals of Database Systems, 7th Edition. By: R. Elmasri and S. Navathe. Pearson.
    • Reference: Database System Concepts, Sixth Edition. By: Avi Silberschatz, Henry F. Korth, S. Sudarshan.
  • ​Recommended Learning Materials:
    • Youtube channels:
      1. ​
    • Quick Guides: 
      • ​​​​​​​​