Section outline
-
Welcome Letter
Dear Students,
Welcome to the CSE 311 Database Management System Course. I, Anika Nawar, will be your co-pilot in this online journey of learning. Let us ignite ourselves to start this journey at great speed.
Anika Nawar
Lecturer, Department of CSE
Daffodil International University
Instructor Information: Anika Nawar
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 Objectives:
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 Outcomes (CO’s):
- CO1: To be able to apply analytical skills to map out the conceptual design for 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 the Entity-Relationship (ER) model and explain the fundamental elements of the 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.
-
Students mustMark as done
Audio Recorded Slide on Course Introduction
-
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.
-
Students mustMark as done
Student Interest Survey: Click Here
-
Students mustMark as done
Take My Appointment:
-
Students mustMark as done
Important Dates
-
Students mustView
-
Students mustMark as done
-
Topics of Discussion:
- 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 Learning Outcomes:
- Able to identify the problems of the conventional file processing system with related terminology of ACID properties.
Resources of Learning:
Lesson 1: Database Introduction
- Class Discussion Slide-1
- Lesson 1 Lecture Video (Database Introduction)[From My YouTube Channel]
Lesson 2: Purpose of Database System
- Class Discussion Slide-2
- Lesson 2 Lecture Video (Purpose of Database System)[From My YouTube Channel]
Lesson 3: Relational Model- Class Discussion Slide-3
- Lesson 2 Lecture Video (Relational Model)[From My YouTube Channel]
-
Students mustView
-
Students mustViewMake forum posts: 1
- Database Introduction, Database History, Flat File Database,
-
Topics of Discussion:
- Level of Abstraction, Data Models, Database Languages
- Two Tier Architecture, Three Tier Architecture
- Discuss all types of keys in relational DB Model
Expected Learning Outcomes:
Able to know the level of abstraction, database languages and make a relational model with keys.
Resources of Learning:
Lesson 4: Level of Abstraction- Class Discussion Slide-4
- Lesson 4 Lecture Video (Level of Abstraction) [From My YouTube Channel]
Lesson 5: Database Architecture- Class Discussion Slide-5
- Lesson 5 Lecture Video (Database Architecture)
Lesson 6: Keys in Relational Model
- Class Discussion Slide-6
- Lesson 6 Lecture Video (Keys in Relational Model)
Lesson 7: Entity-Relationship Model
- Class Discussion Slide-7
- Lesson 7 Lecture Video (Entity-Relationship Model)
-
Students mustMark as done
-
Students mustMark as done
- Level of Abstraction, Data Models, Database Languages
-
-
Students mustView
-
-
Topics of Discussion:
- ER Diagram
- ER to Schema Mapping
Expected Learning Outcomes:
Able to learn mapping with different relations in Database and mathematical structure (Relational Algebra) of relations.
Resources of Learning:
Lesson 8: ER to Schema-1- Class Discussion Slide-8
- Lesson 8 Lecture Video (ER to Schema) [Video Lesson]
Lesson 9: ER to Schema-2
- Class Discussion Slide-9
- Lesson 9 Lecture Video (ER to Schema) [Video Lesson]
Lesson 10: Relational Algebra
- Class Discussion Slide-10
- Lesson 10 Lecture Video (Relational Algebra) [Video Lesson]
-
Students mustMark as done
-
Students mustMark as done
-
Students mustView
-
-
Students mustView
-
-
Topics of Discussion:
- CRUD (Create, Read, Update, Delete) operation
- Where and Order By Clause
- Group By Clause
Expected Learning Outcome:
- Able to learn very important CRUD operations in Relations.
Resources of Learning:
Lesson 11: Basic SQL Queries P-1
Lecture Video (Learn Basic SQL Commands) [Video Lesson]
-
Students mustMark as done
-
1. Create a database named 'university' and Make the following relation using Mysql or Sql Commands under this database.
2. After making these relations insert at least 5 records into each table.
-
Students mustView
-
Topics of Discussion:
- Inner Join
- Outer Join
- Join Operation using SQL
Expected Learning Outcome:
- Able to learn the basic Join operation with SQL query.
Resources of Learning:
Lesson 12: Join Operation
- Database Join Operation with Example [Video Lesson]
-
Students mustMark as done
-
Students mustView
-
Topics of Discussion:
- Between and In Queries, Exist and not exists Queries
- Like Operator, Group by with having clause
- Rename Operation, Order By, Set Operations
- Nested Query Using Set Operation
- Delete Operation
- Update Operation
Expected Learning Outcome:
- Able to learn the basic SQL query with Set operations and different operation in SQL
- Able to learn different functions in SQL.
Lesson 13: Basic SQL Queries P-2
- Class Discussion Slide-13
- SQL queries in Database [Video Lesson]
Lesson 14: Basic SQL Queries P-3
-
Students mustMark as done
-
Students mustView
-
Midterm Syllabus
- Database Introduction, Purpose of Database System, Database Architecture, Level of Abstraction
- Relational Model, DBMS Languages, ACID Properties
- Entity-Relationship (ER) diagram.
- ER to Schema Mapping
- Joining Operation
- Basic SQL Queries with different functions.
Midterm Assessment Plan
Total Marks: 25Midterm Open Book Exam Guidelines for Students (Click to Download)
Answer Script for Final Exam (Click to Download)
Image to PDF Generator Mobile Apps: [Use any one of these apps]
1. Cam Scanner [Click to download on your Smartphone]
2. Fast Scanner [Click to download on your Smartphone]
3. Tap Scanner [Click to download on your Smartphone]-
Students mustViewMake a submission
You have to answer all the questions.
Upload pdf format answer script and the file size must be within 10MB.
Total Time: 4 hours.File Name Pattern: e.g. CSE311-O-5-111-15-1111-mid.pdf
N. B. If you are unable to submit the answer script in BLC, you can submit it in the following Google Form.
-
Students mustView
-
Previous Semester's Midterm Examination Question for Better Understanding.
- Database Introduction, Purpose of Database System, Database Architecture, Level of Abstraction
-
Topics of Discussion:
- Nested Queries
Expected Learning Outcomes:
- Able to learn the nested SQL query among more than one relation.
Resources of Learning:
Lesson 15: Subqueries in DBMS (Part-1)
Lesson 16: Subqueries in DBMS (Part-2)-
Students mustViewMake a submission
-
Students mustMark as done
-
Students mustMark as done
-
Topics of Discussion:
- Stored Procedure
- First Normal Form
- Second Normal Form
- Third Normal Form
Expected Learning Outcomes:
- Able to learn to minimize redundancy (duplicate data) and to ensure only related data is stored in each table.
Resources of Learning:
Lesson 17: Stored Procedure and SQL Views
Lesson 18: NormalizationNormalization:
-
Students mustMark as done
-
Students mustMark as done
-
-
Students mustView
-
-
Topics of Discussion:
- Transaction Operation in DBMS
Expected Learning Outcomes:
- Able to identify Concurrent execution of the same transaction, deadlock, or slow performance.
Resources of Learning:
Lesson 19: Transaction: Part-1
Lesson 20: Transaction: Part-2-
Students mustMark as done
-
Students mustMark as done
-
Topics of Discussion:
- What is DB Trigger?
- Trigger Syntax
- Explanation of Trigger Syntax
- Trigger Example
Expected Learning Outcomes:
- Able to identify when discrete events occur, and it allows the user to drill down into the metrics of that event
Able to learn mathematical structure (Relational Algebra) of relations.
Resources of Learning:
Lesson 21: Database Trigger
Lesson 10: Relational Algebra
- Class Discussion Slide-22
- Lesson 22 Lecture Video (Relational Algebra) [Video Lesson]
-
Students mustMark as done
-
Students mustMark as done
-
Presentation
- Choose any topic related to Database for your presentation
- Keep the duration of your presentation between 3-5 minutes (Don't exceed 10 minutes)
- Submit by 16/12/2020(Wednesday) at 11:59 PM
-
Students mustView
-
Final Syllabus
- Entity-Relationship (ER) diagram.
- SQL Queries
- Stored Procedure
- Normalization
- Relational Algebra
- Database Transaction
- Trigger
Total Marks: 40Final Assessment Plan
Final Open Book Exam Guidelines for Students (Click to Download)
Answer Script for Final Exam (Click to Download)
Image to PDF Generator Mobile Apps: [Use any one of these apps]
1. Cam Scanner [Click to download on your Smartphone]
2. Fast Scanner [Click to download on your Smartphone]
3. Tap Scanner [Click to download on your Smartphone]-
Students mustMark as done
-
Students mustMark as done
