Course Description
Course Aims and objectives
Course outlines
Text book and references
Prerequisite
Grading policy
Instructors and office hours
Syllabus
Time table
Lecture Notes
Attached Files
Previous Exams
Course Description
| fundemental of db systems |
Course Aims And Objective
| Introducing the fundamental concepts necessary for designing, using, and implementing database systems and applications. The goal of this course is for students to become well-grounded in basic concepts necessary for understanding db and their users, DBMS concepts, architecture , the concepts of the Entity Relationship(ER) model, the data abstraction and semantic modeling concepts leading to EER data model, describe the basic relational model, its integrity constraints and update operations, and the operation of relational algebra, describe relational schema design, and it covers the normalization and functional dependency algorithm.; |
Course Outline
| Databases and Database Users | |
| Introduction An Example Characteristics of the Database Approach Actors on the Scene Workers behind the Scene Advantages of using a DBMS Implications of the Database Approach When not to use a DBMS | |
| Database System Concepts and Architecture | |
| Data Models, Schemas, and Instances DBMS Architecture and Data Independence Database Languages and Interfaces The Database System Environment Classification of Database Management Systems Using High-Level Conceptual Data Models for Database Design An Example Database Application | |
| Data Modelling Using the Entity-Relationship Model | |
| Entity Types, Entity Sets, Attributes, and Keys Relationships, relationship Types, Roles, and Structural Constraints Weak Entity Types Refining the ER Design for the COMPANY Database ER Diagrams, Naming Conventions, and Design Issues | |
| The Relational Data Model, Relational Constraints, and the | |
| Relational Model Concepts Relational Constraints and Relational Database Schemas Update Operations and Dealing with Constraint Violations Basic Relational Algebra Operations Additional Relational Operations | |
| ER-and-EER-to-Relational Mapping, and Other Relational | |
| Relational Database Design Using ER-to-Relational Mapping Mapping EER Model Concepts to Relations The Tuple Relational Calculus The Domain Relational Calculus | |
| Functional Dependencies and Normalization for Relational | |
| Informal Design Guidelines for Relation Schemas Functional Dependencies Normal Forms Based on Primary Keys General Definitions of Second and Third Normal Forms Boyce-Codd Normal Form | |
| Enhanced Entity-Relationship and object Modeling | |
| Subclasses, Super classes, and Inheritance Specialization and Generalization. Constraints and Characteristics of Specialization and Generalization Modeling of UNION Types Using Categories An Example UNIVERSITY EER Schema and Formal Definitions for the EER Model. Conceptual Object Modeling Using UML Class Diagram. Relationship Types of a Degree Higher Than Two. Data Abstraction and Knowledge Representation Concepts | |
| Chapter 1: Databases and Database Users | |
| • Introduction • An Example • Characteristics of the Database Approach • Actors on the Scene • Workers behind the Scene • Advantages of using a DBMS • Implications of the Database Approach • When not to use a DBMS | |
| Chapter 2: Database System Concepts and Architecture | |
| • Data Models, Schemas, and Instances • DBMS Architecture and Data Independence • Database Languages and Interfaces • The Database System Environment • Classification of Database Management Systems | |
| Chapter 3: Data Modeling Using the Entity-Relationship Model | |
| • Using High-Level Conceptual Data Models for Database Design • An Example Database Application • Entity Types, Entity Sets, Attributes, and Keys • Relationships, relationship Types, Roles, and Structural Constraints • Weak Entity Types • Refining the ER Design for the COMPANY Database • ER Diagrams, Naming Conventions, and Design Issues | |
| Chapter 4: Enhanced Entity-Relationship and object Modeling | |
| • Subclasses, Super classes, and Inheritance • Specialization and Generalization. • Constraints and Characteristics of Specialization and Generalization • Modeling of UNION Types Using Categories • An Example UNIVERSITY EER Schema and Formal Definitions for the EER Model. • Conceptual Object Modeling Using UML Class Diagram. • Relationship Types of a Degree Higher Than Two. • Data Abstraction and Knowledge Representation Concepts. | |
| Chapter 7:The Relational Data Model, Relational Constraints, and the Relational Algebra | |
| • Relational Model Concepts • Relational Constraints and Relational Database Schemas • Update Operations and Dealing with Constraint Violations • Basic Relational Algebra Operations • Additional Relational Operations | |
| Chapter 9: ER-and-EER-to-Relational Mapping, and Other Relational Languages | |
| • Relational Database Design Using ER-to-Relational Mapping • Mapping EER Model Concepts to Relations • The Tuple Relational Calculus • The Domain Relational Calculus | |
| Chapter 14: Functional Dependencies and Normalization for Relational Databases | |
| • Informal Design Guidelines for Relation Schemas • Functional Dependencies • Normal Forms Based on Primary Keys • General Definitions of Second and Third Normal Forms • Boyce-Codd Normal Form | |
| Chapter 8: SQL- The Relational Database Standard | |
| • Data Definition, Constraints, and schema changes on SQL2 • Basic Queries in SQL • More Complex SQL Queries • Insert, Delete, and update Statements in SQL • Views(Virtual tables) in SQL • Specifying General Constrains as Assertion • Additional Features of SQL. |
Text book and references
| The Main Book | |
| Title | Fundamentals of Database Systems, Elmasri & Navathe |
| Author(s) | |
| Edition | 4th |
| Publisher | Addison Wesley, 2004 |
901240
Grading Policy
| Activity | Weight |
| الامتحان الاول | 20 |
| الامتحان الثاني | 20 |
| المختبر و أعمال الفصل | 10 |
| الامتحان النهائي | 50 |
Instructors And Office Hours
| The Instructors of the Course | |
| Name: | خالد محمد عبدالرحمن بطيحه |
| Office Hours: | |
| Office Phone: | |
| Instrcutor Mail: | |
| Name: | محمد سعيد منصور البشير |
| Office Hours: | Sunday, Tuesday, (9-10), (11-12) Monday ,Wednesday (12:1:30) |
| Office Phone: | (962) 2 6297000 ext. 3384 |
| Instrcutor Mail: | batihakhalid@aabu.edu.jo |
Miscellaneous
Time Table
| Subject | Hours | |
| Introduction An Example Characteristics of the Database Approach Actors on the Scene Workers behind the Scene Advantages of using a DBMS Implications of the Database Approach When not to use a DBMS | 5 | |
| Data Models, Schemas, and Instances DBMS Architecture and Data Independence | 3 | |
| Database Languages and Interfaces The Database System Environment Classification of Database Management Systems | 1 | |
| Using High-Level Conceptual Data Models for Database Design An Example Database Application | 2 | |
| Entity Types, Entity Sets, Attributes, and Keys Relationships, relationship Types, Roles, and Structural Constraints | 5 | |
| Weak Entity Types Refining the ER Design for the COMPANY Database ER Diagrams, Naming Conventions, and Design Issues | 3 | |
| Relational Model Concepts Relational Constraints and Relational Database Schemas Update Operations and Dealing with Constraint Violations | 2 | |
| Basic Relational Algebra Operations Additional Relational Operations | 3 | |
| Relational Database Design Using ER-to-Relational Mapping Mapping EER Model Concepts to Relations | 2 | |
| The Tuple Relational Calculus The Domain Relational Calculus | 2 | |
| Informal Design Guidelines for Relation Schemas Functional Dependencies | 2 | |
| Normal Forms Based on Primary Keys General Definitions of Second and Third Normal Forms Boyce-Codd Normal Form | 2 | |
| Subclasses, Super classes, and Inheritance Specialization and Generalization. Constraints and Characteristics of Specialization and Generalization | 3 | |
| Modeling of UNION Types Using Categories An Example UNIVERSITY EER Schema and Formal Definitions for the EER Model. | 3 | |
| Conceptual Object Modeling Using UML Class Diagram. Relationship Types of a Degree Higher Than Two. Data Abstraction and Knowledge Representation Concepts | 3 | |
| First Exam Review, Second Exam Review, First and Second exam | 4 |
| Attachment Files |
Previous Exams
| Previous Exams |