Answered: Based on the following…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

Based on the following Entity-Relationship Diagram with the following requirements:

There are Professors (ie users) with the changeable attributes Professor_Name, Field, College, PhD_Date
There are Flubs (ie posts) with the unchangeable attributes Content, Purpose, Moment, Inventor (which is the creating Professor)
There are Bounces (ie shares) where a Professor can share another Professor's Flub
Add ID attributes as necessary
Content of Flubs only needs to be a text of fixed length
Professors can have/be Colleagues (ie friends/followers)
A Flub can get Citations (ie likes) by other Professors

Write the necessary SQL Queries for the following functions.

Adding a new Professor
Changing a specific Professor's Professor_Name
Removing a Flub by ID
Show a portfolio of the Flubs by a Professor in reverse chronological order
Show how many Bounces and how many Citations a Flub of particular ID has
Show a portfolio of all Flubs and Bounces (the Flubs bounced) by all of a Professor's Colleagues in reverse chronological order

(Should run in MySQL.)