Question

Entity - Relationship Diagrams) 1) Go to the following website and read through what entity -...

Entity - Relationship Diagrams)

1) Go to the following website and read through what entity - relationship diagrams are:


http://www.cems.uwe.ac.uk/~tdrewry/lds.htm

Now, try writing logical data structures (LDS) [or entity-relationship diagrams] for the following situations:


A) You are at a restaurant. The server asks "What wine would you like with this course?" What are the entities, and what are the relationships that would allow you to track the wine with each course?"

B) Imagine that you want to keep track of articles found in different magazines and journals. What are the entities and relationships that would be used?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

A)

Entities: Course,Wine

Relationships: One Course can have different kinds of Wines. One Wine can be Part of different Courses (M:N)

B)

Entities: Articles, Magazine,Journal

Relationships: One Magazine has many Articles. (1:M)

One Journal has many Articles . (1:M)

Do ask if any doubt. Please upvote.

Add a comment
Know the answer?
Add Answer to:
Entity - Relationship Diagrams) 1) Go to the following website and read through what entity -...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • CSCI 3700 - Introduction to MIS Assignment 4-Entity Relationship Diagram Entity relationship diagrams document the relationships...

    CSCI 3700 - Introduction to MIS Assignment 4-Entity Relationship Diagram Entity relationship diagrams document the relationships between entities in a database environment. The following is an example from the textbook (p 254) Address Name Email Ships Hem Orders Price Forwards Credit Card Creates Order Number Entity Relationship Attribute :0ne 0-Zero or more. Optional )-=Many In the above example, we can identify the entities (what would be tables within our database), the attributes (the items that describe the entity), the relationship...

  • Describe the entity-relationship model. How are entities, relationships, and attributes represented in this model?What is a...

    Describe the entity-relationship model. How are entities, relationships, and attributes represented in this model?What is a composite entity? Describe the approach to diagrams that use a crow's foot. Describe how you wouldrepresent cardinality in an E-R diagram.

  • I need help. Valley Vineyard Conceptual Model Case Read the case then create an entity-relationship diagram...

    I need help. Valley Vineyard Conceptual Model Case Read the case then create an entity-relationship diagram that captures the essence of the problem domain. Identify the entities (diagrammed in a rectangle box) Establish and label the relationships (diagrammed in a diamond) Determine the cardinalities Add the attributes, if you diagram is too busy the attributes can be on a separate page. Be sure to note any assumptions you have made. CASE: Valley Vineyard’s customers are mainly restaurants and wine shops...

  • 1. The following set of brief scenarios describes the relationships between various entity classes. Draw the...

    1. The following set of brief scenarios describes the relationships between various entity classes. Draw the entity classes (only show entity name - no attributes or identifiers) and the relationship making sure to add notation (use any standard notation) that shows reasonable minimum and maximum cardinalities given the implied scenario. All scenarios will only have one relationship. The one relationship may be between a maximum of two entity classes (binary) or between an entity class and itself (recursive). If you...

  • In Module Four, submit a systems analysis for your project, including a comprehensive entity-relationship diagram (ERD)....

    In Module Four, submit a systems analysis for your project, including a comprehensive entity-relationship diagram (ERD). Although you may use any tool to complete the ERD, it is strongly recommended that you use Microsoft Visio and then save the diagram into an image format (GIF or JPG) and then copy and paste the image into your systems analysis. All sections of this milestone should be compiled into a single Word document. Furthermore, all of Milestone One should be included in...

  • Please do not delete the questions. 1. What is the purpose of a database? 2. What...

    Please do not delete the questions. 1. What is the purpose of a database? 2. What is the reason to use a database over a spreadsheet? 3. Based on the previous answers (#1 & #2), there is a simple rule of thumb. A spread sheet is used when there is _________________________. A database is used when there are _________________________. 4. Please answer followings. a) A group of 8 bits is called a ____________ (from Chapter 4). b) The answers of...

  • please use dia to draw the e-r diagram to create Entity - Relationship Diagrams then use MS access This project requires you to create a database design. Your design will be documented in a set o...

    please use dia to draw the e-r diagram to create Entity - Relationship Diagrams then use MS access This project requires you to create a database design. Your design will be documented in a set of Entity-Relationship Crow's Foot diagrams using the representation as shown in the lecture materials. Draw a set of Entity-Relationship diagrams to model the following scenario. The Maggs Realty Company wants to track the Sales Offices that they have across all of Ontario They are interested...

  • Please read the article and answer about questions. You and the Law Business and law are...

    Please read the article and answer about questions. You and the Law Business and law are inseparable. For B-Money, the two predictably merged when he was negotiat- ing a deal for his tracks. At other times, the merger is unpredictable, like when your business faces an unexpected auto accident, product recall, or government regulation change. In either type of situation, when business owners know the law, they can better protect themselves and sometimes even avoid the problems completely. This chapter...

  • You need not run Python programs on a computer in solving the following problems. Place your...

    You need not run Python programs on a computer in solving the following problems. Place your answers into separate "text" files using the names indicated on each problem. Please create your text files using the same text editor that you use for your .py files. Answer submitted in another file format such as .doc, .pages, .rtf, or.pdf will lose least one point per problem! [1] 3 points Use file math.txt What is the precise output from the following code? bar...

  • d. Following through promptly on cliet fequest 5. An elderly person exhibits passive behavior, apathy, and...

    d. Following through promptly on cliet fequest 5. An elderly person exhibits passive behavior, apathy, and unwillingness to participate in daily care or activities. He verbalizes a lack of control over his life. The most appropriate nursing diagnosis is a. Anxiety b. Fear c. Altered self-esteem d. Powerlessness 6. The nurse in charge wants to help the unlicensed personnel respond most appropriately to grieving residents in a long-term care facility. To develop an effective training plan, the nurs would: Look...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT