Q1: Design a relational schema for the E-R Diagram below

Please use the Relational Schema diagramming tool of ERDPlus to build the relational schema for the following ERD

Q2: Design a relational schema for the Enhanced E-R Diagram (including the specialization of students) below (50 points)

Please use the Relational Schema diagramming tool of ERDPlus to build the relational schema for the following ERD

See below for attributes.

The attributes identified for the entities are:

Person: pId, name, address, phone

Student: credits, yearStarted

Undergraduate: major

GraduateStu: program

Club: clubName, budget, meetingDay

Activity: activityId, type, date, time, location

StudentAdvisor: department, title

ThesisAdvisor: researchArea

Moderator: position

BelongsTo relation: dateJoined

nsID Date Next INSPECTOR InsName Date Last Inspects AptNo AN0Of Bedrooms Building ID BUILDING APARTMENT Leases Located (5,10) BNoOfFloors Manages Resides In Cleans MSalary (1,2) MANAGER ManagerID STAFF MEMBER MBonus (O (MFul Name) MPhone SMembID MBDate MFName MAge MLName SysDate-Birthdate CCIndustry CC Name CC Location CCID CORPCLIENT Refers SMemb Name