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): ismael.ali@uoz.edu.krd ; 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.
Announcements:
| # | Announcement | Date |
| 1 | Provide your email in lect#1 | Oct. 8th, 2018 |
Course Schedule:
| Week | Topic(s) | Lab Work | Notes |
| 1 | Course Introduction Introduction to Databases | Lab Policy Start Microsoft Access: Environment Setup and GUI | Chapter 1 |
| 2 | Database System Concepts and Architecture | DBMS Access – Experiencing Database System Concepts and Architecture | Chapter 2 |
| 3 | The Relational Data Model and Relational Database Constraints | 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 ) | Chapter 15 |
| 10 | Queries | SQL, Quering | |
| 11 | Reports | SQL, Reporting | |
| 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:
- 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:
- https://www.youtube.com/watch?v=IarzvwTijwk&list=PL9E67A2E6DC4676B6
- https://www.youtube.com/watch?v=vIoRXnoDn6k&list=PLS6wUbXLdQc7dQv4UbttsjUvgj_dCl7hl
- Quick Guides:
- https://quicksourcelearning.com/samples/978193210460.pdf
- https://www.cevmultimedia.com/atomsville/cityofatomsville/CheatSheetPDFs/Access%202007%20Cheat%20Sheet.pdf
- https://www.dummies.com/software/microsoft-office/access/access-2007-for-dummies-cheat-sheet/
- http://www.customguide.com/cheat_sheets/access-2007-quick-reference.pdf
- https://www.computerworld.com/s/article/9010482/
- Youtube channels: