Ignore question 1,2, and 3

Exam II (4s points total), C 00, Spring 2017 soelal tartwoek application. NAME DDL eript creat The following SQL Prof create table key (10) Pr rsrat Name C20). lastName archar(20) dob date email varchar cao) create table id char C10 friend ID char (10) tablished date, constraint pak primary key (userid, friend ID) unerProfile(id). fk1 foreign key userid) references constraint fk2 foreign key CfriendID) references userProfile(id) create table activity act ID char (20) primary key. topic varchar (20), description varchar (100) location varchar C20). Activity Date date hostUser char (10) foreign key ChostUser) references userProfile Cid) create table activityParticipationC actID char (20), userID char (10), commitment Date date special Note varchar (50), primary key (actID,user ID), foreign key CactID) references activity CactID), foreign key (userID) references userProfile id) create table friendReferral user char (10), friend ID char (10), referralFriendID char (10), referralDate Date, friendID,referralFriendID) primary key (user ID, foreign key (userID) references userProfile(id), foreign key (friendID) references userProfile(id), foreign key (referralFriendID) references userProfile id) create table post post ID char (50) primary key, userID char (10), postDate date, content varchar (150), foreign key (userID) references userProfile (id)