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

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

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter6: Managing Multiple Worksheets And Workbooks

Section: Chapter Questions

Problem 16RA

See similar textbooks

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

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Introducing ERD

VIEW

Step 2: ERD for given information

VIEW

Solution

VIEW

Step by step

Solved in 3 steps with 1 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

2- Design a class diagram of a course registration system. Note: utilize various class relations: generalization, aggregation, composition, and association; the class diagram should include but not be limited 10 the following class names User, Student, Instructor, Admin, Course, LogonPage, AddPage, DropPage, ChangePage, PrintPage, QueryPage, CourselnfoDB, StudentinfoDB, InstructorinfoDB, AdminlnfoDB, and EntireDB.
2- Design a class diagram of a course registration system. Note: utilize various class relations: generalization, aggregation, composition, and association; the class diagram should include but not be limited to the following class names User, Student, Instructor, Admin, Course, LogonPage, AddPage, DropPage, ChangePage, PrintPage, QueryPage, CoursenfoDB, StudentInfoDB, InstructorinfoDB, AdmintnfoDB, and EntireDB.
Let's break down the information into entities, attributes, and relationships: Entities: 1. Ship - ShipID (Primary Key) - ShipName - ShipType 2. Captain - CaptainID (Primary Key) - CaptainName - CaptainLicense 3. ShipmentTrip - TripID (Primary Key) - DeparturePort - ArrivalPort - RouteDetails 4. ShipmentManifest - ManifestID (Primary Key) - Date - GoodsList 5. Goods - GoodsID (Primary Key) - GoodsName - GoodsType (BM or LM) 6. Port - PortID (Primary Key) - Street - City - State - PostalCode - Country Relationships: - Ship to ShipmentTrip (Many-to-Many): - Ship can participate in multiple ShipmentTrips, and a ShipmentTrip can involve multiple Ships. Create a junction table `Ship_ShipmentTrip` with attributes `ShipID` and `TripID`. - Captain to ShipmentTrip (Many-to-Many): - A Captain can be assigned to multiple ShipmentTrips, and a ShipmentTrip can have multiple Captains. Create a junction table `Captain_ShipmentTrip` with attributes `CaptainID` and `TripID`. - Captain to Ship…
database fundementals: GIVEN: Participant (PNumber, LastName, FirstName, Address, City, State, PostalCode, PhoneNumber, DOB) SK-->FirstName AK-->PhoneNumber Class(ClassNum, Description, NumOfPerson, Fee) SK-->Description ClassParticipant(PNumber, ClassNum, DataOfClass) FK-->PNumber-->Participant FK-->ClassNum-->Class Expand the database design so it will support the following report: Colonial Adventure Tours needs to send an invoice to each participant, listing the classes in which the participant is enrolled as well as the total fees for the classes. The invoice should include the participant’s full name and address. Answer in both DBDL and E-R diagram
Question=1)DRAW : Matrix diagram of this entities project will be about a student attendance. Entities: student, course, instructor, attendance, enrollment, department, class. Relationships: Student is enrolled in course, Course has instructor, Department has many courses, Entities: 1. Student - Attributes: Student_ID (Primary Key), Name, Age, Email, Phone _Number 2. Course - Attributes: Course_ID (Primary Key), Course_Name, Department_ID (Foreign Key) 3. Instructor - Attributes: Instructor_ID (Primary Key), Name, Department_ID (Foreign Key) 4. Attendance - Attributes: Attendance _ID (Primary Key), Student_ID (Foreign Key), Course_ID (Foreign Key), Date, Status 5. Enrollment - Attributes: Enrollment_ID (Primary Key), Student_ID (Foreign Key), Course_ID (Foreign Key), Enrollment Date 6. Department - Attributes: Department_ID (Primary Key), Department_Name 7. Class - Attributes: Class_ID (Primary Key), Class_Name, Department_ID (Foreign Key) Draw Matrix diagram of this scaniorio
What is it called when multiple touching entities are linked together when selected?
Create a database Entity and Relationship Diagram (ERD) for the following application (Submitted An image of the Diagram By using Any Application:The Application idea: It is a mobile application called (Khair) to help people. This assistance is moral, material. This assistance is also provided by good people in our community. Example to understand the Application idea more: For example, a person urgently needs a medical chair or bed and does not have the ability to purchase what he needs. The medical chair or bed is requested through the application, and whoever has what he requests initiates the request through the application’s messages and determines the meeting place. Application models (page): Login included: login registration login included: user name password New registration included: name E-mail Password phone number date National Identification Number Home page included: Request - applicant name - address - send message Messages list form included: list of users Messager…
courses dasses ↑coursel INT courseDateTime DATETIME O room INT coursel INT courseName VARCHAR(45) course Description VARCHAR(45) room are used by a class. For each entity: Entitios rooms Froom DVT L-building VARCHAR(X) capacity VARCHAR(45) Inders The ERD depicts the data needed to track which course and Indicate if the entity is strong, weak ID-dependent, or weak non-ID-dependent For each relationship: • List the cardinality and participation of each entity in the relationship List the business rules for each relationship Indicate if the relationship is identifying or not
1. Create an entity named Person and passport and create a one-to-one mapping using JPA. Passport Person Passport Number Date Of Issue Date Of Expity Person Id First Name Last Name Passport Number Write a main program to assign values to the person and passport entity using entity manager instance.
When an attribute of one entity type references another entity type's attribute, this means that: O it is a derived attribute O weak entity type exists O a relationship exists O it means nothing
explain different types of sharing models on the basis of their parameters and application?
Draw an EER diagram to keep track of information for an art museum based on the following requirements a. The museum has a collection of ART_OBJECTS. Each ART_OBJECT has a unique Id_no, an Artist (if known), a Year (when it was created, if known), a Title, and a Description. The art objects are categorized in several ways, as discussed below. b. ART_OBJECTS are categorized based on their type. There are three main types: PAINTING, SCULPTURE, and STATUE, plus another type called OTHER to accommodate objects that do not fall into one of the three main types. c. A PAINTING has a Paint_type (oil, watercolor, etc.), the material on which it is Drawn_on (paper, canvas, wood, etc.), and Style (modern, abstract, etc.). d. A SCULPTURE or a statue has a Material from which it was created (wood, stone, etc.), Height, Weight, and Style. e. An art object in the OTHER category has a Type (print, photo, etc.) and Style. ART_OBJECTs are categorized as either PERMANENT_COLLECTION (objects that are…