Database Fundamentals
Undergraduate
Undergraduate
INFT 1020
Undergraduate
Yes
Note: This offering may or may not be scheduled in every study period. Please refer to the timetable for further details.
156781
4.5
No
School of Information Technology and Mathematical Sciences
To design and construct a relational database for a small organisation.
Information, data, database, database management systems.
Relational model.
Database constraints: keys and referential constraints.
SQL data definition, SQL data manipulation, SQL queries.
Selection, projection, join and outer joins, union, except, intersection, views and aggregation.
Database design (conceptual, logical and physical).
Unified modelling language and normalisation.
Access control and database administration.
Nil
Common to all relevant programs | |
---|---|
Subject Area & Catalogue Number | Course Name |
INFT 1016 | Information Technology Fundamentals |
Specific program | ||
---|---|---|
Program | Subject Area & Catalogue Number | Course Name |
LBSP | COMP 1039 | Problem Solving and Programming |
LBMH | COMP 1039 | Problem Solving and Programming |
For LBSP and LBMH students whose programs do not include INFT 1016 Information Technology Fundamentals, COMP 1039 Problem Solving and Programming can be used as an alternative prerequisite.
Nil
Component | Duration | ||
---|---|---|---|
INTERNAL, MAWSON LAKES | |||
Lecture | 2 hours x 13 weeks | ||
Computer Practical | 2 hours x 12 weeks | ||
EXTERNAL, MAWSON LAKES, ONLINE | |||
External | N/A x 13 weeks |
Note: These components may or may not be scheduled in every study period. Please refer to the timetable for further details.
Continuous assessment, Practical examination, Problem solving exercise, Programming exercise
EFTSL*: 0.125
Commonwealth Supported program (Band 2)
To determine the fee for this course as part of a Commonwealth Supported program, go to:
How to determine your Commonwealth Supported course fee. (Opens new window)
Fee-paying program for domestic and international students
International students and students undertaking this course as part of a postgraduate fee paying program must refer to the relevant program home page to determine the cost for undertaking this course.
Non-award enrolment
Non-award tuition fees are set by the university. To determine the cost of this course, go to:
How to determine the relevant non award tuition fee. (Opens new window)
Not all courses are available on all of the above bases, and students must check to ensure that they are permitted to enrol in a particular course.
* Equivalent Full Time Study Load. Please note: all EFTSL values are published and calculated at ten decimal places. Values are displayed to three decimal places for ease of interpretation.