المقرر لمادة قواعد البيانات 2

Goal:
1. Identify the need for normalization, Apply the normalization process in database design.
1. Apply demoralization when it is needed
2. Identify the Transaction Management and Concurrency Control.
This module provides data management and database systems. Deals with the idea of database systems, from the viewpoint of the user. The goal of This module presents the basic concepts of database systems, surrounded the students using the current relational database, and the structure of a solid foundation for advanced studies in the area of database systems.

Reerances:
Coronel Morris Rob ,Database Principles: Fundamentals Of Design Implementation And Management 9e
1. R. Elmasri, and S. Navathe, Benjamin Cummings, “Fundamentals of Database Systems”, 2000
Theory:
Functional Dependencies, Entity-Relationship Model
Normalization of Database Tables ,The role of Normalization in Database
Normalization, 1NF,2NF
3NF
Higher-Level Normal Forms

Evaluating Transaction Results, Transaction Properties
First Exam
Transaction Management with SQL, The Transaction Log
Concurrency Control
Concurrency Control with Locking Methods
Second Exam
Deadlocks
Lock types
Concurrency Control with Time stamping Methods
Concurrency Control with Optimistic Methods
Database Recovery Management
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Practical
Write Program in PL\Sql
Make database in
Microsoft SQL Server Database File SqlClient))
How to make connection between database and C# environment
Query – part 1
Add Constraints – part 1
Add Constraints – part 2
Make View
Data types in C#
Write program
Types of SQL
Loop Statement
Condition Statement
First Exam

Introduction

Complete system
PL/SQL + SQL +Developer Part1
Second Exam