School Of Computer, Data And Mathematical SciencesDatabase Design and Development (WSTC)Western Sydney University Unit Code: 700011.5
Discipline: DATABASE MANAGEMENT
Student Contribution Band: 2
Level: 2
Credit Points: 10
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.
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. Through group work and tutorial practicals, students examine a number of important database concepts such as database administration, concurrency, backup and recovery and security whilst developing their professional communication and team work skills.
Courses| 6035.1 | Diploma/Bachelor of Information and Communications Technology | CONTINUING |
| 6036.1 | Diploma in Information and Communications Technology/Bachelor of Information Systems | CONTINUING |
| 6038.1 | Diploma/Bachelor of Information and Communications Technology (Health Information Management) | CURRENT |
| 6039.1 | Diploma/Bachelor of Information and Communications Technology | CURRENT |
| 6040.1 | Diploma in Information and Communications Technology/Bachelor of Information Systems | CURRENT |
| 7004.3 | Diploma in Information and Communications Technology Fast Track | CURRENT |
| 7138.1 | Diploma in Information and Communications Technology Extended - ICT | CURRENT |
| 7140.1 | Diploma in Information and Communications Technology Extended - Information Systems | CURRENT |
| 7141.1 | Diploma in Information and Communications Technology (Health Information Management) Extended | CURRENT |
| 7163.1 | Diploma in Information and Communications Technology | CURRENT |
| 7164.1 | Diploma in Information and Communications Technology (Health Information Management)(exit only) | CURRENT |
| 7174.1 | Undergraduate Certificate in Information and Communications Technology | CONTINUING |
Specialisations
| A7083.1 | WSTC Information and Communications Technology Ext Recent School Leavers | CURRENT |
| A7084.1 | WSTC Information and Communicatins Technology Ext International Students | CURRENT |
| A7095.1 | WSTC Information and Communications Technology Extended Non-Credentialed Applicants | CURRENT |
| A7164.1 | WSTC Information and Communications Technology Extended ICT - Recent School Leavers | CURRENT |
| A7165.1 | WSTC Information and Communications Technology Extended ICT - Non-Credentialed | CURRENT |
| A7166.1 | WSTC Information and Communications Technology Extended - ICT - International | CURRENT |
| A7170.1 | WSTC Information and Communications Technology Extended - InfoSys - Recent School Leaver | CURRENT |
| A7171.1 | WSTC Information and Communications Technology Extended - Info Sys - Non-Credentialed | CURRENT |
| A7172.1 | WSTC Information and Communications Technology Extended - Info Sys - International | CURRENT |
| A7173.1 | WSTC Information and Communications Technology (HealthInfoMgmt) Ext - Recent School Leaver | CURRENT |
| A7174.1 | WSTC Information and Communications Technology (HealthInfoMgmt) Ext - Non-Credentialed | CURRENT |
| A7175.1 | WSTC Information and Communications Technology (HealthInfMgmt) Extened - International | CURRENT |