This unit (VIT1201) introduces fundamental concepts underpinning the analysis and design of information systems and explains the role and purpose of systems analysis. Students gain mastery of standard techniques to identify system requirements and design a simple database system. Content includes: systems concepts; role of the analyst; Systems Development Life Cycle (SDLC), process modelling, Entity-Relationship (ER) modelling; relational database design using ER and Extended ER modelling, relational algebra, SQL (Structured Query Language), normalisation; and database management systems (DBMS).
Unit details
Location:
Study level:
Undergraduate
Credit points:
12
Unit code:
VIT1201
Get help
- Visit a student service centre
- 1300 VIC UNI (1300 842 864)
- Visit the glossary
Find a different unit
Learning Outcomes
1. | Describe the benefits and functions of databases and their applications; | ||
2. | Design a database using key relational database model concepts; | ||
3. | Develop and apply ER and EER diagrams; | ||
4. | Implement a relational database with multiple tables using a relational DBMS; | ||
5. | Apply query languages and manage a database using SQL; and | ||
6. | Normalise relations in a relational database system. |
Assessment
Melbourne campuses
Students studying under the VU Block Model.
Assessment type | Description | Grade |
---|---|---|
Test | SQL Test | 25% |
Test | Two quizzes (1 hour each) | 40% |
Case Study | Assignment | 35% |
Other locations
Assessment type | Description | Grade |
---|---|---|
Test | SQL Test | 25% |
Test | Two quizzes (1 hour each) | 40% |
Case Study | Assignment | 35% |
Where to next?
As part of a course
This unit is studied as part of the following courses. Refer to the course page for information on how to apply for the course.
VU takes care to ensure the accuracy of this unit information, but reserves the right to change or withdraw courses offered at any time. Please check that unit information is current with the Student Contact Centre.