To operate the Blended Learning Center(BLC) at optimal level, maintenance will be performed every day at 8:30 AM and at 5:00 PM regularly which can take up to 30 minutes. Please consider scheduling your activity in the BLC platform accordingly.
Topic outline
- Welcome to the DBMS course
Welcome to the DBMS course
CSE311: Database Management System
Dear Students,
Welcome
to the 2021 Fall Semester, Students.
Let's starts our journey with a nice Quote from DBMS in Life...
--------
Moushumi Zaman Bonny
Assistant Professor,
Dept. of CSE, FSIT
Daffodil International University
Email: bonny.cse@diu.edu.bd
Phone: +8801923703097
- Course Introduction Video
Course Introduction Video
- Course Summary and Objectives
Course Summary and Objectives
Welcome to the Database Systems course! In this course, we will be using
SQL Server to learn about administering a database, as well as the basics of the SQL language. In this course, we will learn about database
management
the system, database languages, data models, database design. This course will focus on how to use the SQL language in order to view and manipulate data. This will include creating and deleting various database objects,
adding and altering data within tables, and viewing and sorting data.
After completing this course, you will have hands-on experience in
administering a database know how to use the SQL language in order to
manage it.
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 Objective:
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.
- Instructions/Guideline for the course
Instructions/Guideline for the course
- All the students registered for this course have to enroll in Moodle
- Students can find all the course materials from Moodle.
- All the students have to submit the soft copy of their "Assignment" in Moodle under the assignment section
created here and for this, they will be graded here.
- One discussion or feedback
forum is created under each of the lectures Students have to give their
feedback on these forums and marks will be given for their feedback
- Any announcement regarding the class will be posted on Moodle. So they have to keep themselves always active on Moodle.
- All the quizzes and presentations will be held in an online class.
- The question pattern and the syllabus for the quizzes, midterm, and final exam is given here under each of the section (quizzes, midterm, and final)
- There are midterm and final exam preparation forums under these sections where students can discuss with each other about their midterm and final exam syllabus, any problem regarding the exam, etc.
- Attendance & Announcement
Attendance & Announcement
- Students Feedback
- Week 1 (Introduction to DBMS)
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.
Section-A, Recorded Class, Date::23.01.2022 URL
Restricted Not available unless: You belong to Section-A
Section-A, Recorded Class, Date::24.01.2022 URL
Restricted Not available unless: You belong to Section-A
Section-G, Recorded Class, Date::24.01.2022 URL
Restricted Not available unless: You belong to Section-G
Section-G, Recorded Class, Date::23.01.2022 URL
Restricted Not available unless: You belong to Section-G
- Week 2 (Data Model and Languages)
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.
Section-A, Recorded Class, Date::30.01.2022 URL
Restricted Not available unless: You belong to Section-A
Section-A, Recorded Class, Date::31.01.2022 URL
Restricted Not available unless: You belong to Section-A
Section-G, Recorded Class, Date::30.01.2022 URL
Restricted Not available unless: You belong to Section-G
Section-G, Recorded Class, Date::01.02.2022 URL
Restricted Not available unless: You belong to Section-G
- Week 3 (ER to Schema Mapping)
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.
Section-A, Recorded Class, Date::07.02.2022 URL
Restricted Not available unless: You belong to Section-A
Section-G, Recorded Class, Date::06.02.2022 URL
Restricted Not available unless: You belong to Section-G
Section-G, Recorded Class, Date::08.02.2022 URL
Restricted Not available unless: You belong to Section-G
- Week 4 (SQL Queries)
Week 4 (SQL Queries)
Lecture Objectives:
- ER to Schema Mapping
- Practice example
Expected outcome
- Able to learn very important CRUD operations in Relations.
Section-A, Recorded Class, Date::13.02.2022 URL
Restricted Not available unless: You belong to Section-A
Section-G, Recorded Class, Date::13.02.2022 URL
Restricted Not available unless: You belong to Section-G
Section-A, Recorded Class-Part-1, Date::14.02.2022 URL
Restricted Not available unless: You belong to Section-A
Section-A, Recorded Class-Part-2, Date::14.02.2022 URL
Restricted Not available unless: You belong to Section-A
- Week 5 (Join Operation)
Week 5 (Join Operation)
Expected outcome
- Able to learn the basic Join operation with SQL query.
Section-A, Recorded Class, Date::20.02.2022 URL
Restricted Not available unless: You belong to Section-A
Section-G, Recorded Class, Date::20.02.2022 URL
Restricted Not available unless: You belong to Section-G
- Week 6 (Basic SQL Queries)
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.
Section-G:: Quiz-1
Restricted Not available unless: You belong to Section-G
Section-A::Quiz-1
Restricted Not available unless: You belong to Section-A
- Week 7 (Operation and Functions)
Week 7 (Operation and Functions)
Expected outcome
- Able to learn the basic SQL query and different functions in SQL.
- Midterm Week
Midterm Week
Mid Term Examination
Midterm Syllabus
- Relational Model, DBMS Languages
- Entity-Relationship (ER) diagram.
- ER to Schema Mapping.
- Basic SQL Queries with different functions.
- Week 8 (Nested Queries)
Week 8 (Nested Queries)
Expected outcome
- Able to learn the nested SQL query among more than one relation.
- Week 9 (Stored Procedure and Normalization)
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)
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 11 (Trigger in DBMS)
Lecture Objectives:
- What is DB Trigger?
- Trigger Syntax
- Explanation of Trigger Syntax
- Trigger Example
Expected outcome
- Able to identify when discrete events occur, and it allows for the user to drill down into the metrics of that event.
- Week 12 (Final Exam Week)
Week 12 (Final Exam Week)
Final Assessment Syllabus
- Relational Algebra
- SQL Queries and Sub-Queries
- Stored Procedure
- Database Normalization
- Database Trigger
Assessment Plan
Total Marks: 40
- Topic 19