It's UWAweek 47
|
unitinfo
This page provides helpful information about many coursework units offered by
Computer Science and Software Engineering
in 2023.
The information here is not official -
for official information please see the
current UWA Handbook.
Instead, it will help students to prepare for their future units,
before the beginning of each semester,
and before they have access to
UWA's
Learning Management System (LMS).
|
About the unit CITS1402 Relational Database Management Systems (2nd semester 2023)
Unit description:
This unit deals with data modelling through the theory and practice of database design, implementation and use. Several database models are addressed, with a strong focus on the relational model and its theoretical grounding in sets and relational algebra. The process of problem decomposition into entity-relations, the design of appropriate relational schemas, and their refinement through normalisation underlies the unit. Critical issues surrounding the design of query languages and their implementation are addressed, and information retrieval is practised using a specific query language. Students learn database connectivity by building systems in one of several programming languages that support a connectivity Application Programming Interface (API).
Unit outcomes:
Students are able to (1) understand existing database implementation and create refinements and improvements through analysis; (2) understand the 'business' requirements to design a database; (3) refine the database to improve and ensure correctness and reliability; (4) correctly program structured query language (SQL) queries and reports; and (5) build an application layer interface for easier user interaction.
Unit coordinator:
Unit homepage:
|
|
Unit is offered in these majors and courses:
Indicative weekly topics:
| week 1 |
Introduction, Relational Model and SQL1 |
| week 2 |
RDBMS, Normalisation 1, JOIN |
| week 3 |
Data Definition Language, SELECT, Data Types |
| week 4 |
Operators, Relational Algebra 1, Summary Functions |
| week 5 |
GROUP BY, Entity-Relationship Diagrams (ERD 1), HAVING |
| week 6 |
Subqueries 1, ERD 2, Subqueries 2 |
| week 7 |
Relational Algebra 2, Functional Dependencies 1, NULL |
| week 8 |
Data Integrity, ERD 3, Data Manipulation Language |
| week 9 |
Transactions, Views, Triggers |
| week 10 |
Functional Dependencies 2, Indexes, Relationships |
| week 11 |
Normal Forms, Mongo DB |
| week 12 |
Review |
Indicative assessment:
Labs (4 marked code submissions), MidSemester Test, Project and Final Exam
Useful prior experience and background knowledge:
Although not assumed, it would be helpful if students had a general understanding of some basic programming concepts: variables, data types, especially strings, loops.
Hardware required for this unit:
Students are able to undertake their laboratory exercises and projects in laboratories in the CSSE building, but most students also complete work on their own laptops.
The following hardware is required to successfully complete this unit:Standard laptop
Software required for this unit:
Students are able to undertake their laboratory exercises and projects in laboratories in the CSSE building, but most students also complete work on their own laptops.
The following software is required to successfully complete this unit:SQLite and SQLite Studio (both free)
Operating system(s) used in this unit:
Different units will use different operating systems for their teaching - for in-class examples, laboratory exercises, and programming projects.
If an operating system is REQUIRED, it will be used when marking assessments.
ANY reasonable platform
This information last updated 6:47pm Thu 20th Apr 2023
