1 / 21

Welcome to IT222 Database Principles

Welcome to IT222 Database Principles. Getting to know me. Getting to know me. Instructor: L.Hanan Al Tamimi Office Location: BLd 6 ,  level # 3 , Room # 71 ( 6T71 ) Office Hours: Sunday, Tuesday, Thursday (12-1) Email Address: htamimi@ksu.edu.sa. Course Description.

quynh
Download Presentation

Welcome to IT222 Database Principles

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Welcome to IT222 Database Principles Second Semester 1434/1435 H

  2. Getting to know me

  3. Getting to know me • Instructor: L.Hanan Al Tamimi • Office Location: BLd 6 ,  level # 3 , Room # 71 (6T71) • Office Hours: Sunday, Tuesday, Thursday (12-1) • Email Address: htamimi@ksu.edu.sa

  4. Course Description

  5. 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. • Introduction to OO databases.

  6. Prerequisite Courses CSC 111 You have to pass CSC111 to know: • Problem Solving • An Overview of Computers and Programming Languages • Introduction to Objects and Input / Output • Control Structure (Selection Structure) • Control Structure (Repetition) • User defined Methods and arrays

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

  8. 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

  9. Course Learning Outcomes  This course requires the student to demonstrate the following: • Define data models for database systems, database schema and database instances. • Recall Relational Algebra concepts, and translate intoqueries and vice versa. • Identify Structure Query Language statements used in creation and manipulation of database. • Define functional dependencies and normalization concepts. • Identify the modeling methodologies including conceptual(through Entity Relationship), logical, and physical  model. • Develop and evaluate a real database application using a database management system.

  10. Assessment & Course Policies

  11. 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. • In the subject line: add course number, section number. • All email should be written in easy way. • Email related to Labs should be sent to TA.

  12. Assessment Methods & Grading Scheme

  13. Exams Dates

  14. Exams & Classes Policies • Attend in your registered sections of lectures and labs as appear in your schedule. NO changes will be allowed. • Mobiles should be turned off/silent during class/exam. • Try to arrive early to your class/exam room. • NO make up exams, exceptions will be considered with evidence and the approval of the exam committee. • 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. • Academic dishonesty is strictly prohibited, and both parties will be penalized.

  15. Assignments Policies • Assignments will be released every week (Wednesday) and should be handed in the next (Sunday until 12:15 p.m. ) . • No sheet will be accepted after that time. • Assignments solution should be Submitted with the filled Cover Page available on the website.( No Cover will lost -1 from total Grade ) • Cheating is prohibited; so if we caught any identical assignments both will take -10.

  16. NOTE • Consider the lecture section number in all course work; instead of the lab section number. • Serial number is important as well, and will be announced after registration week.

  17. Course Resources

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

  19. 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.

  20. Course Blog http://ksuit222.wordpress.com • Reading announcements. • Obtaining course information. • Instructors contact details. • Course Slides, Assignments. • Lab materials. • Exams dates and grades. • Wordpressprovide version for smart phone. Go back frequently to course blog.

  21. 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 Homework by yourself lead to successful . How to Study for this Course

More Related