Starting from:

$30

CS585-Homework 1 Conceptual Entity-Relational (ER) Diagram Solved

In this assignment, you need to create a conceptual Entity-Relational (ER) diagram, to model the scenario described below; note that your design is not going to be at a logical level, ie. you don't have to worry about how to represent your design using relational tables (including bridges) or other data models.




DIA

Project Mogwai (https://github.com/mirkosertic/MogwaiERDesignerNG (https://github.com/mirkosertic/MogwaiERDesignerNG))

E/R Assistant (Windows only: https://highered.mheducation.com/sites/0072942207/student_view0/e_r_assistant.html (https://highered.mheducation.com/sites/0072942207/student_view0/e_r_assistant.html)) Visio

...

After constructing the ER diagram, save, or take a screengrab snapshot, submit it [as a .jpg or .png image file].

Note that you can even draw your diagram legibly on paper and take a photo of it and submit that - but having said that, I'd encourage you to use a diagramming tool, that will make your result look professional, and have you follow industry practice.

You need to use Crow's Foot Notation for the ER diagram. For each relationship, indicate the cardinality (minimum and maximum participation), also via Crow's Foot symbols - use this

(pics/ERD_Relationship_Symbols_Quick_Reference-1.png) infographic (from www.vivekmchawla.com/) as a guide [you don't need to denote cardinality as (1,1) etc., instead, you would use the notation shown in the infographic, ie. use symbols such as |O and ||].

How much detail should your diagram contain? Use this (pics/Sample_ER_Diagram.jpg) sample as a guide (eg. you do not need to indicate data types for attributes).

You (a database designer/analyst) have been hired by the owners of a small 'STEM' organization that is interested in offering programming courses in their community, during summer vacation [the classes will be aimed towards high school students who will be on summer break].

Rather than offer just "the usual" (Scratch, Java, Python, Ruby...) coding classes, the owners want to make the classes more fun and engaging - they plan on making the classes be centered around microcontrollers.

(https://www.google.com/search?q=microcontroller&rlz=1C1CHBF_enUS723US723&sxsrf=ACYBGNS3HHOQjCoXCtF0zDz-

h29WgDfgw:1568531457864&source=lnms&tbm=isch&sa=X&ved=0ahUKEwiRs_WCo9LkAhWFoJ4KHaKkCIcQ_AUIFC


More products