King Saud University
  Help (new window)
Search


Guidelines_English_Final
تحميل الدليل التدريبي

أسئلة شائعة


  203 Haseb 

Database System Basics

Course Information

Course Title

Database System Basics

Course Number

203 Haseb

Level

3

Credit Hours

Prerequisites

101 Haseb: Introduction to computers

201 Haseb: Visual Programming

Classroom Location

9A2

Days and Hours class

Sat., Mon., Wed. 11:00 - 11:50 AM.

 

Instructor Information

Full Name

Baghdadi Zitouni

Title

Lecturer

Office Location

527

Office Phone number

064311197 - 527

Office Hours

Mon., Tue. 1:00 – 3:00 PM

Wed. 9:11 AM

Email

b_zitouni@yahoo.fr

 

Textbook(s)

Title

Fundamentals of Database systems

Author (s)

R. Elmasri & S.B. Navathe

Date (and Edition)

2003

Availability in College Library

Available

 

Supplementary References

1. C. Date, "An introduction to Database Systems", Addison Wesley, 2003.

2. stanford.edu/class/cs145

 

Course Objectives

Upon successful completion of this course, students will be able to:

- Understand the basic concepts of databases

- Understand the databases design process using Entity-Relationship Diagrams

- Understand the basics of SQL.

  

Instructional Methods

·        Conferences

·        Homeworks.

 

Course Schedule

Week

Topics

1

Database Environment

2

Relational Databases

3, 4, 5

Entity-Relationship Diagrams 

6

Conversion from ERD to Relational Model

Midterm Exam1

7, 8

Normal forms

9, 10, 11

Relational Algebra

Midterm Exam2

12, 13, 14

SQL Basics

Final Exam

 

Assessment Policy

Assignments, Attendance

10%

Midterm Exam1

20%

Midterm Exam2

20%

Final Exam

50%

 

 

 203 Haseb - Lecture Notes

Haseb124.pdfHaseb124بغدادى محمد على الزيتونى
203Haseb.Lecture5.Normal Forms.pdf203Haseb.Lecture5.Normal Formsبغدادى محمد على الزيتونى
203Haseb.Lecture4.Conversion ERD-Relational Model.pdf203Haseb.Lecture4.Conversion ERD-Relational Modelبغدادى محمد على الزيتونى
203Haseb.Lecture3.Entity-Relationship Diagrams.pdf203Haseb.Lecture3.Entity-Relationship Diagramsبغدادى محمد على الزيتونى
203Haseb.Lecture2.Relational Databases.pdf203Haseb.Lecture2.Relational Databasesبغدادى محمد على الزيتونى
203Haseb.Lecture1.Introduction to Databases.pdf203Haseb.Lecture1.Introduction to Databasesبغدادى محمد على الزيتونى
Relional Algebra.pdfRelional Algebraبغدادى محمد على الزيتونى
Database Basics.pdfDatabase Basicsبغدادى محمد على الزيتونى
Introdution to Databases.pdfIntrodution to Databasesبغدادى محمد على الزيتونى
Introduction To SQL.pdfIntroduction To SQLبغدادى محمد على الزيتونى
Entity-Relationship Model.pdfEntity-Relationship Modelبغدادى محمد على الزيتونى
Class and ERD.pdfClass and ERDبغدادى محمد على الزيتونى
SQL Tutorial.pdfSQL Tutorialبغدادى محمد على الزيتونى
Database Normalization.pdfDatabase Normalizationبغدادى محمد على الزيتونى
Producing 3NF Tables.pdfProducing 3NF Tablesبغدادى محمد على الزيتونى

 203Haseb - Previous Exams

203Haseb_SecondExam_26271.pdf203Haseb_SecondExam_26271بغدادى محمد على الزيتونى
203Haseb_FinalExam_27282.pdf203Haseb_FinalExam_27282بغدادى محمد على الزيتونى
203Haseb_FirstExam_28291.pdf203Haseb_FirstExam_28291بغدادى محمد على الزيتونى
King   Saud University. All rights reserved, 2007 | Disclaimer | CiteSeerx