Question: School Management Database Project: A new private school that just opened up in your neighborhood is in need of a database to maintain some information
School Management Database Project:
A new private school that just opened up in your neighborhood is in need of a database to maintain some information about the school. To simplify things for this project, lets assume the new database for this school must keep track of the following: Staff id, name, and classes they are teaching
Student name, roll no, section, class Another table containing section, subject and teacher information
Fee information for students Salary information for teachers Rooms assigned to classes with no time clash of same room or lab Students cannot be entered in more than one section No student should be in school who have not paid fees up to a particular date
List entities, attributes, relationship and Cardinality.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
