School Database

  1. Design a database to represent the typical entities in a public school. Begin with a brainstorming in teams of two or three to come up with all the required entities and their properties. Draft an ERD on paper including the relations' fields, data types and the references between them.
  2. Using your favorite database tool, create the database and all relations in your main DBMS.
  3. Insert testing data using insert into.
  4. Test the references by trying to delete or update records that affect the foreign key fields.