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:
- XAMPP - https://www.apachefriends.org/download.html
- VS Code - https://code.visualstudio.com/download
- Git SCM - https://git-scm.com/downloads
- Github Desktop - https://desktop.github.com/
- Sublime Text - https://www.sublimetext.com/3
Submission Guideline:
- 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)
- Signup for Github Education Pack, make sure you have
badge in your profile.
- Install the required software. (For Github Desktop, see this - https://www.youtube.com/watch?v=dL6t3jAA05w)
- 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. - Open the Repo. (
cd <Repo Directory>) - Put your code in the appropriate Folder.
- Add files to your Repo (
git add .). - Commit using a appropriate comment (
git commit -m "Homework 1 submission"). - Push to master Repo (
git push origin master). - Check your file is submitted or not.
Submission Links:
Lab Resource:
- Marks: (Updated Here)
- Class Lecture:
- Lab Code: https://github.com/aaneloy/CSE311L-Section-2-Fall20-NSU/tree/master/Course%20Material/Codes
Project
Will update later
Github Instructions:
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.
