Exam II (4s points total), C 00, Spring 2017 soelal tartwoek application. NAME D

Question

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)

Explanation / Answer

1. select concat(firstName,lastName) as FullName from userProfile,activity where topic='CIS3100' and ActivityDate='April 20,2017' and location='New York' and userProfile.id=activity.hostUser;

2.select concat(firstName,lastName) as FullName from userProfile,activity a,activityParticipation where commitmentdate='April 20,2017' having distinct(a.location);

3. select concat(firstName,lastName) as FullName from userProfile,friendRefferal where friendReferral.userID=userProfile.UserID having count(f.friendID)>=100;

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.