Scribd Logo
Upload

Welcome to Scribd!

    • 27 views

    CS213 - Course Outline

    Uploaded by

    AbdulWahab
    This document provides information about the Fundamentals of Database Systems course. The course aims to teach students to analyze system requirements, design relational databases, and implement and manage databases using SQL. It is a 3+1 credit hour course with prerequisites of none. Key topics include the relational data model, SQL, ER modeling, functional dependencies, and normalization. Student learning will be assessed through assignments, quizzes, midterms, and a final exam worth a total of 100% of the grade.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    CS213 - Course Outline

    Uploaded by

    AbdulWahab
    27 views2 pages
    This document provides information about the Fundamentals of Database Systems course. The course aims to teach students to analyze system requirements, design relational databases, and implement and manage databases using SQL. It is a 3+1 credit hour course with prerequisites of none. Key topics include the relational data model, SQL, ER modeling, functional dependencies, and normalization. Student learning will be assessed through assignments, quizzes, midterms, and a final exam worth a total of 100% of the grade.

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides information about the Fundamentals of Database Systems course. The course aims to teach students to analyze system requirements, design relational databases, and implement and manage databases using SQL. It is a 3+1 credit hour course with prerequisites of none. Key topics include the relational data model, SQL, ER modeling, functional dependencies, and normalization. Student learning will be assessed through assignments, quizzes, midterms, and a final exam worth a total of 100% of the grade.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    27 views2 pages

    CS213 - Course Outline

    Uploaded by

    AbdulWahab
    This document provides information about the Fundamentals of Database Systems course. The course aims to teach students to analyze system requirements, design relational databases, and implement and manage databases using SQL. It is a 3+1 credit hour course with prerequisites of none. Key topics include the relational data model, SQL, ER modeling, functional dependencies, and normalization. Student learning will be assessed through assignments, quizzes, midterms, and a final exam worth a total of 100% of the grade.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 2

    Department Department of Electrical Engineering Dept.

    Code EE
    Course Title Fundamentals of Database Systems Course Code CS213
    Pre-requisite(s) - Credit Hours 3+1

    Ability to analyze system requirements, design and normalize a relational database.


    Course
    Also use SQL to implement and manage any relational database using any available
    Objective
    relational database management system.

    No. Assigned Program Learning Outcome (PLO) Level Tool


    An ability to create, select and apply appropriate techniques, resources, and
    05 modern engineering and IT tools, including prediction and modeling, to complex R F
    engineering activities, with an understanding of the limitations.
    I = Introduction, R = Reinforcement

    E = Evaluation, A = Assignment, Q = Quiz, M = Midterm, F=Final, L = Lab, P = Project, W = Written


    Report.

    Assessmen Taxonomy
    No. Course Learning Outcome (CLO) Statements PLO
    t Tools Levels
    Describe basic terminology and constraints with regards to
    1 Q1, M1 C2 5
    databases in general and relational database in particular.
    Apply SQL DDL/TCL/DCL statements on a relational data
    2 model to create and later manage the database using any M1, A1 C3, C5, C5 5
    available RDBMS.
    Apply SQL DML statements on any relational data model in
    3 order to select/update/delete/insert data present within the A1, Q2 C3 5
    database using any available RDBMS.
    Analyze system requirements and come up with an Enhanced
    4 Entity Relationship (EER) model (high level conceptual data A2, M2 C4 5
    model)
    Apply the rules that are needed to convert an ER/EER model
    5 into corresponding relational data model (implementation Q3,M2 C3 5
    data model).
    Use functional dependencies as a tool to analyze an existing
    6 A3, F C2, C4 5
    database for goodness of design.
    Rate an existing database via the normalization process for
    7 goodness of design and apply the normalization rules to A3, F C6, C3, C5 5
    redesign a poorly designed database.

    1
    Title Fundamentals of Database Systems (7th edition)
    Text Books Author Ramez Almasri
    Publisher Addison Wesley
    Title An Introduction to Database Systems
    Author C. J. Date
    Reference Books
    Title Database Management Systems
    Author Raghu Ramakrishnan

    Week Course Contents/Topics Chapter* CLO*


    Introduction to Database, Database System Concepts and 1&2
    01 1
    Architecture
    02 Relational Data Model and Relational Database Constraints 5 1
    03 The Relational Algebra 8 1
    04 The Database Language SQL: Schema Definition, Constraints, DDL 6&7 2
    05 The Database Language SQL: DML Queries 6&7 3
    06 The Database Language SQL: DML Queries (SELECT subqueries) 6&7 3
    The Database Language SQL: Stored Procedures, Views, and 6&7
    07 3
    Triggers
    8 ER Modeling 3 4
    9 ER Modeling (Higher degree relationships and examples) 3 4
    10 Enhanced ER Modeling 4 4
    11 Enhanced ER Modeling (multiple inheritance, union types) 4 4
    12 Relational Database Design by ER and EER to Relational Mapping 9 5
    13 Functional Dependencies 14&15 6
    14 Functional Dependencies (Equivalent and minimal sets) 14&15 6
    15 Normalization of Relational Databases 14 7
    16 Normalization of Relational Databases (Higher normal forms) 14 & 15 7
    *Reference book chapters are given in brackets

    Assessment Tools Weightage


    Assignments (3), Quiz (4) 20.0%
    Midterm (I+II) 30.0%
    Final Exam 50.0%
    Grading Policy: Relative

    You might also like