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 of this 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: Pizza (or other food) store, including ordering, cooking, delivering. Could include tables for: Customer, Orders, Products (menu items), Ingredients, Stores. 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 Program + Semester ISBA

Course Name Introduction to Systems Analysis and Development

Section Code BU1183-G3

Fall2022

Type of Evaluation Assignment #2 (Online Assignment)

Percentage Weight of Total Evaluation 10%

Course Instructor Ron Demeda

Due Date Week 8 (Oct. 27, 2022)

Total Marks: /25

PURES COLLEGE OF TECHNOLOGY

Pures College of Technology 200 & 300 - 1450 Midland Avenue Toronto, ON M1P 4Z8 Tel: 416-498-5558

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 of the 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 (InsertShapes) 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 fit. 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.