COP 3540 Introduction to Database Structures Spring 2018 Sample Mid Term Exam Na

Question

COP 3540 Introduction to Database Structures Spring 2018 Sample Mid Term Exam Name Grade: 100 2. 30 points) A c called AskU2DB ?? a Q&A; website that host discussions for database related questions. The following relations describe this service where users can ask guestions, post anewers and vote for the moet helpful answer. UeerProfile Table Answer Table 29 Qoeston Table 00942 table or viev does not exist I can not access solpius anmore...My Dasso .UserProfile Table information about the users of this website where reputation is degree to hich the website commumity trusts that user Question Table: information about who posted a question Answer Table Ifomation about who answered the qestions where votecou is many sers voted for that arswer as belng belpfi

Explanation / Answer

1)Select * from UserProfile where reputation >= 250;
2) SELECT UserID
FROM UserProfile
INNER JOIN Answer
ON UserProfile.UserID = Answer.UserID and Answer.vote_count<50;
3)SELECT UserID
FROM UserProfile
INNER JOIN Questions
ON UserProfile.UserID = Question.UserID and UserProfile.UserID='U5';

4)SELECT Titles
FROM Questions
INNER JOIN UserProfile
ON Question.UserID=UserProfile.UserID and UserProfile.reputation>50;

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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