/CSE311L-Section-2-Fall20-NSU

This is the official Github Repository for CSE311L: Database Systems Lab, Section 1, Summer 2020. All course-related materials and Code submission will be facilitated here.

Primary LanguagePHPMIT LicenseMIT

Department of Electrical and Computer Engineering

CSE311L: Database Management System Lab - Section 2 (Fall'2020)

This is the official Github Repository for CSE311L: Database Systems Lab, Section 2, Fall 2020. All course-related materials and Code submission will be facilitated here.

Instructor: Asif Ahmed Neloy (email: asif.neloy@northsouth.edu and neloyn@myumanitoba.ca)

Office Hour:

  • Monday: 8.00 pm to 9.00 pm.
  • Google Meet link - https://meet.google.com/rur-qvjr-zsv
  • P.S. Make Sure you have studied the class lecture and slides, and the questions are well prepared before joining.

Course Description: (Outline - Here)

This course introduces students with database management systems for the first time in their undergraduate study. Drawbacks of flat file system are demonstrated and advantages of relational database systems are introduced. The course examines the logical organization of databases: the entity-relationship model; the hierarchical, network, and relational data models and their languages. Functional dependencies and normal forms are discussed. Design, implementation, and optimization of query languages; security and integrity; concurrency control, different level of indices, e.g., tree and hash-based indices are introduced. Access costs are compared for different alternatives. This course has separate mandatory laboratory sessions every week in a separate course CSE 311L which has 0 credits, but the students (in group) use hands on SQL queries and as a culmination, they build a full-fledged database system including a front end. The evaluation of the lab works is carried over to the theory part of the course

Lab Hours:

  • Saturday: 8.00 am to 11.10 pm.
  • Lab will start from 8.30 am and attendance will be taken on 8.45 am

Mark Distribution:

Assignment(6): 20%
Lab Assessment(6): 20%
Quiz (6): 10%
Midterm Exam (1): 25%
Final (1): 25%

The marks distribution may change according to the discretion of the instructor.

Tentative Class Schedule:

Week Lab Syllabus Date
Week 1 & 2 Lab 1 Introduction to Github and SQL 07.11.2020
Week 3 Lab 2 SQL Syntax and XAMPP introduction with GitHub 14.11.2020
Week 4 Lab 3 SQL Commands, basic operations 21.11.2020
Week 5 Lab 4 Table Joining 28.11.2020
Week 6 Lab 5 Table Grouping and Conditions 5.12.2020
Week 7 Lab 6 Mid-Term 12.12.2020
Week 8 Lab 7 Subquery, Submission deadline of Project Phase -1 19.12.2020
Week 9 Lab 8 SQL table manipulations 26.12.2020
Week 10 Lab 9 No-SQL, Submission deadline of Project Phase -2 02.01.2021
Week 11 Lab 10 Lab-Final 09.01.2021

Required Software:

  1. XAMPP - https://www.apachefriends.org/download.html
  2. VS Code - https://code.visualstudio.com/download
  3. Git SCM - https://git-scm.com/downloads
  4. Github Desktop - https://desktop.github.com/
  5. Sublime Text - https://www.sublimetext.com/3

Submission Guideline:

  1. Signup Github by using your NSU email address and verify the email. Your Github Name should be - NSU_ID - Last_Name (e.g. - 1510839042-Neloy)
  2. Signup for Github Education Pack, make sure you have Pro badge in your profile.
  3. Install the required software. (For Github Desktop, see this - https://www.youtube.com/watch?v=dL6t3jAA05w)
  4. Open Git command prompt (Git Bash Here) and Clone this Repo (git clone https://github.com/aaneloy/CSE311L-Section-2-Fall20-NSU) and make it private.
  5. Open the Repo. (cd <Repo Directory>)
  6. Put your code in the appropriate Folder.
  7. Add files to your Repo (git add .).
  8. Commit using a appropriate comment (git commit -m "Homework 1 submission").
  9. Push to master Repo (git push origin master).
  10. Check your file is submitted or not.

Submission Links:

  • Homework: (Submission Link)
  • Lab Assessment: (Submission Link)

Lab Resource:

Project

Will update later

Github Instructions:

  1. Github Basic Guide.
  2. Github for beginners.
  3. Starter Information.
  4. Upgrading to pro.
  5. Git CheatSheet.

License 📄

This work is dual-licensed under MIT and CC BY-NC-SA 4.0. You can choose between one of them if you use this work.

License: MIT License: CC BY-NC-ND 4.0