Topic outline

  • Welcome to the DBMS course

    CSE311: Database Management System 

  • Course Summary and Objectives

    course cover

    • Course Rationale

      Database Management Systems (DBMS) are vital components of modern information systems.  Database applications are pervasive and range in size from small in-memory databases to terra bytes or even larger in various applications domains.  The course focuses on the fundamentals of knowledge-base and relational database management systems, and the current developments in database theory and their practice.

    • Course Objective:

      Upon successful completion of this course, students should be able to:

      • Describe the fundamental elements of relational database management systems.
      • Explain  the  basic  concepts  of  relational  data  model,  entity-relationship  model,  relational  database design, relational algebra and SQL.
      • Design ER-models to represent simple database application scenarios
      • Convert  the  ER-model  to  relational  tables,  populate  relational  database  and  formulate  SQL  queries on data.
      •  Improve the database design by normalization.
      •  Familiar   with   basic   database   storage   structures   and   access   techniques.

    • Course Outcome

      CO1
      To be able to apply analytical skills to map out the conceptual design for a real-life problems and write database documentation, including data standards, procedures and definitions for the data dictionary.

      CO2
      To be able to draw the model of Relational Database using Entity Relationship (ER) model and explain the fundamental elements of Database management System.

      CO3
      To be able to evaluate the logical design to translate into a specific data model and physical design to meet system storage requirements.

      CO4
      To be able to evaluate MSSQL/MySQL/Oracle features and MSSQL /MySQL/Oracle related products for maintaining the integrity and performance of enterprise databases.


    • Course Assessment:

      Final grade in each course will be given on the basis of performance in class attendance, in-
      course examinations, assignments, midterm test and final examination is shown in Table.


  • This topic

    NOTICE BOARDS

    • INSTRUCTOR:
      FATEMA TUJ JOHORA
      Office: Room # 704, AB-1
      Cell Number# +880 1315689508

      Email: fatema.cse@diu.edu.bd



    • Quiz 1:
      Date: 4.11.2021

      Time: 2:00 pm
      Topic: ER Diagram Drawing, Schema Writing, And Basic SQL

  • IMPORTANT LINKS

  • CLASS RECORDINGS

  • ASSIGNMENT AND PRESENTATION

  • FORUM AND DISCUSSION

  • Week 1 (Introduction to DBMS)


    • Lecture Objectives:

      • Database Introduction, Database History, Flat File Database,
      • Data and Information, Database Applications
      • Problems in Conventional File Processing System, Difficulty in accessing data.
      • Integrity problems, Atomicity problems, Security problem.
      • Relational Model?  Relational Model Concept.
      • Relational Integrity Constraints, Operation in Relational Model

    • Expected outcome

      • Able to identify the problems of conventional file processing system with related terminology of ACID properties.

  • Week 2 (Data Model and Languages)


    • Lecture Objectives:

      • Level of Abstraction, Data Models, Database Languages
      • Two Tier Architecture, Three Tier Architecture
      • Discuss all types of keys in relational DB Model.

    • Expected outcome

      • Able to know the level of abstraction, database languages and make relational model with keys.

  • Week 3 (ER to Schema Mapping)


    • Lecture Objectives:

      • ER Diagram
      • ER practice from scenario

    • Expected outcome

      • Able to learn mapping with different relations in Database and mathematical structure (Relational Algebra) of relations.

  • Week 4 (SQL Queries)


    • Lecture Objectives:

      • ER to Schema Mapping 
      • Practice example

    • Expected outcome

      • Able to learn very important CRUD operations in Relations.

  • Week 5 (Join Operation)


    • Lecture Objectives:

      • Relational Algebra 

    • Expected outcome

      • Able to learn the  basic Join operation with SQL query.

  • Week 6 (Basic SQL Queries)


    • Lecture Objectives:

      • Basic SQL query
      • Between and In Queries, Exist and not exists Queries
      • Like Operator, Group by with having clause
      • Rename Operation, Order By, Set Operations
      • Nested Query  



    • Expected outcome

      • Able to learn the  basic SQL query with Set operations and different operation in SQL.

  • Week 7 (Operation and Functions)


    • Lecture Objectives:

      • SQL Joining  



    • Expected outcome

      • Able to learn the  basic SQL query and different functions in SQL.

  • Midterm Week

    Mid Term Examination 

     

    • Midterm Instruction for DAY students

      Midterm Assessment Plan
      Total Marks: 25

      Assalamuwalaikum students,

      Please find the following documents.

      1. Exam Question (day) (Click here)
      2. Answer script submission template. (Click here) ( You have to submit in pdf format)


      After preparing the answer script you have to submit your file in the following google form and BLC.

      Google form ( Click here to submit )

      Do not copy from others or help others. Upon finding similar copies it may cause the deduction of 5 to 10 marks.

      The time limit for the exam is 1:30 pm to 4:00 pm. The time will be strictly maintained.

      Thank you.
      All the best.
      Allah Hafez.



  • Week 8 (Nested Queries)


  • Week 9 (Stored Procedure and Normalization)


    • Lecture Objectives:

      • Stored Procedure
      • First Normal Form
      • Second Normal Form
      • Third Normal Form



    • Expected outcome

      • Able to learn to minimize redundancy (duplicate data) and to ensure only related data is stored in each table.

  • Week 10 (Database Transaction)


    • Lecture Objectives:

      • Transaction Operation in DBMS



    • Expected outcome

      • Able to identify Concurrent execution of the same transaction, deadlock, or slow performance.

  • Week 11 (Trigger in DBMS)


  • Week 12 (Final Exam Week)