sunjaree / database_systems-cse311l-lab_works-nsu Goto Github PK

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: [email protected] and [email protected])

• 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.

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

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

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

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

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 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.

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

• Marks: (Updated Here)
• Class Lecture:
• Lab Code: https://github.com/aaneloy/CSE311L-Section-2-Fall20-NSU/tree/master/Course%20Material/Codes

Will update later

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

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.