Design and implement a database system for a language learning institution. The institution serves student needs by linking them with specialized language teachers. Students can easily locate teachers skilled in their desired languages. They are able to search for teachers based on their proficiency (areas of expertise). These areas of expertise can also be broken down into subcategories. The institution further allows students to arrange one-on-one sessions, ensuring tailored assistance that matches their language learning objectives. To maintain transparency, students have the option to rate and provide feedback on teachers based on their performance. This platform focuses on personalized learning and thorough categorization of language expertise. Answer: Give the tables, column names, and provide sample data for each table. Draw an ER diagram that represents the tables, relationships, participation types, participation degrees, and deletion rules. Provide justification for your design choices.

Design and implement a database system for a language learning institution. The institution serves student needs by linking them with specialized language teachers. Students can easily locate teachers skilled in their desired languages. They are able to search for teachers based on their proficiency (areas of expertise). These areas of expertise can also be broken down into subcategories. The institution further allows students to arrange one-on-one sessions, ensuring tailored assistance that matches their language learning objectives. To maintain transparency, students have the option to rate and provide feedback on teachers based on their performance. This platform focuses on personalized learning and thorough categorization of language expertise. Answer: Give the tables, column names, and provide sample data for each table. Draw an ER diagram that represents the tables, relationships, participation types, participation degrees, and deletion rules. Provide justification for your design choices.