Topic outline

  • General

    CSE311/CSE311L: Database Management System  

    • Basic Information about course instructor:

      Course Code: CSE 311/311 L (Evening)
      Program: B.Sc in Computer Science and Engineering
      Faculty: Science and Information Technology
      Semester: Summer; Year: 2021
      Credit: 1/3.0; Contact Hour: 1/3 Hours/ Week
      Course Category: Core Engineering

      Course Instructor:

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

      Email: fatema.cse@diu.edu.bd


  • Course Summary and Objectives

    • 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.
    • Outline File

      DBMS Course Outline

    • 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.

                    

  • Welcome Message

     


    welcome message

    Dear Students,

    Welcome to the 2021 Summer Semester!
    I can’t wait to see all your smiling faces! I am here to support you every step of the way. I encourage you to make the best use of your time here. Remember to make it a great year, together we will make a remarkable journey.

    Fatema Tuj Johora

    • Notice Board

      Noticeboard 

      • ROUTINE

      • QUIZ

        Date: 19.6.2021

        Marks: 15

        Time: 7:30pm to 8:20pm

        Topic: 

        • Scenario to ER Diagram Drawing
        • ER Diagram to Schema writing    

        Instructions:

          1.   Follow the given Exam Script Template.
          2.   You will find the  Question in PDF  format in your BLC on the scheduled time.   
          3.  You can upload the file in PDF, Docx, or take images of the exam scripts (if needed) and convert it into PDF while submitting it in BLC or by Google Form.
          4.  Answer Script Naming conversion format: Q_CSE225_PC-B_1234 (Quiz_Course Code_Section_Last 4/5 digits of your ID)

          • You can submit only once. So, before submission Please check whether you are submitting the correct file or not.

               

      • ASSIGNMENT

        DATE OF SUBMISSION: Till 15.6.2021

    • IMPORTANT LINKS

    • FORUM LINKS (COMPLETED)

    • QUIZ

      • Lab Evaluation

      • Assignment


      • Week 1

        Week 1

        • Lecture 1

          Learning Outcome:

          • 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 problems

        • Lecture 2

          Learning Outcome:

          • Relational Model,  
          • Relational Model Concept, 
          • Relational Integrity Constraints, 
          • Operation in Relational Model
          

          Reference Book Chapter:
          

            
    
          • Fundamentals of Relational Database Management System, S. Sumathi and S. Esakkirajan   Chapter 1
            • 
    
          • Database System Concept, Silbertz, Korth and Sudarshan Chapter 1
            • 

          • Lecture for week 1 [Video]
          • Lecture for week 1 [Video]
        • Lecture for week 1 [Video][Lab]
          Introduction to Database : 

      • Week 2
        Week 2
      • Week 3
        Week 3
      • Week 4
        Week 4
      • week 5
        Week 5


      • week 6
      • Week 7
        MIDTERM EXAM 
        • Instructions:
          1.   Follow the given Exam Script Template.
          2.   You will find the Midterm Exam Question in PDF  format in your BLC on the scheduled time.   
          3.  You can upload the file in PDF, Docx, or take images of the exam scripts (if needed) and convert it into PDF while submitting it in BLC or by Google Form.
          4.  Answer Script Naming conversion format: quiz_CSE311_C/D/N_1234 (quiz_Course Code_Section_Last 4/5 digits of your ID)
          • You can submit only once. So, before submission Please check whether you are submitting the correct file or not.

          
            
          
                            
                        
            
          

      • Week 8
        Week 8
      • Week 9
        Week 9
      • Week 10
        Week 10

      • PRESENTATION
        PRESENTATION

        • 
            
          
                            
                        
            
          

        • Presentation Assignment
          
            
          
                    
          
                                
                                    Make a submission
                                
                    
          
            
          

          Upload Your Video Presentation.
          1. Prepare a ppt with a maximum of 10 slides.
          2. Add voice narration and send the recorded ppt with voice narration (provide google drive link) 
          3. Presentation Duration: 3-4 Minutes (Max)
          4. One submission from each person

          Deadline: On or before 30.07.21
          Topic: Anything Related to Database Management System

      • This topic
        Week 13
        
    Not available

      • LAB FINAL