instructor: Aaron Zhi Cheng, Section 003

Daily Archives: September 9, 2018

Assignment #1: ER Modeling [Due Monday, 9/17/18 at 11:59 pm]

Here are the instructions for Assignment#1: ER Modeling.

Use ERDPlus to complete the assignment.

  • You must submit a single Microsoft Word or PDF document  (if you send multiple files, you will not get credit for the assignment.)
  • If you do not follow the instructions, your assignment will be counted late.
  • Late Assignment policy: All assignments will be assessed a 50% penalty (subtracted from that assignment’s score) for the first day (i.e. 24 hours) they are late. No credit will be given for assignments turned in more than 24 hours past the deadline.
  • Work needs to be done individually.

The assignment is due by Sep 17th, 11:59 p.m.

Agenda for Week 3 (Week of 9/10)

Dear all,

Below is the agenda for Week 3.

Monday (9/10):

Relational Data Modelling and ERD

ICA #1.2: Creating an entity relationship diagram (ERD)

Notes: In ICA #1.2, we will use ERDPlus (https://erdplus.com/#/standalone) to create Entity Relationship Diagrams (ERD). Please view the YouTube tutorial (https://www.youtube.com/watch?v=A5-yy51eNGY) before the class. This short video shows you how to create and export ERD as an image which can be placed into a Word document.

Wednesday (9/12):

Converting ERDs to Schemas

Friday (9/14):

ICA #1.3: Converting ERDs to Schemas

Best,

Aaron