Lab 1 Case Study:

Making the grades-ERD Case description:

Making The Grade a non-profit organization that helps students learn how to achieve better grades in schools. The organization has 40 offices in 25 states and more than 2,000 employees. The company wants to build a website to offer its services online. Making the Grades online services will provide parents seven key pieces of advice for communicating with their children to help them achieve academic success. The website will offer information on how to maintain open lines of communication, set goals, organize academics, regularly track progress, identify trouble spots, get to know their childs teacher, and celebrate their childrens successes.

1. Create am ERD to show how would you track the above information.

2. Show entity names, primary keys, attributes for each entity, relationship between entities and cardinality.

Tools/Software: You can use LucidChart, Miro, Visio or any other tool that is convenient to you (even pen and paper)