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
- General
General
CSE311: Database Management System
Loving Students,
Assalamu Alaikum. Welcome to the Database Management System course! I am Warda Ruheen Bristi and I'll be your instructor of this course for the semester of Spring 2021.
Here we will discuss, learn, and explore. Wishing you a great experience!
- Course Summary and Objectives
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.
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.
- Notice Board
Notice Board
Restricted Not available unless: You belong to Section-I
Restricted Not available unless: You belong to Section-J
Restricted Not available unless: You belong to Re-A
- Week 1
Week 1
Introduction To BLC
Lecture 1.1
Learning Outcome:
- Database Introduction,
- Data and Information,
- Database Applications
- Problems in Conventional File Processing System,
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 Contents:
Links
Video Lectures:
Restricted Not available unless: You belong to Section-J
Restricted Not available unless: You belong to Section-I
Restricted Not available unless: You belong to Re-A
- Week 2
Week 2
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
Forum Discussion Question:
Discuss a real-life scenario where you have to work with a Conventional File Processing System. Now write the advantage and disadvantages on the basis of your experience.
Restricted Not available unless: You belong to Re-A
- Week 3
Week 3
Lecture 3
Learning Outcome:
- Introduction to ER model,
- What is Entity, Attribute, relationship
- Symbols used in ER model
- Types of Entity, Attribute, relationship Example
ER Model
Restricted Not available unless: You belong to Re-A
Restricted Not available unless: You belong to Re-A
- Week 4
Week 4
Lecture 5(ERD Continue..)
Learning Outcome:
- Introduction to ER model,
- What is Entity, Attribute, relationship
- Symbols used in ER model
- Types of Entity, Attribute, relationship Example
Lecture 6
Learning Outcome:
- Scenario to ER model conversion,
- Exercise
- Week 5
Week 5
Lecture 8
Learning Outcome:
- Scenario to ER model conversion Example,
Construct an ER Diagram for Company
having the following details :
- Company
organized into DEPARTMENT. Each department has unique name and a
particular employee who manages the department. Start date for the
manager is recorded. Department may have several locations.
- A
department controls a number of PROJECT. Projects have a unique name,
number, and a single location.
- Company's
EMPLOYEE name, ssno,
address, salary, and
birth
date are recorded. An employee is assigned to one department, but may work
for several projects (not necessarily controlled by her dept).
Number of hours/week an employee works on each project is recorded; The
immediate supervisor for the employee.
- Employee's
DEPENDENT are tracked for health insurance purposes (dependent name,
birthdate, relationship to employee).
- ERD symbol Learning
ERD symbol Learning
Learning ERD Symbols
Its a kind of game. You can drag all text buttons below and put them on the symbol images. You have to match symbols with an appropriate name. After matching you can submit it.
- quiz
quiz
Syllabus: Introduction to ER diagram
Syllabus: Schema, Relational Algebra, SQL
Syllabus: Relational algebra, Normalization, Transaction, ACID Properties
Presentation
Click here to upload.
- Week 6
Week 6
Lecture 9
Learning Outcome:
- ER model to Relational Schema
Restricted Not available unless: You belong to Re-A
Restricted Not available unless: You belong to Re-A
- Week 7
Week 7
Lecture 10
Learning Outcome:
- Introduction to Relational Algebra
Restricted Not available unless: You belong to Re-A
- Week 8
Week 8
Mid Examination Spring 2021 [CSE311-Sec-I, J] Assignment
Restricted Not available unless any of:
- You belong to Section-I
- You belong to Section-J
Exam duration: 2:30 hrs [1:30PM - 4:00PM]
Full Marks: 25
Google form Link to submit the script. Click here
Mid Examination Spring 2021 [CSE311-Re-A] Assignment
Restricted Not available unless: You belong to Re-A
Exam duration: 2:30 hrs [1:30PM - 4:00PM]
Full Marks: 25
Google form Link to submit the script. Click here
- Week 9
Week 9
Lecture 12
Learning Outcome:
- Week 10
Week 10
Lecture 14
Learning Outcome:
- Week 11
- Week 12
- Week 13
Week 13
Topics Covered:
- Scenario to ERD
- Normalization
- Transaction
- SQL
- Relational Algebra
Google Form. You Can Submit Only PDF file.
While Submitting, Please Check your Section Carefully.