Project Overview

In real-world engineering, tasks are often defined by high-level requirements rather than detailed, step-by-step instructions. This project mimics such scenarios, challenging you to design and implement software applications by applying your knowledge, creativity, and problem-solving skills. While you have the flexibility to choose your implementation approach, you must adhere to key technical guidelines and overarching project requirements.

Project Description

You will work with legacy flat structured healthcare system data. The data contains key information around doctor appointments.

Your task is to transform this raw data into a structured database schema. Specifically, you will process and normalize the data into a snowflake schema, creating an optimized structure that supports efficient querying and data management.

Datasets

You will work on different datasets individually. The link to the datasets is provided here, and your dataset ID remains the same as Project 2. Submission with wrong dataset is not accepted.

Requirements and Grading Rubric (100 points)

Note: Pandas package is not allowed for processing data

1. Standup Meeting (15)

• Standup meeting time: April 1st in class
• Check in: 12:35 pm
• Technical briefing: 2-5 minutes per person
  • Project you are working on?
  • What is the progress?
  • What is your challenge?
  • Expected deliver time.

2. Data Normalization Requirements (55)

• Generate CSV files for all 11 tables in the schema
• Column sequence and name must match the schema provided below
• The primary key of different tables can either be string or integer (even if they have different types in the diagram)
• Save results to CSVs using the helper function provided in previous projects, results save as <filename.csv> folders are not accepted
• Diagram PNG file can be found here for better view
• Patient status:
  • Active
  • Inactive (have not visited since end of 2021 — last day in 2021)