| 1 | <p>Understand and describe the basic concepts and structures of how databases and database systems work.</p> | <p>BE(Hons) - Bachelor of Engineering (Honours) - Programme Capabilities <p>Create, select, apply, and recognize limitations of appropriate techniques, resources, and modern engineering and IT tools, including measurements, modelling and prediction, to solve complex engineering problems (WA5)</p> </p> |
| 2 | <p>Demonstrate and apply conceptual data modelling techniques for a database design.</p> | <p>BE(Hons) - Bachelor of Engineering (Honours) - Programme Capabilities <p>Apply contextual knowledge to assess societal, health and safety, legal and cultural issues (including the principles of Te Tiriti O Waitangi), to solve complex engineering problems in accordance with responsibilities relevant to professional engineering practice locally, in Te Moananui-ā-Kiwa and the world (WA6)</p> </p> |
| 3 | <p>Understand and apply the relational data model and the conversion of conceptual data models into relational databases.</p> | <p>BE(Hons) - Bachelor of Engineering (Honours) - Programme Capabilities <p>Create, select, apply, and recognize limitations of appropriate techniques, resources, and modern engineering and IT tools, including measurements, modelling and prediction, to solve complex engineering problems (WA5)</p> </p> |
| 4 | <p>Understand and apply the Structure Query Language (SQL) to develop a practical database solution in line with its usage.</p> | <p>BE(Hons) - Bachelor of Engineering (Honours) - Programme Capabilities <p>Apply knowledge of mathematics, natural science, computing and engineering fundamentals, and an engineering specialisation, considering multiple perspectives and knowledge systems to develop solutions to complex engineering problems (WA1)</p> </p> |
| 5 | <p>Understand and apply theoretical database knowledge such as relational algebra, functional dependencies and normalisation.</p> | <p>BE(Hons) - Bachelor of Engineering (Honours) - Programme Capabilities <p>Use knowledge of mathematics, natural sciences and engineering principles, and research literature to identify, formulate, analyse and solve complex engineering problems and reach substantiated conclusions (WA2)</p> </p> |
| 6 | <p>Understand and critically evaluate quality aspects of database design in terms of functional dependencies and associated normal forms.</p> | <p>BE(Hons) - Bachelor of Engineering (Honours) - Programme Capabilities <p>Design creative solutions for complex engineering problems and design systems, components or processes to meet identified needs with appropriate consideration for public health and safety, whole-life cost, net zero carbon, as well as resource, cultural, societal, and environmental considerations as required (WA3)</p> </p> |
| 7 | <p>Understand and explain the key implementation techniques of database management systems, such as file storage, data retrieval and indexing, etc.</p> | <p>BE(Hons) - Bachelor of Engineering (Honours) - Programme Capabilities <p>Create, select, apply, and recognize limitations of appropriate techniques, resources, and modern engineering and IT tools, including measurements, modelling and prediction, to solve complex engineering problems (WA5)</p> </p> |
| 8 | <p>Develop an understanding of the key concurrency techniques of database management systems, such transaction processing, recovery, serializability, etc.</p> | <p>BE(Hons) - Bachelor of Engineering (Honours) - Programme Capabilities <p>Conduct investigations of complex engineering problems using research methods, research-based knowledge, design of experiments, analysis and interpretation of data, and synthesis of information to provide valid conclusions (WA4)</p> </p> |
| 9 | <p>Develop an understanding of the advanced data models and modern query languages.</p> | <p>BE(Hons) - Bachelor of Engineering (Honours) - Programme Capabilities <p>Communicate effectively, respectfully and inclusively on complex engineering activities with the engineering community and with society at large, such as being able to comprehend and write effective reports and design documentation, make effective presentations, taking into account cultural, language, and learning differences using a range of technologies and formats (WA10)</p> </p> |
| 10 | <p>Understand and describe modern distributed database systems and their applications.</p> | <p>BE(Hons) - Bachelor of Engineering (Honours) - Programme Capabilities <p>Design creative solutions for complex engineering problems and design systems, components or processes to meet identified needs with appropriate consideration for public health and safety, whole-life cost, net zero carbon, as well as resource, cultural, societal, and environmental considerations as required (WA3)</p><p>Communicate effectively, respectfully and inclusively on complex engineering activities with the engineering community and with society at large, such as being able to comprehend and write effective reports and design documentation, make effective presentations, taking into account cultural, language, and learning differences using a range of technologies and formats (WA10)</p> </p> |