INFO20003 Database Systems
INFO20003 Database Systems 1© University of Melbourne 2018
INFO20003 Database Systems
Lecture 06
Hands On Modelling
Semester 2 2018, Week 3
Dr Renata Borovica-Gajic
INFO20003 Database Systems 2© University of Melbourne 2018
Administration
• Feedback
–Please share what you like/dislike about the subject
–What can be improved and how
• Assignment 1
–Will be online on Friday 10/08/18 at 10am
–Due date Friday 24/08/18 at 5:59pm
–Submit:
1. One PDF: Conceptual Model (pen and paper Chen’s notation,
scanned/photo legible), plus Physical Model (Crow’s foot
notation with Workbench, picture), plus assumptions
2. Physical model: Workbench file (mwb)
INFO20003 Database Systems 3© University of Melbourne 2018
Modelling Quiz
INFO20003 Database Systems 4© University of Melbourne 2018
INFO20003 Database Systems 5© University of Melbourne 2018
INFO20003 Database Systems 6© University of Melbourne 2018
Conceptual Model Mapping – Recap
Concept Chen’s not. Crow’s foot not. Relationship cardinalities and constraints
INFO20003 Database Systems 7© University of Melbourne 2018
Modelling Medicare Case Study
• On LMS / Resources….
INFO20003 Database Systems 8© University of Melbourne 2018
Next Lecture
• Relational algebra and calculus
–How do we ask queries/interrogate a database
–Foundation of SQL queries