MIS602 Data Modelling & Database Design Assessment Two – Database programming evaluation practical

MIS602 Data Modelling & Database Design
Assessment Two – Database programming evaluation practical
Individual/Group Individual
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)
Weighting 35%
Total Marks 35 Marks
Context:
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.
Introduction:
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
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