Managing data Managing data data including: resolve simple many to many (M:N) number relationship in a multi-table relational date/time database system (maximum three currency entities) text (string) create using Chen’s notation entity Boolean (true/false) relationship (ER) diagrams for a simple database terms database solution (maximum three data, field, record, relation, atomicity entities) data integrity create a working relational multi-table data redundancy database using: 10–14 ethical and legal issues relating to the personal data types use and storage of data relations legal requirement and implication of information primary and foreign keys kept by various organisations about individuals relationships design considerations for visual interfaces and cardinality (1:1, 1:M, M:1, M:N) navigation systems within database systems validation rules purpose of database documentation for the user forms data modelling using Chen’s notation entity reports relationships diagrams queries create a visual interface for a database create database documentation 15 Revision 16 Semester 1 examination Semester 2 Unit 2 – Key teaching points Week Knowledge Skills Course review review unit 1 review assessment requirements overview of semester 2 Developing software evolution of programming languages machine assembler procedural non-procedural 1 object-oriented purpose and function of software to operate a computer system operating systems utility software file compression defragmenter anti-virus anti-malware application software
10–14 Managing data data including: number date/time currency text (string) Boolean (true/false) database terms data, field, record, relation, atomicity data integrity data redundancy ethical and legal issues relating to the personal use and storage of data legal requirement and implication of information kept by various organisations about individuals design considerations for visual interfaces and navigation systems within database systems purpose of database documentation for the user data modelling using Chen’s notation entity relationships diagrams Managing data resolve simple many to many (M:N) relationship in a multi-table relational database system (maximum three entities) create using Chen’s notation entity relationship (ER) diagrams for a simple database solution (maximum three entities) create a working relational multi-table database using: data types relations primary and foreign keys relationships cardinality (1:1, 1:M, M:1, M:N) validation rules forms reports queries create a visual interface for a database create database documentation 15 Revision 16 Semester 1 examination Semester 2 – Unit 2 Week Key teaching points Knowledge Skills 1 Course review review unit 1 review assessment requirements overview of semester 2 Developing software evolution of programming languages machine assembler procedural non-procedural object-oriented purpose and function of software to operate a computer system operating systems utility software file compression defragmenter anti-virus anti-malware application software
Computer-Science-ATAR-Y11-sample-course-outline-WACE-201516.docx