Dalhousie University | CSCI 5408 | DMWA (Data Management, Warehousing and Analytics)

All assignments and the final project are completed in class CSCI 5408 (Data Management, Warehousing and Analytics) of MACS at Dalhousie University. CSCI 5408 DMWA Dalhousie University.
Final Letter Grade Received: A+

Authors

• Dhrumil Amish Shah - (Creator)

Assignments

Assignment 1

• The objective of this assignment is to understand industry problems related to data capture, and database design. Create entity relationship model and perform normalization of the database.
• Assignment 1 GitHub: Assignment 1
• Weight Achieved: 10/10
• Grade: 100%

Assignment 2

• The objective of this assignment is to understand research and industry problems related to distributed database operations, and transactions management.
• Assignment 2 GitHub: Assignment 2
• Weight Achieved: 10/10
• Grade: 100%

Assignment 3

• The objective of this assignment is to understand Big Data processing problems, and NoSQL database (document, and graph).
• Assignment 3 GitHub: Assignment 3
• Weight Achieved: 10/10
• Grade: 100%

Assignment 4

• The objective of this assignment is to understand BI framework, creating star/snowflake schema, and concept of sentiment and semantic analysis.
• Assignment 4 GitHub: Assignment 4
• Weight Achieved: 10/10
• Grade: 100%

Assignment 5

• The objective of this assignment is to understand Database Administration, and Database Security.
• Assignment 5 GitHub: Assignment 5
• Weight Achieved: 10/10
• Grade: 100%

Final Group Project

• Project Description: A simple custom relational database and its management system developed by DP-17.
• Inception Year: 2021
• Team Name: DP-17
• Team Members:
  • Dhrumil Amish Shah
  • Jaspreet Kaur Gill
  • Samiksha Narendra Salgaonkar
• Project Features:
  • Multi-factor authentication
  • Query Parser (For DDL, DQL, DML and TCL Queries)
  • Query Processor (For DDL, DQL, DML and TCL Queries)
  • Data Dictionary Generator/View
  • Meta Data Generator/View
  • SQL Dump Generator/View (SQL Dump Export)
  • SQL Dump Import
  • ERD Generator/View
  • Log Generator/View
    • General Logs
    • Query Logs
    • Event Logs
• Final Group Project GitHub: Final Group Project
• Group Project - Phase 1:
  • Feasibility Study Report:
    • Weight Achieved - 2/2
    • Grade - 100%
• Group Project - Phase 2:
  • Weight Achieved - 19.55/20
  • Grade - 97.75%
  • Project Report:
    • Weight Achieved - 4.75/5
    • Grade - 95%
  • Project Go-Live:
    • Weight Achieved - 9.8/10
    • Grade - 98%
  • Project Closure Q & A:
    • Weight Achieved - 5/5
    • Grade - 100%