Class notes
Data Modelling
Entity-relationship diagram and data flow diagram
[Show more]
Seller
Follow
Content preview
PURES COLLEGE OF TECHNOLOGYInstructions:
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller nishibawa. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for CA$22.86. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
56326 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now