Week 7
Things to know & do in week 7.
- Week 7 starts on January 4, 2016.
- The total workload for this course is 140 hours. In week 7, we expect you to spend 4 hours on lectures, 4 hours in the lab and 7 hours on a mix of things (quiz, required readings, peer reviews, additional lab work, etc.).
- Get started on this week's **quiz and the second peer-review assignment**(P2) of the course.
- Groups in cluster C1 are assessed this week on Assignments A4 & A5. Make sure you reserve yourself an assessment spot and don't forget to upload your solution via the "Lab Submissions" link here on Blackboard.
- Minor students: http://doodle.com/poll/59x2acb3c8s63qcd
- Thursday students: http://doodle.com/poll/m9bbqm4v2t7hgtib
- Friday students: http://doodle.com/poll/y4ugyac5wyber9us
Lecture 12 - Conceptual Data Modelling with ER Diagrams
- ER - conceptualdesign.pdf
The PDF slides cover the foundamentals of the ER model.
Required reading
Chapter 7 of the Database book.
Recommended Readings
Entity Relationship Modeling (!! Graphical notation might differ from the one adopted in class) [HTML]
ER Diagrams tutorial (!! Graphical notation might differ from the one adopted in class) [HTML]
ER Diagram templates (!! Graphical notation might differ from the one adopted in class) [HTML]
The Entity-Relationship Model: Toward a Unified View of Data (Peter P. Chen, 1976) [PDF]
Entity-Relationship Modeling: Historical Events, Future Trends, and Lessons Learned (Peter P. Chen) [PDF]
Werkcollege
Conceptual Design Process [SLIDES]
Lecture 13 - EER Model - Database logical design
- EER Model.pdf
- logicaldesign.pdf
Required reading
Section 8.1, 8.2, and 8.3 of the Database book.
Chapter 9 of the Database book.
Quiz W7
The quiz can be attempted once. Its content covers the lectures of week 7.
Quizzes are individual work!
Deadline: January 11, 2pm.
Peer-review assignment P2
This assignment is a bonus assignment, worth +0.25 bonus grade points if done well.
The assignment consists of two steps, and it will last 3 weeks (first step deadline in Week 8, second step deadline in Week 9):
- Group work: create an ER conceptual model, and upload it to the dedicated Blackboard Forum (Discussions DATABASE DESIGNS). For everyone (independent of the cluster you are in) the deadline for the submission of the database design review is January 17, 11.59pm. Use your group name as thread title. Later submission will not be considered for grading.
- Individual work: it starts on January 18. You will be required to conduct three reviews of database designs from your fellow students. Do not review designs that have been submitted after January 17, 11.59pm. For everyone (independent of the cluster you are in) the deadline for the peer review isJanuary 22, 11.59pm. Later reviews will not be considered for grading.