In this project, you will design and implement a database to a Kindergarten (pick a name). This
Question:
In this project, you will design and implement a database to a Kindergarten (pick a name). This database will be used to store/maintain various types of data to help run the business. This database should help the Kindergarten management/staff to store, retrieve and modify students and employees information, financials, health records, inventory record
• What data will your database store? You can list a preliminary set of entities/attributes that will be in the database, no relationships required at this time. Keep in mind that it is likely that your entities/attributes will be incomplete and will be changed later.
1) Project goals.
2) Database description: A general description of the database, what data is stored in the database. How the database will benefit the users.
3) Data model & design:
o Completed ER/EER diagram, 5 tables minimum
MUST use https://www.draw.io to draw the ER diagram, and then take a snapshot.Include a snapshot of the diagram in the report.
o Business rules.
o Data dictionary: For each one of the tables, list columns, data types, column restrictions, column descriptions.
Implementation:
o Use MySQL Server and MySQL Workbench to create the database/tables. Include a snapshot of the SQL code in your report
o Populate the each table with a minimum of 20 rows of sample data. Make sure the entered data is descriptive (not just random numbers and letters. Include a snapshot of the SQL code in your report.
o Use MySQL Server and MySQL Workbench to write/run the SQL queries below. For each query, provide the following in Report 2:
Snapshot of the code and the output in the report.
In about 2 lines, explain what the query return
Business Analytics Methods Models and Decisions
ISBN: 978-0321997821
2nd edition
Authors: James R. Evans