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_DateThere 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 FlubAdd ID attributes as necessaryContent of Flubs only needs to be a text of fixed lengthProfessors 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 ProfessorChanging a specific Professor's Professor_NameRemoving a Flub by IDShow a portfolio of the Flubs by a Professor in reverse chronological orderShow how many Bounces and how many Citations a Flub of particular ID hasShow 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.)

Solution 1 - An E-R diagram is created by given requirements as- ER-Diagram: The diagram up above…

Answered: Based on the following…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

100%

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.)

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions