Jun - 2024 Feb 16

[JunChoii]

Designing database:

• Made ERD
• Fixed user table : separate user and usertype -> have user table and usertype table
• Fixed organization table : separate organization and organizationtype -> have organization and organizationtype tables
• Fixed vehicle table : model and make are separate table now -> make in the model and model is in vehicle
• Fixed account/subscription table : separate account/subscription and account/subscriptiontype -> have account/subscription and account/subscriptiontype tables

Researched on dimensional database modeling

Working on:

• Looking into figma prototype
• Separating numercal data and textual data
• Form them into facts and dimensions
• Visualize it (diagram?)