CSE 311 (RKR-203): Quiz 02

This file is no longer required in Moodle 4.2+. Please do not include/require it.

line 25 of /mod/quiz/accessrule/accessrulebase.php: call to debugging()
line 28 of /mod/quiz/accessrule/proctoringlms/rule.php: call to require_once()
line 1033 of /lib/classes/component.php: call to include_once()
line 103 of /mod/quiz/classes/access_manager.php: call to core\component::get_plugin_list_with_class()
line 269 of /mod/quiz/classes/access_manager.php: call to mod_quiz\access_manager::get_rule_classes()
line 132 of /mod/quiz/classes/quiz_settings.php: call to mod_quiz\access_manager::load_quiz_and_settings()
line 43 of /mod/quiz/view.php: call to mod_quiz\quiz_settings::create_for_cmid()

Class 'quiz_access_rule_base' has been renamed for the autoloader and is now deprecated. Please use 'mod_quiz\local\access_rule_base' instead.

line 223 of /lib/classes/component.php: call to debugging()
line 35 of /mod/quiz/accessrule/proctoringlms/rule.php: call to core\component::classloader()
line 1033 of /lib/classes/component.php: call to include_once()
line 103 of /mod/quiz/classes/access_manager.php: call to core\component::get_plugin_list_with_class()
line 269 of /mod/quiz/classes/access_manager.php: call to mod_quiz\access_manager::get_rule_classes()
line 132 of /mod/quiz/classes/quiz_settings.php: call to mod_quiz\access_manager::load_quiz_and_settings()
line 43 of /mod/quiz/view.php: call to mod_quiz\quiz_settings::create_for_cmid()

Class 'quiz' has been renamed for the autoloader and is now deprecated. Please use 'mod_quiz\quiz_settings' instead.

line 223 of /lib/classes/component.php: call to debugging()
line 35 of /mod/quiz/accessrule/proctoringlms/rule.php: call to core\component::classloader()
line 1033 of /lib/classes/component.php: call to include_once()
line 103 of /mod/quiz/classes/access_manager.php: call to core\component::get_plugin_list_with_class()
line 269 of /mod/quiz/classes/access_manager.php: call to mod_quiz\access_manager::get_rule_classes()
line 132 of /mod/quiz/classes/quiz_settings.php: call to mod_quiz\access_manager::load_quiz_and_settings()
line 43 of /mod/quiz/view.php: call to mod_quiz\quiz_settings::create_for_cmid()

Class 'mod_quiz_preflight_check_form' has been renamed for the autoloader and is now deprecated. Please use 'mod_quiz\form\preflight_check_form' instead.

line 223 of /lib/classes/component.php: call to debugging()
line 35 of /mod/quiz/accessrule/proctoringlms/rule.php: call to core\component::classloader()
line 1033 of /lib/classes/component.php: call to include_once()
line 103 of /mod/quiz/classes/access_manager.php: call to core\component::get_plugin_list_with_class()
line 269 of /mod/quiz/classes/access_manager.php: call to mod_quiz\access_manager::get_rule_classes()
line 132 of /mod/quiz/classes/quiz_settings.php: call to mod_quiz\access_manager::load_quiz_and_settings()
line 43 of /mod/quiz/view.php: call to mod_quiz\quiz_settings::create_for_cmid()

CSE 311 (RKR-203): Quiz 02 | DIU-BLC

Home Guidelines

Course Menu

View

Opened: Sunday, 1 November 2020, 8:00 PM

Closed: Sunday, 1 November 2020, 10:10 PM

Quiz Password

Attempts allowed: 1

To attempt this quiz you need to know the quiz password

Time limit: 1 hour 15 mins

General

Welcome to DBMS Class

Course Summary and Objectives

OBE Course outline

Course Introduction

Week 1 (Introduction to DBMS)

Class Discussion Slide-1

Class Discussion Slide-2

Class Discussion Slide-3

What have I Learned from this week [MCQ]

Forum Discussion about pros and cons of Conventional File Processing System

Week 2 (Data Model and Languages)

Class Discussion Slide-4

Class Discussion Slide-5

Class Discussion Slide-6

Self Assessment

Class Discussion Slide-7

Forum Discussion

10 Minutes Practice [Click Here]

Use LucidChart to implement your 10 Minutes Work

Assignment-1 (Draw ER Diagram of your favourite sport team)

Week 3 (ER to Schema Mapping)

Class Discussion Slide-8

Class Discussion Slide-9

ER to Schema Mapping (Video Lesson)

Class Discussion Slide-10

Assignment-2 (ER to Schema Mapping)

Five Minutes Practice

Homework (Relational Algebra)

Forum Discussion

Week 4 (SQL Queries)

Class Discussion Slide-11

Self Assessment

Forum Discussion

Interactive Self_Test

Week 5 (Join Operation)

Class Discussion Slide-12

Database Join Operation with Example

SQL Join 10 Minutes Practice

Discussion regarding SQL Join Operation

Week 6 (Basic SQL Queries)

SQL queries in Database

Class Discussion Slide-13

Discussion about SQL queries

Quiz 02

weekly Discussion

Week 7 (Operation and Functions)

Midterm Week (Week 8)

Midterm Exam Guideline

Midterm Exam

Midterm Exam Review

Week 8 (Nested Queries)

Class Discussion Slide-15

Class Discussion Slide-16

Forum Discussion

Week 9 (Stored Procedure and Normalization)

Class Discussion Slide-17

Class Discussion Slide-18

Class Discussion [Forum]

Week 10 (Database Transaction)

Class Discussion Slide-19

Class Discussion Slide-20

Class Discussion [Forum]

Quiz 03

Presentation

Week 11 (Trigger and Injection in DBMS)

Class Discussion Slide

SQL Injection

Final Assignment

Final Exam Reivew [Forum]

Week 12 (Final Exam Week)

Final Exam

Documents and Slides (Resource Pack)

Introduction to Database Management System

Purpose of Database System File

Relational Model in DBMS

Level of Abstraction and Data Models

Database Architecture

Types of Keys in Relational Model

Entity Relationship (ER) Model