need help to draw the ERD diagram for this:  Revised Entity-Relationship Diagram (ERD) Proposal: Entities and Attributes: Users: UserID [PK] Username Password (Hashed and Salted) Email ProfilePictures: (New Entity) PictureID [PK] UserID [FK] PictureData (Reference/Path to Image File) Recipes: RecipeID [PK] UserID [FK] Title Description Image (Reference/Path to Image File) Ingredients: (Potential New Entity) IngredientID [PK] RecipeID [FK] Name Quantity Unit Comments: CommentID [PK] UserID [FK] RecipeID [FK] CommentText Timestamp Relationships: Users to ProfilePictures: One-to-One Users to Recipes: One-to-Many Recipes to Ingredients: One-to-Many Users to Comments: One-to-Many Recipes to Comments: One-to-Many

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
icon
Related questions
Question

need help to draw the ERD diagram for this: 

Revised Entity-Relationship Diagram (ERD) Proposal:

Entities and Attributes:

  • Users:

    • UserID [PK]
    • Username
    • Password (Hashed and Salted)
    • Email
  • ProfilePictures: (New Entity)

    • PictureID [PK]
    • UserID [FK]
    • PictureData (Reference/Path to Image File)
  • Recipes:

    • RecipeID [PK]
    • UserID [FK]
    • Title
    • Description
    • Image (Reference/Path to Image File)
  • Ingredients: (Potential New Entity)

    • IngredientID [PK]
    • RecipeID [FK]
    • Name
    • Quantity
    • Unit
  • Comments:

    • CommentID [PK]
    • UserID [FK]
    • RecipeID [FK]
    • CommentText
    • Timestamp

Relationships:

  • Users to ProfilePictures: One-to-One
  • Users to Recipes: One-to-Many
  • Recipes to Ingredients: One-to-Many
  • Users to Comments: One-to-Many
  • Recipes to Comments: One-to-Many

 

Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Enhanced ER Model
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
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education