CSE311NKS: Week-8 Feedback Assignment

Home Guidelines

Course Menu

Opened: Sunday, 22 November 2020, 12:00 AM

Due: Sunday, 29 November 2020, 12:00 AM

Write a SQL query to display the Employee names whose salaries are greater than the average salary of all employees

Employee Table

General

OBE Course outline

Lecture Slide-16

Students Interest Feedback

Attendance

Week 1

Lecture Slide-1

Lecture Slide-2

Lecture Slide-3

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

Lecture Slide- 4

Lecture Slide- 5

Lecture Slide- 6

Lecture Slide- 7

Class Discussion Lecture-4

Class Discussion Lecture-5

Class Discussion Lecture-6

Class Discussion Lecture-7 (part-1)

Class Discussion Lecture-7 (part-2)

Assignment-1 ( ER Diagram Drawing)

ER Diagram Example

Discussion Forum

Week 3

Lecture Slide-8

Lecture Slide-9

Scenario to ER Diagram

Class Lecture-8 ( ERD to Schema)

ER to Schema Mapping (Video Lesson)

Lecture Slide-10

Class lecture-10

Class lecture-10- (Part-1)

Class lecture-10- (Part-2)

Assignment-2 (ER to Schema Mapping)

Homework (Relational Algebra)

Week3 Discussion Forum

Quiz-1

Quiz-1 for Section-O2

Week 4

Lecture Slide-11

Class Lecture-11

Week-4-Assignment (Create Database and Relation)

Discussion Forum

Week 5

Lecture Slide-12

Class Lecture-12

Extra Resource- Join Operation Example

Discussion Forum

Week 6 (Basic SQL Queries)

Lecture Slide-13

Class Lecture-13

SQL queries in Database

Discussion Forum Week-6

Week 7

Lecture Slide-14

Class Lecture- 14

Numeric Functions, Date &amp; Time Functions File

Week-7 Discussion Forum

Quiz-02

Quiz-2 Eve Section O2

Midterm Week (Week 8)

Mid Term Examination Fall-2020 (O-2) Assignment

Online Exam Response Submission Template Fall-2020 (Answer Script)

[Google Form] Mid Exam Answer Script Submission for O-2 Section

Week 8 (Nested Queries)

Lecture Slide-15

Lecture Slide-16

Class Lecture 15 &amp; 16

Week-8 Feedback Assignment

Week-8 Discussion Forum

Week 9 (Stored Procedure and Normalization)

Lecture Slide-17

Class Lecture-17

Lecture Slide-18

Extra Resource: Normalization

Class Lecture- 18

Numeric Functions, Date & Time Functions File

Class Lecture 15 & 16