Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 30 views

    Sillabus (Eng) - Database Systems - 21-22

    Uploaded by

    gjyla
    This syllabus outlines a database systems course offered to computer science students. The course will cover database design concepts, modeling data using entity relationship diagrams and the relational model, and using SQL to create and manipulate databases. Students will learn to design conceptual and logical database schemas, implement relational databases using SQL, and create both simple and complex queries. Assessment includes a group project, laboratory exercises, and a final exam.

    Copyright:

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

    Sillabus (Eng) - Database Systems - 21-22

    Uploaded by

    gjyla
    30 views2 pages
    This syllabus outlines a database systems course offered to computer science students. The course will cover database design concepts, modeling data using entity relationship diagrams and the relational model, and using SQL to create and manipulate databases. Students will learn to design conceptual and logical database schemas, implement relational databases using SQL, and create both simple and complex queries. Assessment includes a group project, laboratory exercises, and a final exam.

    Original Description:

    Original Title

    Sillabus (Eng)_database Systems _21-22

    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 syllabus outlines a database systems course offered to computer science students. The course will cover database design concepts, modeling data using entity relationship diagrams and the relational model, and using SQL to create and manipulate databases. Students will learn to design conceptual and logical database schemas, implement relational databases using SQL, and create both simple and complex queries. Assessment includes a group project, laboratory exercises, and a final exam.

    Copyright:

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

    Sillabus (Eng) - Database Systems - 21-22

    Uploaded by

    gjyla
    This syllabus outlines a database systems course offered to computer science students. The course will cover database design concepts, modeling data using entity relationship diagrams and the relational model, and using SQL to create and manipulate databases. Students will learn to design conceptual and logical database schemas, implement relational databases using SQL, and create both simple and complex queries. Assessment includes a group project, laboratory exercises, and a final exam.

    Copyright:

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

    …………………………………………………………………………………………………………………………………………………………

    Syllabus
    BSc Faculty of Computer Science and Engineering

    DATABASE SYSTEMS
    Subject
    Type Semester ECTS Code
    OBLIGATIVE (O) 3 5
    Course Lecturer Medina SHAMOLLI, MSc
    Course Assistants Elton BOSHNJAKU, cand.MSc
    This course offers students the study of Database Systems, Defining Requirements for the Database
    systems, including Database Design with Entity Relationship-Based Models, Relational Modelling, and
    Using SQL and Relational Algebra.
    Aims and Objectives
    The student will power with knowledge at modelling databases from conceptual and physical levels of
    design, then be able to develop database schemas that enforce data integrity. Including knowledge in
    creating and manipulating of SQL operation to enforce those operation of database schemas.
    Prerequisite(s) Recommended: concepts of system requirements, knowledge of defining objects but not necessarily
    Upon completion of the course, the student should be able to:
     Understand and understand the functions offered by Database Management Systems, as well as the
    choice of DBMS for creating real applications.
     Knowledge of modelling conceptual and logical level of database design. Use the entity-relationship
    Learning Outcomes model (E-R& EE-R) and E-R diagrams
     Implement a relational database schema using Structured Query Language (SQL), to create and
    manipulate tables, indexes, and views.
     Create and use simple, intermediate and complex queries in SQL.

    Course Plan
    Unit I: overview of database system concepts
    Course Presentation / Introduction of database systems.

    Unit II: SQL Basics


    SQL Basic operation, data types, Implementing Query processing using the Cartesian product, SQL
    Aggregation Functions

    Unit III: Relational data models and Database Design Concepts


    The process of designing and modelling data (ERD), E-R Diagram, Weak Entities. EER (Generalization
    15 Weeks and Specialization), Relational Model and Logical Database Design, Functional dependencies and
    Course Content Normalization of Database Tables.

    Unit IV: Intermediate SQL


    Implementation of Structure Query Language & Relational Algebra (Set Operations), SQL: Data
    Definition Language, DML: SQL, Authorization, Integrity Constraints, Tables etc. Null Values. JOINs
    Relations, Subquery

    Unit V: Advanced SQL


    with/ views
    PL/SQL concepts: Store Procedures

    Teaching/Learning Activity Weight (%)


    1. Lectures 20%
    Teaching/Learning 2. Seminar 0%
    Methods 3. Group Project 25%
    4. Laboratory Exercises 20%
    5. Self Study 35%
    Assessment Activity Number Week Weight (%)

    1. Group Project (2 students) 1 8,10,13 30%

    2. Final Exam 70%


    3 Assignments +10%
    4. Participation in lectures and exercises are not mandatory.
    Assessment Methods 5. Retake students are not required to attend lectures but are required to complete all planned
    activities (parts of the project).
    5.1 Retake- students who do not complete projects will be assessed as follows:
    o 70-79 points grade 6 Six
    o 80-89 points grade 7 Seven
    o 90-100 points grade 8 Tete

    Resources Number
    1. Classes 1
    2. Laboratory 1
    Course resources
    3. Moodle 1
    4. Software: Microsoft SQL Server Management Studio, 1
    5. Projector 1
    Activity Weekly hrs Total workload
    1. Lecture 2 30
    2. Seminars
    ECTS Workload 3. Laboratory 2 30
    4. Practice in industry
    5. Independent learning 5 88
    6. Final Exam 1 2

    • DATABASE SYSTEM CONCEPTS, 7th ED, Abraham Silberschatz, Henry F. Korth, S.


    Sudarshan.
    Literature/References
    • DATABASE SYSTEMS: DESIGN, IMPLEMENTATION, AND MANAGEMENT, 13 th ED by
    Carlos Coronel and Steven Morris

    medina.shamolli@ubt-uni.net,
    Contact
    elton.boshnjaku@ubt-uni.net

    You might also like