The following is a database design about students, who may major and minor in zero or more areas, where each area belongs to one school. The following ER diagram shows the idea: Nane Nane Age id Name Id Id Gender Student Majors) Area - Belongs)-- School Minors Clearly, all together 5 tables will be needed. The following are the SQL statements to create some of these 5 tables: CREATE TABLE School ( INTEGER PRIMARY KEY, Id Name VARCHAR (45) UNIQUE NOT NULL CREATE TABLE Area ( INTEGER PRIMARY KEY, Id Name VARCHAR (25) UNIQUE NOT NULL, School INTEGER NOT NULL REFERENCES School (id) ON DELETE CASCADE CREATE TABLE Majors ( Student INTEGER REFERENCES Student (Id) ON DELETE CASCADE, Area INTEGER REFERENCES Area (Id), PRIMARY KEY (Student, Area) CREATE TABLE Student ( INTEGER PRIMARY KEY Id Name VARCHAR (30) NOT NULL Age INTEGER NOT NULL, Gender CHAR (1) NOT NULL CHECK (Gender IN ('M,F CREATE TABLE Minors ( Student INTEGER