Note: Please place all answers in a single document

The (cross-section of the) college database discussed in lecture 7 is repeated here.

Based on the principles of database design discussed in lectures 4 and 5, construct an ESG of the college database for the entities specified above. [50]

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. [40]

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

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

Note: Your sample data must reflect the interrelatedness among various relations in the database. You will submit your SQL script file which must have syntactically correct SQL statements. As part of the evaluation, your database schema will be checked for these tables.

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