This week, you will develop a database for a fictitious small school for its management of student records. You will also be required to write SQL statements to answer a few questions. Your instructor is the product owner. Post questions for approval before making any assumptions.

The business description is outlined in Section 8.1 of your textbook. Your tasks include the following:

1. Write business rules based on the given business description in an MS Word file named Item1.
2. Draw a logical ERD that follows the business rules. Save the drawing in a jpg, png, docx, or pdf file. Name the file Item2.
3. Map the logical ERD to relations by using the relational schema format. An example of a relation in relational schema format is:

   Student (StudentId, FirstName, LastName, MiddleInitial, AdvisorId)

   Use bold to indicate PK and italic to indicate FK. Use both bold and italic to indicate a field that is both PK and FK.

   Save the relational schema in an MS Word file named Item3.

4. Complete physical design by writing T-SQL code to generate the database and tables. Save the sql file with sql file extension and named Item4.sql. This file must include all code to create the database with schema and tables in just one click to run. It must include the drop database line as shown in the book.
5. Answer all six questions outlined in Section 8.8 of your textbook. Save all six sql statement in one sql file with the name of Item5.sql.

Chapter 8: A Project and SQL CREATE Statement donations from individuals, private businesses, and institutions. Its activities are also supported by volunteers. Each year, it offers 50+ Chinese Language classes for Chinese-speaking and non-Chinese- speaking children and adults. PLS also provides over 100 Chinese Arts/Culture, sports, math and college preparation, and specialty training courses, as well as a variety of club activities. The school opens from 10:00am to 7:00pm on weekends and most holidays as well as selected evenings from 5:00pm to 7:00pm on weekdays. PLS is the largest Chinese School in the tri-state area. PLS strives to continue serving as the best place for students to learn the Chinese language, arts, and culture. The following describes how the business is run related to the database they want. A new family needs to fill out a form like the following (bottom part is cut off due to the size limit) 8.1 Develop a relational database with the given business description. 8.2 Summarize the processes of database development. 8.3 Implement physical design with an appropriate Transact-SQL data type. 8.4 Write Transact-SQL statements to produce database and tables with the given ERD. 8.5 Write SQL statements to work with a database you created. 8.1 A Project -- The Panda Language School (PLS) Business Description The Panda Language School, founded in 1994, is a non-profit organization. The primary mission of PLS is to provide an avenue for students of all ages and ethnic backgrounds to learn the Chinese language, arts, and culture. Most students are children age 5 to 15. PLS is operated in its 50,000 square feet facility and its financial support is mainly from tuition and 276