Unit

School Of Computer, Data And Mathematical Sciences

Database Design and Development (WSTC)Western Sydney University Unit Code: 700011.5

Discipline: DATABASE MANAGEMENT

Student Contribution Band: 2

Level: 2

Credit Points: 10

Co ordinator
Frank Gutierrez


Assumed Knowledge
Basic programming skills, including variable declaration, variable assignment, selection statement and loop structure.


Equivalent Units
300104 - Database Design and Development

Prerequisite

Students enrolled in 7067 Diploma in Information and Communications Technology Extended and 7134 Diploma in Information and Communications Technology Extended – ICT must pass 700199 Academic Communication 2 (WSTC Prep) or 700208 English for Tertiary Study 2 (WSTC Prep) or 700210 Introduction to Academic Communication 2 (WSTC Prep) and must pass 700201 Computer Studies (WSTC Prep) and must pass 700047 Programming Design (WSTC Prep) before enrolling in this unit.

Students enrolled in 7138 Diploma in Information and Communications Technology Extended-ICT, 7139 Diploma in Information and Communications Technology Extended, 7140 Diploma in Information and Communications Technology Extended–IS, and 7141 Diploma in Information and Communications Technology Extended-HIM must pass 700276 Academic and Professional Communication (WSTC Prep) and must pass 700278 Information Technology in Business (WSTC Prep) and must pass 700047 Programming Design (WSTC Prep).

Students enrolled in 6038 Diploma in Information and Communications Technology /Bachelor of Information and Communications Technology (HIM), 6039 Diploma in Information and Communications Technology/Bachelor of Information and Communications Technology, 6040 Diploma in Information and Communications Technology/Bachelor of Information Systems, 7163 Diploma in Information and Communications Technology and 7164 Diploma in Information and Communications Technology (HIM) must pass 700047 Programming Design (WSTC Prep).

Unit Enrolment Restrictions
Students must be enrolled at Western Sydney University, The College or in course 7174 Undergraduate Certificate in Information and Communications Technology. Students enrolled in Extended Diploma courses must have passed 40 credit points of preparatory units in order to enrol in this unit. Students enrolled in the combined Diploma/Bachelor courses listed below must pass all College Preparatory units listed in the course structure before progressing to the Year 2 units.


Teaching Periods

PeriodOffered  Campus  Contact
2020 Term 2  Yes  The College - Nirimba Education Precinct - DAY  Frank Gutierrez  Timetable.   Print Unit Outline*
2020 Term 3  Yes  The College - Nirimba Education Precinct - DAY  Frank Gutierrez  Timetable not available   Print Unit Outline*
2020 Block 3  Yes  Online - ONLINE  Jack Isherwood  Timetable not available   Print Unit Outline*
2020 Block 4  Yes  Online - ONLINE  Jack Isherwood  Timetable not available   Print Unit Outline*
2021 Term 2  Yes  The College - Nirimba Education Precinct - DAY  Frank Gutierrez  Timetable not available  
2021 Term 3  Yes  The College - Nirimba Education Precinct - DAY  Frank Gutierrez  Timetable not available  

*If using Safari, Firefox or Chrome to print the Unit Outline, right-click on the Print Unit Outline link and select 'Save link as...' or in Safari 'Download Linked File'


About this Unit
The main purpose of this unit is to provide students with an opportunity to gain a basic knowledge of database design and development including data modeling methods, techniques for database design using a set of business rules that are derived from a case study and finally implementation of the database using a commercial relational database management system. The unit also examines a number of important database concepts such as database administration, concurrency, backup and recovery and security. At the same time student learning and intercommunication skills are enhanced by running tutorial presentations and group assignments.


Courses
6035.1Diploma/Bachelor of Information and Communications TechnologyCONTINUING
6036.1Diploma in Information and Communications Technology/Bachelor of Information SystemsCONTINUING
6038.1Diploma/Bachelor of Information and Communications Technology (Health Information Management)CURRENT
6039.1Diploma/Bachelor of Information and Communications TechnologyCURRENT
6040.1Diploma in Information and Communications Technology / Bachelor of Information SystemsCURRENT
7004.3Diploma in Information and Communications Technology Fast TrackCURRENT
7005.3Diploma in Information and Communications TechnologyCONTINUING
7067.1Diploma in Information and Communications Technology ExtendedCONTINUING
7067.2Diploma in Information and Communications Technology ExtendedCONTINUING
7138.1Diploma in Information and Communications Technology Extended - ICTCURRENT
7139.1Diploma in Information and Communications Technology ExtendedCONTINUING
7140.1Diploma in Information and Communications Technology Extended - Information SystemsCURRENT
7141.1Diploma in Information and Communications Technology (Health Information Management) ExtendedCURRENT
7163.1Diploma in Information and Communications TechnologyCURRENT
7164.1Diploma in Information and Communications Technology (Health Information Management)(exit only)CURRENT
7174.1Undergraduate Certificate in Information and Communications TechnologyCURRENT


Specialisations

A7000.1WSTC Information and Communications Technology Extended Local Recent School LeaversCONTINUING
A7001.1WSTC Information and Communications Technology Extended International StudentsCONTINUING
A7002.1WSTC Information and Communications Technology Extended Non-Credentialed ApplicantsCONTINUING
A7083.1WSTC Information and Communications Technology Ext Recent School LeaversCURRENT
A7084.1WSTC Information and Communicatins Technology Ext International StudentsCURRENT
A7095.1WSTC Information and Communications Technology Extended Non-Credentialed ApplicantsCURRENT
A7164.1WSTC Information and Communications Technology Extended ICT - Recent School LeaversCURRENT
A7165.1WSTC Information and Communications Technology Extended ICT - Non-CredentialedCURRENT
A7166.1WSTC Information and Communications Technology Extended - ICT - InternationalCURRENT
A7167.1WSTC Information and Communications Technology Extended - Recent School LeaversCURRENT
A7168.1WSTC Information and Communications Technology Extended - Non-CredentialedCURRENT
A7169.1WSTC Information and Communications Technology Extended - InternationalCURRENT
A7170.1WSTC Information and Communications Technology Extended - InfoSys - Recent School LeaverCURRENT
A7171.1WSTC Information and Communications Technology Extended - Info Sys - Non-CredentialedCURRENT
A7172.1WSTC Information and Communications Technology Extended - Info Sys - InternationalCURRENT
A7173.1WSTC Information and Communications Technology (HealthInfoMgmt) Ext - Recent School LeaverCURRENT
A7174.1WSTC Information and Communications Technology (HealthInfoMgmt) Ext - Non-CredentialedCURRENT
A7175.1WSTC Information and Communications Technology (HealthInfMgmt) Extened - InternationalCURRENT




Western Sydney University Copyright © 2004-2016 ABN 53 014 069 881 CRICOS Provider No: 00917K Contact Us | Disclaimer | Emergency Help |