Welcome to GC 311 Database Concepts First Semester

Welcome to GC 311 Database Concepts First Semester 1437/1438 H

Getting to know me § Instructor: Huda Alomair • Office Location: BLd 26 , level # 1 , ward A , office 7 • Email Address: halomair@ksu. edu. sa

Course Description

Course Description § Characteristics of the database approach. § Database concepts and architecture; Data models, schemas and instances; Program data independence, Database languages and interfaces. § Data models for database systems; The E-R DM, Relational DM and Relational Algebra. § Relational model constraints; Domain, key, and integrity constraints. § SQL-relational DB language; Data definition, queries, update statements, and views in SQL. § Database design; functional dependencies, Normal forms.

What will we learn? We will learn HOW to Design and implement Normalized Databases

Course Syllabus § Introduction to Databases and Database Environment § Entity Relationship and Enhanced Entity Relationship Modeling § Relational Model § Relational Algebra § SQL: Data Manipulation Language § SQL: Data Definition Language § Normalization § Methodology – Conceptual Database Design § Methodology – Logical Database Design § Methodology – Physical Database Design § Object Oriented DBMSs § Object Relational DBMSs

Assessment & Course Policies

Policy § No phone/chatting during class time, any violation will be asked to leave the classroom. § No talking or disturbing others during the class § It is better to contact me using “KSU-email”, form other domain , your name it should be clear , others will be deleted. § Email related to Labs should be sent to TA.

Assessment Methods & Grading Scheme Subject Date Grade Assignments , lab quizzes All weeks 10 % Quiz 1 Mon 30Sep 10 % Mid # 1 Mon 7Oct 20% Mid #2 Mon 11Nov 20 % Final Exam 40 % Total 100 %

Exams & Classes Policies § You will be able to access the class 10 minutes after the lecture starts, however, you will be marked absent. § Mobiles should be turned off/silent during class/exam. § NO make up exams, exceptions will be considered with evidence and the approval of the depatment committee. § No changes in the announced exam dates after 3 rd week. § Exams are closed book so do not bring any external notes or papers. § The using of dictionary is allowed. § More than one answer is not acceptable for a single question unless admitted by instructor. § Academic dishonesty is strictly prohibited, and both parties will be penalized.

Assignments Policies § No sheet will be accepted after due date. § Cheating is prohibited; so if we caught any identical assignments both will take 0.

Course Resources

Textbooks § “Database Systems: A Practical Approach to Design, Implementation and Management. ” Thomas Connolly, Carolyn Begg. 5 th Edition, Addison-Wesley, 2009.

Required Software § Database Management System Ø Oracle SQL § ER Diagram Tool Ø Microsoft Visio 2007 -2010 or upper ( Free trial – 60 days ) Ø OR Easy Entity Relationship Diagram Software from Smart draw.

How to Study for this Course § You are advised to follow the text book for this course during the entire semester. In case the instructor is teaching some extra topics which are not covered in the text book, photocopy material will be provided. § Daily studying and doing your course work by yourself lead to successful.