Assessment Two – Database programming evaluation practical
Length See below for details
Learning Outcomes b, c
Submission Part 1: Thursday 11:59 PM AEST/AEDT of Module 4.2 (week 7)
Part 2: Sunday 11:59 PM AEST/AEDT of Module 4.2 (week 7)
Total Marks 35 Marks
The MIS602 Data Modelling & Database Design subject is designed for you to progressively add to your understanding of data and database management and its relevance with in business context. It also introduces you to some of the key features of database management system and designing database systems that will feature in later modules of this topic. In order for you to do well in this subject, it is imperative that you undertake all of the learning activities in the modules. The learning activities are presented as a way of scaffolding your learning so that you can attempt the building blocks of the assessments and be in a safe environment to fail and to learn from them. Therefore, doing your learning activities and seeking feedback from them from peers and from the learning facilitator is the single best way of preparing for doing well in this assessment.
You are required to create the database tables as per the ERD below, and then generate the SQL tasks given in the table.
Note: The following tables give you an idea of what sample data looks like:
Building_ID Building_Name Built_year Building_Capacity Building_Address
1001 Lilly Pilli 1995 5000 Wakefield street
1002 Early Settler 2006 2000 Flinders Street
1003 Horizon East 2018 5,000 Maldives Street
1004 Ocean Blue 2020 15,000 Wakefield Street