Useful links
The ubiquitous use of information technology leaves us facing a tsunami of data produced by users, IT systems and mobile devices. The proper management of data is hence essential for all applications and for effective decision making within organizations. This unit of study will introduce the basic concepts of database designs at the conceptual, logical and physical levels. We will place particular emphasis on introducing integrity constraints and the concept of data normalization which prevents data from being corrupted or duplicated in different parts of the database. This in turn helps in the data remaining consistent during its lifetime. Once a database design is in place, the emphasis shifts towards querying the data in order to extract useful information. The unit will introduce the SQL database query languages, which is industry standard. Other topics covered will include the important concept of transaction management, application development with a backend database, and an overview of data warehousing and OLAP.
Study level | Undergraduate |
---|---|
Academic unit | Computer Science |
Credit points | 6 |
Prerequisites:
?
|
INFO1113 or INFO1103 or INFO1105 or INFO1905 or INFO1003 or INFO1903 or DECO1012 |
---|---|
Corequisites:
?
|
None |
Prohibitions:
?
|
INFO2120 or INFO2820 or COMP5138 |
Assumed knowledge:
?
|
Programming skills |
At the completion of this unit, you should be able to:
This section lists the session, attendance modes and locations the unit is available in. There is a unit outline for each of the unit availabilities, which gives you information about the unit including assessment details and a schedule of weekly activities.
The outline is published 2 weeks before the first day of teaching. You can look at previous outlines for a guide to the details of a unit.
Session | MoA ? | Location | Outline ? |
---|---|---|---|
Semester 2 2024
|
Normal day | Camperdown/Darlington, Sydney |
View
|
Session | MoA ? | Location | Outline ? |
---|---|---|---|
Semester 2 2025
|
Normal day | Camperdown/Darlington, Sydney |
Outline unavailable
|
Session | MoA ? | Location | Outline ? |
---|---|---|---|
Semester 2 2020
|
Normal day | Camperdown/Darlington, Sydney |
View
|
Semester 2 2021
|
Normal day | Camperdown/Darlington, Sydney |
View
|
Semester 2 2021
|
Normal day | Remote |
View
|
Semester 2 2022
|
Normal day | Camperdown/Darlington, Sydney |
View
|
Semester 2 2022
|
Normal day | Remote |
View
|
Semester 2 2023
|
Normal day | Camperdown/Darlington, Sydney |
View
|
Find your current year census dates
This refers to the Mode of attendance (MoA) for the unit as it appears when you’re selecting your units in Sydney Student. Find more information about modes of attendance on our website.