Information Systems in Organizations Entity Relationship Diagrams 2

Information Systems in Organizations Entity Relationship Diagrams - 2 In-Class Activity FOX MIS

Attendance Please login to Canvas and “Check-In” Attendance is not a part of your grade for this class. The university has mandated that we take attendance for all classes, face-to-face, online and hybrid, to assist in contact tracing should an outbreak of Covid-19 occur. FOX MIS

ROADMAP Week 1: START Introduction & Systems Analysis • Course Description • Systems Thinking Week 2: Week 3: Week 4: Week 5: Introduction to Process Mapping Digital Product Management Introduction to Data Modeling Exam #1 & Information Systems – Part I & II • Systems & Processes • Swim Lane Diagrams • Max Labs 1 a & 1 b • Entity Relationship Diagrams (ERD) Assignment #01 Assignment #02 Week 9: Week 8: Exam #2 & Java. Script Unit #1 - Part I & II • Protection Protocols • Artificial Intelligence • Hello World, Variables * Exam - check calendar Assignment #07 Cybersecurity & AI – Part I & II Assignment #06 • ERD Diagrams • Learn IT Kickoff • CRM & ERP *Exam – check calendar Assignment #03 Week 7: Week 6: Platforms & Digital Business Models – Part I & II Information Systems – Part III & IV • Platforms & Digital Models • APIs Assignment #05 • Data Analytics • SCM • Max Labs 2 a 2 b Assignment #04 Week 10: Week 11: Week 12: Week 13: Java. Script Unit #2 Functions Java. Script Unit #3 Java. Script Unit #4 Loops Java. Script Unit #4 Working with Loops • Operator types • Strings Assignment #08 Logical Operators & Conditional Logic • Logical Operators • Conditional Types • Intro to Loops • While and Do • Writing the code Week 14: HTML & CSS Unit • HTML basics • CSS basics • Course Reflection Assignments #’s 9 & 10 FINISH

What is a entity relationship diagram? An Entity Relationship Diagram (ERD) is a visual representation of different data using conventions that describe how these data are related to each other. FOX MIS

Crow’s Foot Database Notation A shopper walks into a store to buy an item. When the shopper makes a purchase, the system is updated with information about the person, including their name, loyalty card id and zip code. The store also records which items were purchased, including details like item name, price and item source. Chen’s Database Notation FOX MIS

Entity Relationship Diagrams - 2 What: • Construct a more complex entity relationship diagram from provided story Why: • ERDs model the information required for a process • ERDs supplement swim lane diagrams and complete a bigger picture FOX MIS

From last week… Start End

Start End

Step #1 • In Small Groups of 2 -3: • Identify the entities, attributes and relationship • Construct an ERD based on the following narrative FOX MIS

Chris is the cake decorator at Cold Stone Creamery. Chris works part-time and is responsible for decorating all of the cakes that Cold Stone sells including both stock cakes and custom orders. Chris can’t do this alone. She needs the help of other people at the store to do this. It all starts in the morning before the store opens when the store manager takes inventory of what cakes they have in stock. While taking the inventory the manager checks the expiration dates for all cakes that are in stock. If a cake has reached its expiration date, it is removed from stock and discarded. If a cake is within a week of reaching its expiration date, it is tagged as a “Manager’s Special” and the price is reduced by 25%. The store manager compares what they have in inventory to the “par sheet” which lists how many of each type of cake the store would like to have in stock. Based on the difference between what they already have in stock and what the par sheet says they should have in stock, the manager creates a list of cakes that need to be made by the crew members. The manager also looks at orders for both stock cakes and custom cakes. If there any orders, then the manager adds these cakes to the list of cakes to be built. Throughout the day the crew members build the cakes on this list. Building a cake does not include decorating a cake. Building a cake involves cutting out the right sized/shape piece of cake from a large sheet of cake (i. e. small round, large round, small rectangle, large rectangle in either chocolate or vanilla) which will form the bottom layer of the cake and mixing the ice cream (a combination of ice cream flavors and mix-ins) that will form the top layer of the cake and putting the cake and mixed ice cream into the appropriate pan which serves as a mold. The cake is then put into the blast freezer to deep freeze the cake overnight. The next day Chris pulls the newly built cakes out of the blast freezer and decorates the cakes as needed to fill orders and replenish stock. As part of decorating the cakes, Chris packages the cakes into containers, labels each cake correctly with the type of cake and the expiration date for the cake. Chris puts the stock cakes out in the display freezer to be sold and the orders in the freezer in the back so they will be waiting for the customer when they come in to pick up their cake. FOX MIS

Step #2 • Upload your ERD individually FOX MIS

Step #3 • Students called upon at random to help draw diagram on board and discuss Source: https: //i 1. wp. com/www. nationalreview. com/wp-content/uploads/2016/12/school-bans-students-raising-their-handsanswer-questions-2. jpg? fit=788%2 C 460&ssl=1 FOX MIS

Step #4 • Individually rate this activity using. Canvas FOX MIS

Step #5 • Enter the exit code FOX MIS

Possible Solution