PURES COLLEGE OF TECHNOLOGY
Instructions:
Complete both sections 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.
1. Data Flow Diagramming
Create a Level 0 Data Flow Diagram related to one of the following scenarios:
Pizza (or other food) shop, 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
You must use the same scenario for Part 2 Data Modelling of this assignment.
Your scenario must be different than one used in your project.
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 4-6).
Pures College of Technology
200 & 300 - 1450 Midland Avenue
Toronto, ON M1P 4Z8
Tel: 416-498-5558
, PURES COLLEGE OF TECHNOLOGY
2. Data Modelling
For the same scenario as used in the first section, create a Data Model (e.g. ERD) describing the
key data components related to one of the following scenarios:
1. Include key entities/tables, max (4-6 tables - do not try to complete the entire data model).
2. Include key data elements.
3. Identify relationships including:
a. Primary keys
b. Foreign keys
c. Cardinalities between tables
Submission format:
You may submit your models using 1 of the methods below:
1. Use MS Word graphics (InsertShapes) and create the diagrams in a Word document. A
sample MS Word template is provided below. 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 MS word or some other modelling or graphics tool to draw your diagrams. Take a
screen print (alt-print-screen key) or photo and paste in your Word document, or export to
pdf.
3. 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.
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.
Pures College of Technology
200 & 300 - 1450 Midland Avenue
Toronto, ON M1P 4Z8
Tel: 416-498-5558
Instructions:
Complete both sections 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.
1. Data Flow Diagramming
Create a Level 0 Data Flow Diagram related to one of the following scenarios:
Pizza (or other food) shop, 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
You must use the same scenario for Part 2 Data Modelling of this assignment.
Your scenario must be different than one used in your project.
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 4-6).
Pures College of Technology
200 & 300 - 1450 Midland Avenue
Toronto, ON M1P 4Z8
Tel: 416-498-5558
, PURES COLLEGE OF TECHNOLOGY
2. Data Modelling
For the same scenario as used in the first section, create a Data Model (e.g. ERD) describing the
key data components related to one of the following scenarios:
1. Include key entities/tables, max (4-6 tables - do not try to complete the entire data model).
2. Include key data elements.
3. Identify relationships including:
a. Primary keys
b. Foreign keys
c. Cardinalities between tables
Submission format:
You may submit your models using 1 of the methods below:
1. Use MS Word graphics (InsertShapes) and create the diagrams in a Word document. A
sample MS Word template is provided below. 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 MS word or some other modelling or graphics tool to draw your diagrams. Take a
screen print (alt-print-screen key) or photo and paste in your Word document, or export to
pdf.
3. 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.
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.
Pures College of Technology
200 & 300 - 1450 Midland Avenue
Toronto, ON M1P 4Z8
Tel: 416-498-5558
