{"id":5,"date":"2019-05-18T14:45:46","date_gmt":"2019-05-18T14:45:46","guid":{"rendered":"http:\/\/173.249.1.102\/~ismaelali\/?page_id=5"},"modified":"2019-05-27T20:17:36","modified_gmt":"2019-05-27T20:17:36","slug":"introduction-to-databases","status":"publish","type":"page","link":"https:\/\/ismaelali.net\/?page_id=5","title":{"rendered":"Introduction to DataBases"},"content":{"rendered":"\n<p style=\"text-align:left\"><strong>Course Description:<\/strong><br>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&nbsp;tasks\/steps.<\/p>\n\n\n\n<ul class=\"wp-block-gallery columns-2 is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\"><li class=\"blocks-gallery-item\"><figure><img loading=\"lazy\" decoding=\"async\" width=\"260\" height=\"323\" src=\"http:\/\/173.249.1.102\/~ismaelali\/wp-content\/uploads\/2019\/05\/61OuEff3oKL._SX258_BO1204203200_.jpg\" alt=\"\" data-id=\"72\" data-link=\"http:\/\/173.249.1.102\/~ismaelali\/introduction-to-databases\/61oueff3okl-_sx258_bo1204203200_\/\" class=\"wp-image-72\" srcset=\"https:\/\/ismaelali.net\/wp-content\/uploads\/2019\/05\/61OuEff3oKL._SX258_BO1204203200_.jpg 260w, https:\/\/ismaelali.net\/wp-content\/uploads\/2019\/05\/61OuEff3oKL._SX258_BO1204203200_-241x300.jpg 241w\" sizes=\"auto, (max-width: 260px) 100vw, 260px\" \/><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><img loading=\"lazy\" decoding=\"async\" width=\"397\" height=\"499\" src=\"http:\/\/173.249.1.102\/~ismaelali\/wp-content\/uploads\/2019\/05\/51PoUwM0iL._SX395_BO1204203200_.jpg\" alt=\"\" data-id=\"73\" data-link=\"http:\/\/173.249.1.102\/~ismaelali\/introduction-to-databases\/51pouwm0il-_sx395_bo1204203200_\/\" class=\"wp-image-73\" srcset=\"https:\/\/ismaelali.net\/wp-content\/uploads\/2019\/05\/51PoUwM0iL._SX395_BO1204203200_.jpg 397w, https:\/\/ismaelali.net\/wp-content\/uploads\/2019\/05\/51PoUwM0iL._SX395_BO1204203200_-239x300.jpg 239w\" sizes=\"auto, (max-width: 397px) 100vw, 397px\" \/><\/figure><\/li><\/ul>\n\n\n\n<p><strong>Course Info:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Lectures<\/strong>&nbsp;in&nbsp;Room# &nbsp; &nbsp;; Wednesday @8:10am-10:30am&nbsp;<\/li><li><strong>Lab<\/strong># &nbsp; ; &nbsp;in&nbsp;Wednesday @&nbsp;10:30 am &#8211; 1:30 pm&nbsp;<\/li><li><strong>Office Hours<\/strong>: Monday 10 Am &#8211; 12 PM<\/li><li><strong>Teaching Assistants\/Contacts<\/strong>: Ahmed A.<\/li><li><strong>\u200bAppointment (use email):<\/strong>&nbsp;ismael.ali@uoz.edu.krd ;&nbsp;emailing&nbsp;Form in Contact page<\/li><li><strong>Way of Contact:&nbsp;<\/strong><ul><li>Announcement will be on this page.<\/li><li>Whenever needed,&nbsp;I will&nbsp;broadcast emails to you.&nbsp;<\/li><li>Make sure your email are working properly and given to me.<\/li><li>\u200bCheck your emails and this page&nbsp;frequently!&nbsp;for lecture notes + assignment and lab materials + due dates &#8230; etc.<\/li><\/ul><\/li><\/ul>\n\n\n\n<p><strong>Important Dates&nbsp;<\/strong>(tentative)<strong>:<\/strong><strong>&nbsp;TBA<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Midterm 1: Dec 10th<\/li><li>Course Projects&nbsp;(steps\/due dates):<ul><li>Project proposals due<\/li><li>Project review meeting<\/li><li>Draft paper\/report due<\/li><li>Project progress 1st presentations<\/li><li>Project progress 2nd presentations<\/li><li>Project progress 3rd presentations<\/li><li>Project progress 4th presentations<\/li><li>(before the final exam): Final Submission Due (paper\/report + Code)<\/li><li>Project final presentations<\/li><\/ul><\/li><li>Final Course Exam: May 25th<\/li><li>\u200bNote:&nbsp;<em>course deadlines are solid\/exceptions need solid verification.<\/em>\u200b<\/li><\/ul>\n\n\n\n<p>\u200b<strong>Announcements:<\/strong><\/p>\n\n\n\n<table class=\"wp-block-table\"><tbody><tr><td>#<\/td><td>Announcement<\/td><td>Date<\/td><\/tr><tr><td>1<\/td><td>Provide your email in lect#1<\/td><td>Oct. 8th, 2018<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p>\u200b<strong>Course&nbsp;Schedule:<\/strong><\/p>\n\n\n\n<table class=\"wp-block-table aligncenter is-style-stripes\"><tbody><tr><td>Week<\/td><td>Topic(s)<\/td><td>Lab Work<\/td><td>Notes<\/td><\/tr><tr><td>1<\/td><td>Course Introduction<br>\u200bIntroduction to Databases&nbsp;<\/td><td>Lab Policy<br>Start Microsoft Access:&nbsp;Environment Setup and GUI<\/td><td>Chapter 1<\/td><\/tr><tr><td>2<\/td><td>Database System Concepts&nbsp;and Architecture<\/td><td>DBMS Access &#8211; Experiencing Database System Concepts and Architecture<\/td><td>Chapter 2<\/td><\/tr><tr><td>3<\/td><td>The Relational Data Model and Relational<br>Database Constraints<\/td><td>Tables and Attributes<\/td><td>Chapter 3<\/td><\/tr><tr><td>4<\/td><td>Basic SQL<br><\/td><td>Starting SQL<\/td><td>Chapter 4<\/td><\/tr><tr><td>5<\/td><td>More SQL<\/td><td>Practicing&nbsp;Complex Queries, Triggers, Views, and&nbsp;Schema Modification<br><\/td><td>Chapter 5<\/td><\/tr><tr><td>6<\/td><td>Data Modeling Using the&nbsp;Entity-Relationship (ER) Model<\/td><td>Creating Course Database Project Schema and Instances<\/td><td>Chapter 7<\/td><\/tr><tr><td>7<\/td><td>Tables and Keys<\/td><td>Create Tables, Properties of Tables, Types of&nbsp;Keys<\/td><td>Value<\/td><\/tr><tr><td>8<\/td><td>Forms<\/td><td>&nbsp;Creating Forms,&nbsp;Design Forms,&nbsp;Form Types, Tools and Properties<\/td><td><\/td><\/tr><tr><td>9<\/td><td>&nbsp;Functional Dependency , Normalization for Relational Database<\/td><td>&nbsp;First Normal Form ( 1NF )<br>&nbsp;Second Normal Form ( 2NF )<br>&nbsp;Third Normal Form ( 1NF )<br><br><\/td><td>Chapter 15<\/td><\/tr><tr><td>10<\/td><td>Queries<\/td><td>SQL, Quering<\/td><td><\/td><\/tr><tr><td>11<\/td><td>Reports<\/td><td>SQL, Reporting<\/td><td><\/td><\/tr><tr><td>12<\/td><td>Macros<\/td><td>Concept of Macros and their creation<\/td><td><\/td><\/tr><tr><td>13<\/td><td>Web-Based Database<\/td><td>Microsoft SharePoint&nbsp;<\/td><td><\/td><\/tr><\/tbody><\/table>\n\n\n\n<p>Note:&nbsp;<strong>Lecture notes are partially based on the slides of the textbook below.<\/strong><br><strong>\u200bHomework:<\/strong>Students will be provided with small weekend&nbsp;assigments and will be graded on the understanding and knowledge of the students for the given week material and earlier material.<\/p>\n\n\n\n<p><strong>Projects:<\/strong>Students will perform a number of individual and group course projects for different Data Mining tasks, like pre-processing, or cluster analysis.&nbsp;<\/p>\n\n\n\n<p><strong>Grading&nbsp;<\/strong>(tentative) 100%<strong>:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Homework Assignments:&nbsp;<\/strong>30% (including a weekly small project 10%)<\/li><li><strong>Class Participation\/Effort:&nbsp;<\/strong>5%<\/li><li><strong>Midterm #1:&nbsp;<\/strong>10%<\/li><li><strong>Midterm #2:&nbsp;<\/strong>10%<\/li><li><strong>Course Project &amp; Presentation:<\/strong>&nbsp;25% (presentation counts 10%)\u200b<ul><li><strong>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.<\/strong><\/li><\/ul><\/li><li><strong>Final Course Exam:&nbsp;<\/strong>20%<\/li><li>NOTE:&nbsp;<strong>all submission online.<\/strong><\/li><\/ul>\n\n\n\n<p><strong>Books and Other&nbsp;Resourses:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Books:&nbsp;<\/strong><ul><li><strong>Textbook:&nbsp;Fundamentals of Database Systems,&nbsp;7th Edition.&nbsp;By:&nbsp;<\/strong><strong>R. Elmasri and S. Navathe.&nbsp;Pearson<\/strong>.<\/li><li><strong>Reference:&nbsp;<\/strong>Database System Concepts,&nbsp;Sixth Edition. By:&nbsp;Avi Silberschatz,&nbsp;Henry F. Korth,&nbsp;S. Sudarshan.<\/li><\/ul><\/li><li><strong>\u200bRecommended Learning Materials:<\/strong><ul><li><strong>Youtube channels:<\/strong><ol><li>\u200bhttps:\/\/www.youtube.com\/watch?v=IarzvwTijwk&amp;list=PL9E67A2E6DC4676B6<\/li><li>https:\/\/www.youtube.com\/watch?v=vIoRXnoDn6k&amp;list=PLS6wUbXLdQc7dQv4UbttsjUvgj_dCl7hl<\/li><\/ol><\/li><li><strong>\u200b<\/strong><strong>Quick Guides:&nbsp;<\/strong><ul><li>https:\/\/quicksourcelearning.com\/samples\/978193210460.pdf<\/li><li>https:\/\/www.cevmultimedia.com\/atomsville\/cityofatomsville\/CheatSheetPDFs\/Access%202007%20Cheat%20Sheet.pdf<\/li><li>https:\/\/www.dummies.com\/software\/microsoft-office\/access\/access-2007-for-dummies-cheat-sheet\/<\/li><li><strong>\u200b\u200b\u200b\u200b\u200b\u200b\u200b\u200b<\/strong>http:\/\/www.customguide.com\/cheat_sheets\/access-2007-quick-reference.pdf<\/li><li>https:\/\/www.computerworld.com\/s\/article\/9010482\/\u200b<\/li><\/ul><\/li><\/ul><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>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&nbsp;tasks\/steps. Course Info: Lectures&nbsp;in&nbsp;Room# &nbsp; &nbsp;; Wednesday @8:10am-10:30am&nbsp; Lab# &nbsp; ; &nbsp;in&nbsp;Wednesday @&nbsp;10:30 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/ismaelali.net\/?page_id=5\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Introduction to DataBases&#8221;<\/span><\/a><\/p>\n","protected":false},"author":6,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-5","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/ismaelali.net\/index.php?rest_route=\/wp\/v2\/pages\/5","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ismaelali.net\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ismaelali.net\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ismaelali.net\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/ismaelali.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5"}],"version-history":[{"count":3,"href":"https:\/\/ismaelali.net\/index.php?rest_route=\/wp\/v2\/pages\/5\/revisions"}],"predecessor-version":[{"id":74,"href":"https:\/\/ismaelali.net\/index.php?rest_route=\/wp\/v2\/pages\/5\/revisions\/74"}],"wp:attachment":[{"href":"https:\/\/ismaelali.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}