Topic outline

  • Welcome to the course

    CSE312: Database Management System Lab  

    • Welcome Message to my Students 

      My Dear Students,
       Greetings to you all. I'm Taslima Ferdaus Shuva, Senior Lecturer in the Department of Computer Science and Engineering at the Daffodil International University. I am also a PhD student at Jahangirnagar University.  
      I have completed ny B.Sc. as well as M.Sc. in Information Technology from Institute of Information Technology(IIT),Jahanagirnagar University.
      In this semester I am going to conduct the course CSE312: Database Management System Lab. A database management system (DBMS) is a computer application software that provides a way to manage data. The requirement of modern days is to have an automated system that manages, modifies and updates data accurately. This is achieved by a DBMS in a robust, correct and non redundant way. DBMS lab aims at practicing and achieving this aim by using various software’s such as SQL, ORACLE, and MS – Access etc. All these require a thorough practice of various DDl, DCL and DML queries.
      I'm delighted that you are interested in taking our specialization. We have done our part to make this a rewarding educational experience. Now it's your turn, good luck. 

    • Welcome My dear students Forum


      Instructor: 

      Taslima Ferdaus Shuva

      Senior Lecturer
      Department of Computer Science & Engineering
      Daffodil International University
      shuva.cse@diu.edu.bd
      Room#317/4, Ab4, Daffodil Smart City
      Daffodil International University       



      Appointment in the Google Calendar:  Click here



    • Welcome Note Forum

      Dear Students,
      Assalamuwalaikum!

      Welcome to the 2022 Summer Semester, Students. 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 most of your time here.
      Remember to make it a great semester. Let's starts our journey with a nice Quote from DBMS....



      I will see you soon.
      Allah Hafez.

      Taslima Ferdaus Shuva
      Senior Lecturer, Dept. of CSE
      Daffodil International University
      Email: shuva.cse@diu.edu.bd
      Address: Room 317/B, AB4, DSC.


  • Course Summary and Objectives

    •    Course Goals:

      A database management system (DBMS) is a computer application software that provides a way to manage data. The requirement of modern days is to have an automated system that manages, modifies and updates data accurately. This is achieved by a DBMS in a robust, correct and non redundant way. DBMS lab aims at practicing and achieving this aim by using various software’s such as SQL, ORACLE, and MS – Access etc. All these require a thorough practice of various DDl, DCL and DML queries.

    • Course objectives:

      This course will enable students to
      • Foundation knowledge in database concepts, technology and practice to groom students into well-informed database application developers.
      • Strong practice in SQL programming through a variety of database problems.
      • Develop database applications using front-end tools and back-end DBMS.

    • Course Outcome

      CLO1

      Define database concepts and structures and query language, data types, the E R model and relational model. Illustrate the model of Relational Database using Entity-Relationship (ER) model and the fundamental elements of Database management System.

      CLO2

      Build a simple database system and learn about basic SQL statements.

      CLO3

      Build a simple database system and learn about nested SQL statements, different kinds of joining etc.

      CLO4

      Learn about database trigger, procedure, views etc.

    • Course Goals:

      A database management system (DBMS) is computer application software that provides a way to manage data. The requirement of modern days is to have an automated system that manages, modifies, and updates data accurately. This is achieved by a DBMS in a robust, correct, and non-redundant way. DBMS lab aims at practicing and achieving this aim by using various software’s such as SQL, ORACLE, and MS – Access, etc. All these require a thorough practice of various DDL, DCL, and DML queries.


    • Course objectives:

      This course will enable students to
      1. Foundation knowledge in database concepts, technology, and practice to groom students into well-informed database application developers.
      2. Strong practice in SQL programming through a variety of database problems.
      3. Develop database applications using front-end tools and back-end DBMS.

    • Course Outcome

      CO1
      To be able to build database concepts and structures and query language
      To be able to Understand the E R model and relational model

      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 design and build a simple database system and demonstrate competence with the fundamental tasks involved with modeling, designing, and implementing a DBMS.

      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.

  • Notice Board


  • Welcome Speech


    Welcome Message  From Course Teacher

     


    Dear Students,

    Welcome to the 2022 Fall Semester!

    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.








    • Feedback


      Put your constructive comments, suggestions regarding the design of this course as well as BLC platform here.


    • Week1

      Week 1

      Introductory Discussion

      • Recorded Class 

      • Week 01 URL

      • BLC Course Design Feed-back

        Please give your valuable feedback here. Your Single feedback can make a great change. So do not miss the chance to contribute . I appreciate your active participation

      • Opinion Form 1 URL

      • Mid Question Feedback Form


    • Week 2

      Week 2

    • Week 3

      Week 3

    • Week 4

      Week 4

    • Week 5

      Week 5

    • Week 7

      Lab Examination(25)




      • Question

        Suppose your family owns a business. To manage that you have decided to build a software that will keep track all sort of information regarding your profit, loss, expenses, earning everything. Now create your own Database(a. 10) describing  your business(business field, work procedures) in short. Insert(b. 5) minimum 5 values in each table with logical constraint(c. 5). Show the total sell(d. 5) of a day or month according to your Database design.  

        1. Put individual screenshots of each marked tasks and paste it in a drive. Provide the drive link only. 

        2.As you are designing the Database, you can make your own decisions regarding table Naming, Datatype and all fields. 

        3.  Keeping integrity you'll have to add PK, FK where needed.

        4. Two  or more scripts having the same database table/dataset will not be eligible for any mark and will be rewarded zero .

        ***Don't copy, use your brain.

      • Submission thread for PCA Assignment
        Opened: Wednesday, 28 September 2022, 12:00 AM
        Due: Wednesday, 28 September 2022, 10:30 AM
      • Exam Syllabus: SQL Interactive Content
        Complete the activity


        Theory Exam Syllabus: SQL 

      • Lab_task_3_submission_Sec-F Assignment
        Opened: Monday, 6 September 2021, 12:30 AM
        Due: Monday, 6 September 2021, 2:30 AM
      • Lab_task_3_submission_Sec-G Assignment
        Opened: Wednesday, 8 September 2021, 10:30 PM
        Due: Wednesday, 8 September 2021, 11:30 PM

      • Class Recording :

        SEC- G (Click here)
        SEC- F (Click here)
        SEC- EVE(A) (Click here)



      • Join Document File

    • Week 7

      Week 7

    • Week 8

      Week 8

    • Week 9

      Week 9

    • Week 10

      Week 10

      • Learning Objective:

        • Set Operations 
        • Union/ Union All
        • Intersect
        • Minus

    • Week 10

      WEEK TEN


      Lab Final

      • Dear Students,
        Find the lab Assessment question below. You will get total 3 hours. Exam time : 2 hours and 30 minutes and 30 minutes for document preparation. you have to submit your script timely. Any late submission will deduct 5 marks from your total marks.
        All the best for the exam.

        For Question click here

      • Final Lab Script Submission sec-G Assignment
        Opened: Wednesday, 27 October 2021, 10:00 PM
        Due: Thursday, 28 October 2021, 1:15 AM
      • Final Lab Script Submission sec-F Assignment
        Opened: Friday, 29 October 2021, 9:00 AM
        Due: Friday, 29 October 2021, 10:30 AM
      • Final Lab Script Submission sec- EVE(A) Assignment
        Opened: Sunday, 31 October 2021, 6:00 AM
        Due: Sunday, 31 October 2021, 10:30 AM

      • Dear Students,
        Find the lab Assessment question below. You will get total 3 hours. Exam time : 2 hours and 30 minutes and 30 minutes for document preparation. you have to submit your script timely. Any late submission will deduct 5 marks from your total marks.
        All the best for the exam.

        For Question click here


      • Dear Students,
        Find the lab Assessment question below. You will get total 3 hours. Exam time : 2 hours and 30 minutes and 30 minutes for document preparation. you have to submit your script timely. Any late submission will deduct 5 marks from your total marks.

        You have to submit the answer script in blc and Also in the following google form
        Google form (Click here)

        All the best for the exam.

        For Question click here


    • Week 11

      Week 11

      • Learning Objective:

        • SQL Join
        • Natural Join, Inner Join
        • Left, Right Join
        • Full Join
        • SQL View

      • Submit your project here ( Click Here )

      • Submit your project here SEC-G ( Click Here )

      • Submit your project here SEC-EVE(A) ( Click Here )

    • Week 12


      • You must have to submit PDF File. Your File must Contain: 

        • Course Code: CSE312
        • Course Title: Database Management System Lab Final
        • Student ID: 
        • Student Name:
        • Section: 
        • Exam Date:

      • Lab Final Assignment
        Opened: Wednesday, 7 December 2022, 12:00 AM
        Due: Wednesday, 7 December 2022, 11:30 AM

    • Topic 18

      • Topic 19

        • Topic 20

          • Topic 21

            • Topic 22