Hospital Database w/ MySQL (Team Project)

Plan

• Week 1 & 2 (Feb 21 - Mar 7)

  • Design ERD Diagram
  • Design EERD Diagram
  • Finalize Both Designs

• Week 3 (Mar 7 - Mar 14)

  • Familiarize Ourselves With MySQL
  • Create Database (Rough Draft)
  • Discuss Populating Database
  • Issue 1 Establishing Super and Sub Type relationship
  • Issue 2 EERD and ERD Needs some refinement

• Week 4 (Mar 14 - Mar 21)

  • Finalize Database
  • Populate Database
  • Start Practicing Queries
  • Determine how to Present Project

• Week 5 (Mar 21 - Mar 28)

  • Create Presentation
  • Finalize Presentation
  • Practice Presentation
  • Finalize Database Creation/Population
  • Keep Practicing Queries
  • Issue 1 Extra Spacing with Values Causes Issues

Team members

• Zack Rosa
• Leon Chen
• Brendan Dao

Comments

1. Presentation Date : 03/27/19 (Wednesday)
2. Due Date: April 5th (Friday)
3. Required Pieces: Proposal, ERD, Relational Model(EERD), DDL(Table Creation), DML(Inserted Value), PowerPoint