Database Design (5915.6)
Level: | Level 1 - Undergraduate Introductory Unit |
---|---|
Credit Points: | 3 |
HECS Bands: | 2 |
Faculty: | Faculty of Science and Technology |
Discipline: | Academic Program Area - Technology |
Availability
-
UC - Canberra, Bruce
Year Teaching Period Convener Mode of Delivery 2020 Semester 1 MS Yuting ZHAO (Ph: ) ON-CAMPUS 2020 Semester 2 DR Masoud MOHAMMADIAN (Ph: +61 2 62012917 ) ON-CAMPUS -
UC - University of Canberra College, Bruce
Year Teaching Period Convener Mode of Delivery 2020 UC College Trimester 2 MR Tariq ALQURA'N ALZYADAT (Ph: +61 2 62015953 ) ON-CAMPUS 2020 UC College Trimester 3 MR Tariq ALQURA'N ALZYADAT (Ph: +61 2 62015953 ) ON-CAMPUS
Possible changes to your unit's learning activities and assessment items
For the remainder of 2020, resulting from Australian Government's directives requiring physical distancing and restrictions on movement because of the COVID-19 pandemic, any exams that are required for assessment in a unit will be online exams. Online exams may also use online proctoring to help assure the academic integrity of those exams. Please contact your unit convener with any questions.
While the University has made efforts to ensure that Unit Outlines reflect a unit’s learning activities and assessment items, any changes to Australian Government directives because of the COVID-19 pandemic may require changes to these during the semester to ensure the safety and well being of students and staff. These changes will not be updated in the published unit outline, but will be communicated to you via your unit’s UCLearn(Canvas) teaching site. Any changes made will continue to meet the unit’s learning outcomes, as described in the Unit Outline.
Unit Outlines
To view your Unit Outline, click View to log in to MyUC and access this information, or visit your unit's online teaching site.
- Semester 2, 2020, ON-CAMPUS, BRUCE (195592) - View
- UC College Trimester 2, 2020, ON-CAMPUS, UCC-BRUCE (195042) - View
- Semester 1, 2020, ON-CAMPUS, BRUCE (194000) - View
- UC College Trimester 3, 2019, ON-CAMPUS, UCC-BRUCE (189814) - View
- Semester 2, 2019, ON-CAMPUS, BRUCE (185324) - View
- UC College Trimester 2, 2019, ON-CAMPUS, UCC-BRUCE (185688) - View
- UC College Trimester 1, 2019, ON-CAMPUS, UCC-BRUCE (185671) - View
- Semester 1, 2019, ON-CAMPUS, BRUCE (185044) - View
- UC College Trimester 3, 2018, ON-CAMPUS, UCC-BRUCE (183215) - View
- Semester 2, 2018, ON-CAMPUS, BRUCE (183229) - View
- UC College Trimester 2, 2018, ON-CAMPUS, UCC-BRUCE (183214) - View
- UC College Trimester 1, 2018, ON-CAMPUS, UCC-BRUCE (183213) - View
- Semester 1, 2018, ON-CAMPUS, GBCA-MELB (183228) - View
- Semester 1, 2018, ON-CAMPUS, BRUCE (183227) - View
- UC College Trimester 3, 2017, ON-CAMPUS, UCC-BRUCE (166532) - View
- Semester 2, 2017, ON-CAMPUS, BRUCE (167662) - View
- UC College Trimester 2, 2017, ON-CAMPUS, UCC-BRUCE (165608) - View
- UC College Trimester 1, 2017, ON-CAMPUS, UCC-BRUCE (165563) - View
- Semester 1, 2017, ON-CAMPUS, GBCA-MELB (171418) - View
- Semester 1, 2017, ON-CAMPUS, BRUCE (167158) - View
- UC College Trimester 3, 2016, ON-CAMPUS, UCC-BRUCE (150006) - View
- Semester 2, 2016, ON-CAMPUS, UC-MELB (151814) - View
- Semester 2, 2016, ON-CAMPUS, SWSI-LVPL (151815) - View
- Semester 2, 2016, ON-CAMPUS, BRUCE (151816) - View
- UC College Trimester 2, 2016, ON-CAMPUS, UCC-BRUCE (152709) - View
- UC College Trimester 1, 2016, ON-CAMPUS, UCC-BRUCE (153271) - View
- Semester 1, 2016, ON-CAMPUS, SWSI-LVPL (154995) - View
- Semester 1, 2016, ON-CAMPUS, SWSI-LVPL (154995) - View
- Semester 1, 2016, ON-CAMPUS, BRUCE (154993) - View
- UC College Trimester 3, 2015, ON-CAMPUS, UCC-BRUCE (142547) - View
- Semester 2, 2015, ON-CAMPUS, SWSI-LVPL (140590) - View
- Semester 2, 2015, ON-CAMPUS, BRUCE (140592) - View
- UC College Trimester 1, 2015, ON-CAMPUS, UCC-BRUCE (142506) - View
- Semester 1, 2015, ON-CAMPUS, BRUCE (146191) - View
- Semester 2, 2014, ON-CAMPUS, UC-MELB (138510) - View
If a link to your Unit Outline is not displayed, please check back later. Unit Outlines are generally published by Week One of the relevant teaching period.
Syllabus
This subject introduces a practical approach to the development and design of database systems. The emphasis is placed on relational database management systems, their development and implementation in a modern organisational environment. The use of modern query languages for relational databases is discussed and experienced. Conceptual, logical and physical database design issues are also covered. Other topics include client server database computing and database administration issues.
Learning Outcomes
DESCRIPTION:
1. students will be able to list, describe, and illustrate the steps in a database system development life cycle.
2. illustrate the inputs and outputs in that process, with an emphasis on data modelling
3. Students will acquire data analysis skills
4. develop an appropriate set of data models for relational database implementation
5. The students will also be able to demonstrate the use of the SQL language in a database server environment.
Assessment Items
Contact Hours
Up to 4 hours a week of lectures, tutorials, laboratory work and project work.
Prerequisites
None.
Corequisites
None.
Assumed Knowledge
None.
Referenced Courses
- 182JA Bachelor of Accounting
- 943AA Bachelor of Applied Economics
- 986AA Bachelor of Arts / Bachelor of Advertising and Marketing Communication
- 987AA Bachelor of Arts / Bachelor of Journalism
- 988AA Bachelor of Arts / Bachelor of Media Arts and Production
- 989AA Bachelor of Arts / Bachelor of Public Relations
- 798AA Bachelor of Arts/Bachelor of Commerce
- 125JA Bachelor of Arts/Bachelor of Communication and Media Studies
- 216JA Bachelor of Arts/Bachelor of Communication in Advertising
- 217JA Bachelor of Arts/Bachelor of Communication in Journalism
- 218JA Bachelor of Arts/Bachelor of Communication in Media and Public Affairs
- 219JA Bachelor of Arts/Bachelor of Communication in Public Relations
- 799AA Bachelor of Arts/Bachelor of Information Technology
- 801AA Bachelor of Arts/Bachelor of Laws
- 802AA Bachelor of Arts/Bachelor of Management
- 804AA Bachelor of Arts/Bachelor of Science in Psychology
- 183JA Bachelor of Australian Politics and Public Policy
- 761AA Bachelor of Business Administration
- 806AA Bachelor of Business Administration/Bachelor of Business Informatics
- 706AA Bachelor of Business Informatics
- 808AA Bachelor of Business Informatics/Bachelor of Laws
- MGIT03 Bachelor of Business/ Bachelor of Business Informatics
- MGIT02 Bachelor of Business/ Bachelor of Information Technology
- 762HG Bachelor of Commerce
- 762AA Bachelor of Commerce
- 100JA Bachelor of Commerce / Bachelor of Advertising and Marketing Communication
- MGIT01 Bachelor of Commerce/ Bachelor of Information Technology
- 232JA Bachelor of Commerce/Bachelor of Communication in Journalism
- 281JA Bachelor of Commerce/Bachelor of Event and Tourism Management
- 811AA Bachelor of Commerce/Bachelor of Tourism Management
- 203JA Bachelor of Education
- 112JA Bachelor of Education/Bachelor of Commerce
- 115JA Bachelor of Education/Bachelor of Science
- 205JA Bachelor of Educational Studies
- ETB001 Bachelor of Engineering (Honours)
- ITB101 Bachelor of Engineering Technology
- 106JA Bachelor of Engineering in Network and Software Engineering
- 344JA Bachelor of Engineering in Network and Software Engineering (Honours)
- 208JA Bachelor of Entrepreneurship and Innovation
- 279JA Bachelor of Event and Tourism Management
- 184JA Bachelor of Finance
- 185JA Bachelor of Human Resource Management
- 322HG Bachelor of Information Technology
- 322AA Bachelor of Information Technology
- 998AA Bachelor of Information Technology / Bachelor of Media Arts and Production
- 815AA Bachelor of Information Technology/Bachelor of Commerce
- ITB001 Bachelor of Information and Mainframe Technology
- 186JA Bachelor of International Business
- 248HG Bachelor of Justice Studies
- 248JA Bachelor of Justice Studies
- 394AA Bachelor of Management
- 187JA Bachelor of Marketing Management
- 124JA Bachelor of Politics and International Relations
- 210JA Bachelor of Public Administration
- 392AB Bachelor of Science
- 994AA Bachelor of Science / Bachelor of Journalism
- NPSC01 Bachelor of Science/ Bachelor of Laws
- 836AA Bachelor of Science/Bachelor of Laws
- 330JA Bachelor of Secondary Education (Health and Physical Education)
- 329JA Bachelor of Secondary Education/Bachelor of Mathematics and Computing Technology Studies
- 328JA Bachelor of Secondary Education/Bachelor of Science
- 188JA Bachelor of Social Science
- 560AA Bachelor of Software Engineering
- 838AA Bachelor of Software Engineering/Bachelor of Business Informatics
- 157JA Bachelor of Sport Coaching and Exercise Science/Bachelor of Information Technology
- 277JA Bachelor of Sport and Exercise Science/Bachelor of Information Technology
- 189JA Diploma of Business Informatics
- 189JB Diploma of Business Informatics (Extended)
- 935AA Diploma of Information Technology
- 936AA Diploma of Information Technology (Extended)
- 353JA Diploma of Network and Software Engineering
Referenced Majors & Minors
- BM0039 Breadth Major in Digital Skills
- CM0018 Core Major in Information Technology and Systems
- MJ0244 Major in Computing Technology Teaching (Software Design and Development) (Restricted)
- MJ0059 Major in Information Systems
- MJ0058 Major in Information Systems (BBI) (Restricted)
- MJ0238 Major in Information Systems (BIT)
- MJ0057 Major in Information Systems (BIT) (Restricted)
- MJ0162 Major in Information Systems (BSE/BBI) (Restricted)
- MJ0056 Major in Information Systems (Restricted)
- MJ0276 Major in Information Technology
- MN0055 Minor in IT: Information Management
- MN0057 Minor in IT: Support
- MN0058 Minor in IT: Teaching in Schools
- MN0045 Minor in Information Systems
- MN0046 Minor in Information Systems (Restricted)
- SM0061 Specialist Major in Network and Software Engineering
- SM0062 Specialist Major in Robotics and AI (Engineering)