Reference no: EM133490436

Introduction to Systems Analysis and Development

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

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.
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).
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.
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.

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 (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 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.

2. Use the Google Drawings app to create the diagrams (Google Drive → New → More → 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.

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
• edraw
• Visio
• iGrafx
• 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.