Based on: 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 Show the Relational Algebra AND Domain Relational Calculus formulas for each. Show a portfolio of the Flubs by a Professor Show a portfolio of all Flubs and Bounces (the Flubs bounced) by all of a Professor's Colleagues
Based on: 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 Show the Relational Algebra AND Domain Relational Calculus formulas for each. Show a portfolio of the Flubs by a Professor Show a portfolio of all Flubs and Bounces (the Flubs bounced) by all of a Professor's Colleagues
Chapter1: Overview Of Database Concepts
Section: Chapter Questions
Problem 3MC
Related questions
Question
Based on:
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
Show the Relational Algebra AND Domain Relational Calculus formulas for each.
- Show a portfolio of the Flubs by a Professor
- Show a portfolio of all Flubs and Bounces (the Flubs bounced) by all of a Professor's Colleagues
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
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.Recommended textbooks for you