程序代写代做代考 case study database SQL INFO20003 Database Systems

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