Er diagram representing the logical data model

Assignment Help Database Management System

Reference no: EM13705172

Question: Create an Entity-Relationship Diagram representing the logical data model for the following scenario. It should include all entities, attributes, relationships and keys. Below your ERD, LIST ANY PATTERNS YOU USED IN CREATING THE ERD.

Scenario:

A cooking club organizes several dinners for its members. The purpose of the club is to allow several members to get together and prepare a dinner for the other members. The club president maintains a database that plans each meal and tracks which members attends each dinner, and also keeps track of which members creates each dinner.

Each dinner serves many members and any member is allowed to attend. Each dinner has an invitation. This invitation is mailed to each member. The invitation includes the date of the dinner and location.

Each dinner is based on a single entrée and a single dessert. This entrée and dessert can be used again for other dinners.

Prepare an Entity-Relationship Diagram show the logical data model for the given scenario.

Reference no: EM13705172

Questions Cloud

Prove that the fifth root of 2 is irrational : Use contraposition to prove that if n^5 is even so is n where n is an integer. The contra positive would be if n is odd, then n^5 is odd.

User to enter a positive integer with 2 digits : It asks the user to enter a positive integer with 2 digits - If the entered number is out of range, the message "Too difficult!" is printed and the program terminates.

Write an app to test class integerset : Create class IntegerSet. Each IntegerSet object can hold integers in the range 0-100. The set is represented by an array of bools. Array element

Maximum ethernet payload : Host B can send TCP acknowledgements to host A, even though it has no data to send - experiment in which host A blasts a 26 Megabyte file to host B through a single TCP Tahoe connection over a 1 Gigabit/sec Ethernet. B transmits no data. Neither ho..

Er diagram representing the logical data model : Create an Entity-Relationship Diagram representing the logical data model for the following scenario. It should include all entities, attributes, relationships and keys.

Command to rename all files in your entire system : Write a command to rename all files in your entire system named temp.old to New - Count the number of lines in file F1 that has the word unix

Create an interface that includes a group box : Create an interface that includes a group box that contains 3 check box and 3 text box, the three text boxes should be invisible when the application starts

Who want to place children in the program : The daycare keeps a waiting list of families who want to place children in the program.

Prepare an er diagram for the given problem : Each Specialty Program is described by a unique name, a location, a head teacher, and a department phone number.

User Account

All Pages