Conceptual Model, ERD, and SQL

1. 50% – Using the attached conceptual data model for a public health database that allows community members to register for public health events such as wellness and education activities, create a physical data model, otherwise known as an Entity Relationship Diagram. Include the following components:
A summary of the purpose of your database based on your interpretation of the conceptual data model
Business rules that you determine to be needed
All relevant parameters typically found in an ERD such as but not limited to relationships, keys, data types, and cardinality
Combine into one document that is clear, professional, and easy to read and understand
2. 50% – Using your ERD from part 1, create the following and screenshot each after completion:
3 Tables with data in a CSV format that are imported into MySQL via SQL workbench. Include 5 test records for each table with some persons that attend no events, some that attend one event, and some that attend 2 or more events.
Using SQL, extract a list of persons that meet a criteria such as last name equals or last name starts with.
Using SQL, extract all persons that did not register for an event by joining the 2 tables needed to determine this and using the appropriate type of join.
Combine all screenshots of CSV files, tables inside of MySQL, query syntax in workbench, and results into one document that is clear, professional, and easy to read and understand.

Take both documents and combine them into one document (either word, pdf, or PowerPoint) and submit. This should be at the graduate level for writing including APA style format.

Last Completed Projects

topic title academic level Writer delivered