انت هنا الان : شبكة جامعة بابل > موقع الكلية > نظام التعليم الالكتروني > مشاهدة المحاضرة

استمارة خاصة لاطلاع الطلبة على المقرر

الكلية كلية تكنولوجيا المعلومات     القسم قسم شبكات المعلومات     المرحلة 2
أستاذ المادة انوار جعفر موسى جعفر       04/10/2012 15:55:34
Upon completion of this course, the student should be able to:
1. Explain database approach: its advantages, disadvantages, Evolution, and applications, define the basic terms in database management systems. Explain the advantages of database approach compared to conventional file processing. Identify categories of database. Describe the components of database environment . Identify costs and risks of the database approach. Appreciate the need of a data model
2. Identify the role of data model in database system Development. Extract the business rules, Differentiates between various data models, namely: Hierarchical, Network, Relational, Object Oriented.
3. Describe the three level schema architecture for Database.
4. Identify characteristics of a Relational Table, identify key terms in data modeling, Define integrity rules.
5. Apply relational set operators on database relations.
6. Understand what is Data dictionary and system catalog in database systems, Use various relationships in relational database model.
7. Eliminate data redundancy.
8. Understand indexes in database systems
9. Define the key terms in EER modeling (Entities, Attributes, Domains, Identifiers, Relationships), Develop ER model ,Transform ER model into Database.
10. Identify the need for normalization, Apply the normalization process in database design.
11. Apply demoralization when it is needed
12. Create database tables, Create database constraints
13. Add, modify, and delete data, Retrieve data
14. Design a database model.
15. Create database using SQL language, Query single database table using SQL

Database Systems
Introducing the Database and the DBMS
Why Database Design is important
Problems with File System Data Management
Database System Environment Week 1
Data Models
The importance of Data Models
Data model basic building blocks
Business rules Week 2
Data Models
Types of Data Models and their evolution Week 3
Data Models
Degrees of data abstraction Week 4
The Relational Database Model
A logical view of data
The Relational Model’s basic components
Integrity rules Week 5
The Relational Database Model
Relational Algebra
Relational set Operators
Data dictionary and System catalog Week 6
The Relational Database Model
Relationships within the relational database
Data redundancy
Indexes Week 7
The Entity Relationship (ER) Model
The main characteristics of ER model Week 8
The Entity Relationship (ER) Model
Developing an ER diagram
ER relationships implementation
Database design challenges Week 9


المادة المعروضة اعلاه هي مدخل الى المحاضرة المرفوعة بواسطة استاذ(ة) المادة . وقد تبدو لك غير متكاملة . حيث يضع استاذ المادة في بعض الاحيان فقط الجزء الاول من المحاضرة من اجل الاطلاع على ما ستقوم بتحميله لاحقا . في نظام التعليم الالكتروني نوفر هذه الخدمة لكي نبقيك على اطلاع حول محتوى الملف الذي ستقوم بتحميله .