a PU R I = PURES COLLEGE OF TECHNOLOGY Program + Semester lcnctl'lofizlc'ltlmnio S stems Anal sis and Section Code ISBA y y BU1183Gl Development Percentage Weight of Total Evaluation 4% Type of Evaluation S 2023 ummer Assignment #2 (Online Assignment) Course Instructor Due Date Total Marks' Ron Demeda Week 9 (Tue. July 4, 2023) ' Student Name: Student ID #: Instructions: Complete both parts of the following assignment. Investigate and document your response. Provide your response back in this document, and SUBMIT it back using Google Classroom once both sections are completed. This is an INDIVIDUAL student assignment. Choose one (1) of the following scenarios. You must use the same scenario for both Part 1 DFD and Part 2 Data Modelling ofthis assignment. It may be the same scenario as used in Assignment #1 Use Cases or you may select a different one. You may NOT use the same scenario as the Team Project if you are completing the DFD and/or Data Modelling sections of the Team Project. Scenarios: 0 Pizza (or other food) store, including ordering, cooking, delivering. Could include tables for: Customer, Orders, Products (menu items), Ingredients, Stores. 0 Online shopping (e.g. Amazon) including ordering, shipping. Could include tables for: Customer, Orders, Products, Supplier. - Student registration system including enrolling, course registering. Could include tables for: Student, Courses, Programs, Program Enrollments, Course Registrations. - Banking including transactions using customer accounts. Could include table for: Customer, Account, Transactions, Account_Type. - Any other scenario explicitly approved to you by the instructor Pures College of Technology 200 & 300 - 1450 Midland Avenue Toronto, ON MlP 428 Tel: 416498-5558 Pill R L = PURES COLLEGE OF TECHNOLOGY 1. Data Flow Diagramming Create a Context Diagram for your scenario. Ensure you have at least 1 External Entity, and more than 1 Data Flow, and as a Context Diagram ONLY 1 Process representing the entire system. [5 Marks] Then create a Level 0 Data Flow Diagram (NOT a Context diagram) for your scenario. Ensure you have at least 1 External Entity, 1 Data Store, and more than 1 Data Flow, and as a Level 0 DFD... more than 1 Process (max 6-8). [10 Marks] Ensure that you balance (reconcile) your DFD with your ERD from Part 2 below. 2. Data Modelling For the same scenario as used in the first section, create a Data Model (i.e. Entity Relationship Diagram /ERD) describing the key data components related to your scenario. [10 Marks] 1. Include key entities/tables, max (4-6 tables - do not try to complete the entire data model). 2. Include key data elements/attributes. 3. Identify relationships including: a. Primary keys b. Foreign keys c. Cardinalities/Modalities between tables Ensure that you balance (reconcile) your ERD with your DFD from Part 1 above. Submission format: You may submit your models for both sections using one ofthe methods below. * However, for any method used, you MUST also submit the original source file as well (not just a jpg or image file): 1. Use MS Word graphics (Insert Shapes) and create the diagrams in a Word document. Sample MS Word templates with the basic shapes are provided below at the bottom of this document. Feel free to use the shapes by copying the sample shapes, moving them around the page, and renaming the data as you see t. Feel free to use portrait or landscape orientation of page as you wish. Be sure to check that it is formatted as expected after uploading to Google Classroom. 2. Use the Google Drawings app to create the diagrams (Google Drive 9 New 9 More 9 Google Drawings. Use Text Boxes, lines/arrows, and Shapes (note that since a 3-sided rectangle shape is not available, I will accept a long narrow rectangle i.e. 4-sides for a data store). Be sure to check that it is formatted as expected after uploading/attaching to the assignment in Google Classroom. Pures College of Technology 200 & 300 - 1450 Midland Avenue Toronto, ON MlP 428 Tel: 416498-5558 PURES PURES COLLEGE OF TECHNOLOGY 3. Use a modelling or graphics tool to draw your diagrams. Once done, export your diagram as image and import to MS Word, or take a screen print (alt-print-screen key) or photo and paste in your Word document, or export to pdf. *Note you must also submit the source modelling file as well. Possible modelling tools include: draw. io (https://app.diagrams.net/ ) . edraw (https://www.edrawsoft.com/ ) Visio (https://www.microsoft.com/en-ca/microsoft-365/visio/flowchart-software ) iGrafx (https://www.igrafx.com/ ) any other visual modelling tool 4. Draw your diagrams by hand. Sign your diagram and take a photo of it with your phone. Imbed the photo jpg file in your Word document. IMPORTANT: Your diagrams must be original and created by you. You may NOT just copy an existing diagram from the Internet. You may NOT share or copy any diagram from/with any other students. If you do copy from another source, then you will be in violation of the College policy, will receive an automatic mark of ZERO, and will be at risk of being expelled from the college. Pures College of Technology 200 & 300 - 1450 Midland Avenue Toronto, ON M1P 428 Tel: 416-498-5558Assignment #2 Context Diagram, DFD, ERD Ron Demeda - Jun 13 4 points Due Tomorrow Please complete both parts of the attached assignment (3 diagrams). Please be sure to also submit original raw data files for an):r diagrams created