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.
- 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): firstname.lastname@example.org ; 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.
|1||Provide your email in lect#1||Oct. 8th, 2018|
Introduction to Databases
Start Microsoft Access: Environment Setup and GUI
|2||Database System Concepts and Architecture||DBMS Access – Experiencing Database System Concepts and Architecture||Chapter 2|
|3||The Relational Data Model and Relational|
|Tables and Attributes||Chapter 3|
|4||Basic SQL||Starting SQL||Chapter 4|
|5||More SQL||Practicing Complex Queries, Triggers, Views, and Schema Modification||Chapter 5|
|6||Data Modeling Using the Entity-Relationship (ER) Model||Creating Course Database Project Schema and Instances||Chapter 7|
|7||Tables and Keys||Create Tables, Properties of Tables, Types of Keys||Value|
|8||Forms||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 )
|12||Macros||Concept of Macros and their creation|
|13||Web-Based Database||Microsoft 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:
- 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:
- Quick Guides:
- Youtube channels: