You are contracted by Rose Garden Elementary to develop a Management System for the school. Your first task is to design a database structure for this System. Specifically, the database would need to be able to record the following things: Student: information about students, like ID, name, date of birth, address, phone, family name, family ID, class ID and enrolment date; Remember some students may have siblings in the same school, you need to consider that as well. this entity/table must be connected to class. Class: in a primary school a class will be usually allocated to the same teacher and teacher assistant for the whole year; you need to have a unique ID and unique name for each class, teacher ID, teacher assistant ID and total number of students. class is connected to both classroom and to subject. Think carefully about the relationship between class and subject, a class may offer more than one subject and a subject can be taught to more than one class. Subject: subject will have unique ID, title, description of the subject and pre requirements; usually in primary school the subjects are limited to English,Mathematics, Science, Technology, Art, Physical education and Language other than English, these subjects are taught across almost all years levels, which means the title will not change only the materials taught will be different. Prep and year one may not learn all the subjects since the focus of education is mainly on English,Math. Art and physical Education. Classroom: classroom will have unique ID, classroom title/ID, capacity, classroom might be for art or music or just a normal classroom, so the type of the classroom needs to be specified, also some classrooms have different facilities than others, this need to be considered as well; classroom must be connected to the class entity. Teacher: include all the teachers information including unique ID, full name, classes being taught ...etc, make sure that the teacher is linked to class. Grades: include information about each student's grades, for each subject, in each year of study; it should also include information about each students performance (level of performances are A, B, C, D, E) in the current year, for each subject with feedback and comments from the teacher, this entity is linked to subject and student entities. Staff: information about all the staff including the teachers and Teachers assistant, information in this entity should include staff ID, full name, address, ..etc. Also job title (admin, teacher, TA, manager), salary and qualification . Family: all information related to each family that has kids in the school,information should include each parents name and contact details and number of kids enrolled in the school. Each family must have a unique family ID. Payments: information about payment made by families for school fees, family ID, and student ID must be included, also date amount, any due payment, general comments...etc Please note: each entity must have a unique ID which will be the primary key , also add comments attribute to each entity, to record any information related to that entity.

Task Your task is to develop an Entity-Relationship Diagram, Relational Model, and Data Dictionary for the scenario. Specifically, you must follow these rules: ER Diagram Create an entity-relationship diagram using any drawing software of your choice. Your ERD must include all entities mentioned in the scenario. You are free to add more if you wish. Each entity must have at least 3 attributes excluding keys and the ones explicitly mentioned in the scenario. Note: remember to convert any many-to-many (M:N) relationships into composite entities. Note: remember to add in your primary and composite keys for all entities in your diagram. Relational Model Convert your completed ERD to a Relational Model using Excel or LibreOffice Calc. Make sure your Relational Model is normalised to the 3rd normal form (3NF). Note: you don't need all the previous forms evident, just 3rd normal form (3NF). Include a minimum of 10 tuples of data in each table.

Note: remember to add in all your foreign keys at this stage. Hint: The foreign key is added to the table that sits on the Many to the One side. So many things should relate (foreign key) to one thing. Data Dictionary Create a data dictionary for all your attributes using Microsoft Excel or LibreOffice Calc. Your data dictionary must include the following: