A. Final Project TeamProject Custom Schema: 200 points Extra Credit

Group of 3 people: 

• Designer and Developer ( ERD, tables, data )
• Team Leader/Power User ( Business Questions/Queries, Real Life Implementation Strategy )

 

        Design and develop database for imaginary business. Create tables in our shared GGU MySQL server. The created schema must be normalized and populated. Examples of imaginary business could be Pizza with Delivery,  Hospital,Vet Clinic, Insurance Company, etc.

 

•  The schema will include an Event table (Order, Appointment, Delivery, Claim) with min 300 records for 2 years of data and 4-6 Master tables with a min of 30-50 records. 

Note: ERD Model must be approved by the instructor by the week 8  or 9. ( No credits for unapproved model )