construct an ESG of the college database for the entities specified above.

Write SQL statements to create these tables in your schema of the class database. You may add additional attributes to the structure of each database table as you deem appropriate. Store these statements in an SQL script file.

Use your SQL script file to create the tables in the class database.

Populate your tables with sample data (at least six records per table).

Relation Attributes {Stud#, StudFName, StudL Name, Student StudSex, StudAddr, StudPgm#, StudHall#, StudDoB...} Academic Program {Pgm#, PgmName...} Hall {Hall#, HallName ...} {Dept#, DeptName, DeptHead#, Department DeptDiv# Staff (Staff#, StaffName, StaffDept# ... Course {Crs# CrsName, Crs Dept# ...} Primary key Foreign Key StudPgm#references [Stud#] Academic Program.Pgm# StudHall#references Hall. Hall# [Pgm# None [Hall# None DeptHead#references Staff.Staff# [Dept# Dept Div#references Division.Div# (Staff None [Crs# None PSPgm#references [PSPgm# PSCrs# Academic Program.Pgm# PSCrs#references Course.Crs# [Div# Div Head#references Staff Staff# Pgm_Struct {PSPgm#, PSCrs#, PSCrsSegn} Division {Div#, DivName, Div Head# ...} Each relation and each attribute would need additional clarification prior to database construction and table creation