Homework Assignment 2

I need whoever will be working on this assignment, to be proficient at IT Database Management (which is what the course is in). This is the description of the course:

This course examines the methodologies of database management including data models, database design, normalization, SQL/ PLSQL, NoSQL, performance and reliability, distributed database, data dictionaries, data integrity, security, and privacy. Numerous hands on problems/projects are assigned throughout the course.

Review the attached case study –  Smile Land Academy.pdf Download Smile Land Academy.pdf (attached)
Based on the information provided in the case study,

Document all the business rules for the Smile Land Academy. You are allowed to make reasonable assumptions as long as you state them clearly in your answer. (15 points).

See section 2.4 in your textbook on how to write business rules. 
Examples of business rules are as follows:   A customer may generate many invoices.  An invoice is generated by only one customer.  A training session cannot be scheduled for fewer than 10 employees or for more than  30 employees.  Note that those business rules establish entities, relationships, and constraints. For  example, the first two business rules establish two entities (CUSTOMER and INVOICE)  and a 1:M relationship between those two entities. The third business rule establishes  a constraint (no fewer than 10 people and no more than 30 people) and two entities (EMPLOYEE and TRAINING), and also implies a relationship between EMPLOYEE and TRAINING. 
Coronel, Carlos; Morris, Steven. Database Systems: Design, Implementation, & Management (p. 38). Cengage Learning. Kindle Edition. (Book)

Identify and list the main entities, relationships and constraints from the business rules (15 points).
Use Visio to create an appropriate (and fully labelled) Crow’s Foot ERD that documents the requirements to support Smile Land Academy database needs. Follow all rules and practices discussed in the textbook. Include all entities, relationships, optionalities, connectivities and participants (20 points).