School of Computing and Information Systems INFO20003 Database Systems SAMPLE EXAM Reading Time: 15 minutes Writing time: 120 minutes This paper has 14 pages including this page Authorised Materials Calculators: Casio fx82 calculators are permitted Instructions to Invigilators The examination paper IS TO REMAIN in the examination room Students are to be provided […]
INFO20003 Week 3 Lab ER Modelling with MySQL Workbench Objectives: In this lab you will: • Learn about MySQL data types • Choose proper data types for physical ER models • Create a physical data model with the MySQL Workbench modelling tool Section 1: Modelling participation constraints In last week’s lab you developed a simple
INFO20003 Tutorial – Week 3 Solutions Objectives: This tutorial will cover: I. Entity-Relationship (ER) modelling review II. Case study – Use the previous week’s case study to design a conceptual model III. Convert the conceptual model to a logical model IV. Introduce the notion of physical model Exercises: 1. ER Review – fundamental concepts NOTE
INFO20003 Week 4 Lab – Solutions Section 1: Develop an ER model ◆ Task 1.1 Build a physical model using MySQL Workbench for the bus company case study that was covered in Tutorial 4. Be sure to choose suitable attribute names and data types, paying attention to the length and precision of data types. A
INFO20003 Week 4 Lab ER Modelling with MySQL Workbench Objectives: In this lab you will: • Design an ER model • Forward engineer the ER design to SQL • Prepare the schema for next week’s lab Section 1: Develop an ER model Choose either Task 1.1 or Task 1.2. Students who are more confident with
程序代写代做代考 case study database ER INFO20003 Week 4 Lab Read More »
INFO20003 Database Systems Dr Renata Borovica-Gajic Lecture 05 Modelling with MySQL Workbench INFO20003 Database Systems Week 3 1 Coverage • Modelling with MySQL Workbench • Recap & further design – Conceptual Design – Logical Design – Physical Design INFO20003 Database Systems © University of Melbourne 2 Conventions of ER Modelling (Workbench) • Entity • Identifier
程序代写代做代考 case study go database ER INFO20003 Database Systems Read More »
INFO20003 Tutorial – Week 11 Solutions Objectives: This tutorial will cover: (Tutorial: Data warehousing) I. Understand the fundamentals of dimensional modelling – 20 mins II. Design a dimensional model using Kimball’s four-step design process – 25 mins III. Discuss the impact of grain on fact tables – 10 mins Key Concepts: NOTE for students: This
Objectives: INFO20003 Tutorial – Week 4 This tutorial will cover: I. Additional concepts in ER modelling, plus a simple case study – 20 mins II. Bus company case study – conceptual and logical modelling – 30 mins Exercises: 1. ER modelling – additional concepts • Multivalued and composite attributes • Unary relationships 2. Practising these
程序代写代做代考 case study ER Objectives: Read More »
INFO20003 Tutorial – Week 2 Solutions Objectives: This tutorial will cover: I. Review of the Database Development Lifecycle focusing on the design stage (Q1) – 20 mins II. Case study – identify entities, business rules and attributes (Q2) – 30 mins Exercises: 1. The diagram above shows the stages of the Database Development Lifecycle. a.
程序代写代做代考 chain case study database ER INFO20003 Tutorial – Week 2 Solutions Objectives: Read More »
Objectives: INFO20003 Tutorial – Week 3 This tutorial will cover: I. Entity-Relationship (ER) modelling review II. Case study – Use the previous week’s case study to design a conceptual model III. Convert the conceptual model to a logical model IV. Introduce the notion of physical model Exercises: 1. ER Review – fundamental concepts • Entity,
程序代写代做代考 chain case study ER Objectives: Read More »