Course Title: Database Concepts A
Part A: Course Overview
Course Title: Database Concepts A
Credit Points: 12.00
Terms
Course Code |
Campus |
Career |
School |
Learning Mode |
Teaching Period(s) |
ISYS2390 |
City Campus |
Undergraduate |
155T Vocational Health and Sciences |
Face-to-Face |
Sem 1 2008, Sem 2 2008, Sem 2 2009, Sem 2 2010, Sem 1 2011, Sem 2 2011, Sem 1 2012, Sem 2 2012, Sem 1 2013, Sem 2 2013, Sem 1 2014, Sem 2 2014, Sem 1 2015, Sem 2 2015, Sem 1 2016, Sem 2 2016 |
ISYS2390 |
City Campus |
Undergraduate |
174T School of VE Engineering, Health & Science |
Face-to-Face |
Sem 1 2018, Sem 2 2018, Sem 1 2019, Sem 2 2019, Sem 1 2020, Sem 2 2020 |
ISYS2390 |
City Campus |
Undergraduate |
520T Future Technologies |
Face-to-Face |
Sem 2 2022, Sem 1 2023 |
Course Coordinator: Ayesha Falki
Course Coordinator Phone: +61 3 9925 4475
Course Coordinator Email: ayesha.falki@rmit.edu.au
Course Coordinator Location: RMIT Building 57, Level 5
Pre-requisite Courses and Assumed Knowledge and Capabilities
There is an assumed knowledge of basic computer literacy.
Please be aware that this course forms part of AD006 (Associate Degree in Information Technology) and is not part of the BP162 (Bachelor of Information Technology) study plan. Also, it will follow the Vocational Education calendar dates and not the Higher Ed semester dates which means that classes will start 3 weeks earlier. The timetable is published under the Vocational Education timetable link and is not available on STS. If you enrol in this course as an elective please check with your program coordinator before commencement as this is not a bachelor course.
Course Description
Databases and database technology are having a major impact on the growing use of computers. This course is an introduction to principles, use and applications of database systems.
On completion of the course you will be able to understand the purposes for which databases are used, design and create databases, query/extract information from databases and understand in broad terms how database systems work.
Objectives/Learning Outcomes/Capability Development
This course contributes to the following Program Learning Outcomes for AD006 Associate Degree in Information Technology:
• Enabling Knowledge
• Problem solving
On successful completion of this course you will be able to:
1.Use the principles underlying database systems and explain the purposes for which they are used.
2.Describe the relational model and model data as relations.
3.Create description of a relational database using Entity Relationship Model.
4.Formulate queries in relational algebra and use SQL to manipulate data in relational database..
5.Define views and their purposes and formulate and interpret queries on views.
6.Create procedures to manipulate data in database
Overview of Learning Activities
You will learn through a combination of lectures, tutorials, and laboratory exercises.
Lectures: Key concepts are explained, course material is presented, and the subject matter is illustrated with demonstrations and examples.
The Tutorial/Laboratory sessions will provide you with hands-on experience in using SQL Server. They will focus on designing a database based on a given scenario.
Overview of Learning Resources
You will make use of computer laboratories and relevant software provided by the School. All materials will be provided online through myRMIT.
Lists of relevant textbooks, reference texts, resources in the Library and relevant internet sites will be provided.
The computer science subject guide is located at http://rmit.libguides.com/compsci
Overview of Assessment
☒ This course has no hurdle requirements.
Assessment tasks
To pass this course you must achieve a total score of at least 50%.
Assessment Task 1: Assignments
This assessment task is a project or scenario based.
Weighting towards final grade (%): 30%
This assessment task supports CLOs 1-6
Assessment Task 2: Practical Test
This assessment task consists of a practical test.
Weighting towards final grade (%): 30%
This assessment task supports CLOs 4-6
Assessment Task 3: Final Written Exam
Weighting towards final grade (%): 40%
The exam will be conducted in two stages which will be 20% each.
This assessment task supports CLOs 1-6
Feedback on your performance in the assessments will be given on a regular basis during the semester. Written comments will be posted on the Canvas Grade Center.