Dalhousie University | Summer 2021 | CSCI5408 | DMWA (Data Management, Warehousing and Analytics)

All five assignments, and the final group project is done in class CSCI5408(Data Management, Warehousing and Analytics) Summer 2021 of MACS at the Dalhousie University.

Authors

• Dhrumil Rakesh 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.
  📄 Problem Statement PDF
  

Assignment 2

• The objective of this assignment is to understand research and industry problems related to distributed database operations, and transactions management.
  📄 Problem Statement PDF
  

Assignment 3

• The objective of this assignment is to understand Big Data processing problems, and NoSQL database (document, and graph).
  📄 Problem Statement PDF
  

Assignment 4

• The objective of this assignment is to understand BI framework, creating star/snowflake schema, and concept of sentiment and semantic analysis.
  📄 Problem Statement PDF
  

Assignment 5

• The objective of this assignment is to understand Database Administration, and Database Security.
  📄 Problem Statement PDF
  

Final Project (Final Group Project | DP-25)

DVM Relational Database Management System

• A simple custom relational database and its management system developed by DP-25.
  📄 Final Project Requirements Statement PDF
  
• Team Members:
  • Dhrumil Rakesh Shah
  • Manraj Singh
  • Vishvesh Naik
• Project Features:
  • Multi-factor authentication (Password Encryption)
  • Query Parser (For DDL, DQL, DML and TCL Queries)
  • Query Processor (For DDL, DQL, DML and TCL Queries)
  • All Databases Generator/View
  • All Users View
  • SQL Dump Generator/View
  • SQL Dump Import
  • ERD Generator/View
  • Log Generator/View
    • General Logs
    • Query Logs
    • Event Logs