|
Faculty of Computing and Information Technology
Department of Information Systems
CPIS 241: Introduction to Database Management (Syllabus)
Spring 2022 (2nd Semester 2022)
Instructor Information
Name: Dr. Halima Samra
e-mail: hsamra@kau.edu.sa
Office: Building 61- office s178
Office Hours: Monday-Wednesday 11:30-12:30 or by appointment
Course Information
Course Code/Title: CPIS 241 / Introduction to Database Management
Credits: 3 credits
Prerequisites: CPCS-202 (Programming I)
Textbook: Database Concepts, Sixth Edition, David M. Kroenke, David J. Auer
Course Description
The purpose of this course is to introduce the fundamental concepts of database management, including aspects of data models, database languages, and database design. At the end of this course, a student will be able to understand and apply the fundamental concepts required for the use and design of database management systems. The course introduces students to the concepts of databases and database modeling and design. It provides students with a three-stage methodology for designing relational database applications, namely, conceptual, logical, and physical database modeling and design. In the first stage students will build a conceptual data model that is independent of all physical considerations. They will then transform this model in the second stage into the relational database logical model. In the third stage, students will translate the logical data model into a physical design for the target DBMS. Topics include basic concepts of databases, the 3-stage modeling and design methodology, the concepts of the relational database, conceptual data modeling using ERD, from ERD to RDB and reverse engineering, data normalization, SQL: DDL, SQL: manipulation and query languages, and relational algebra for querying.
Course Objectives
At the end of this course, student should be able to:
• Define the database concept, basic data modeling and business rules.
• Describe the database design.
• Describe the basic concepts of relational model and relational schema.
• Develop database schemas with principled design that enforce data integrity.
• Identify the modeling symbols for the most popular ER modeling tools.
• Become knowledgeable in the creation, altering, and manipulation of tables and views using SQL.
|