SECTION A: DEFINITIVE MODULE RECORD. Proposed changes must be submitted via Faculty Quality Procedures for approval and issue of new module code. MODULE CODE: CORC2109 MODULE TITLE: Multi-user Databases CREDITS: 10 FHEQ Level: 5 JACS/HECos CODE: I240/ 100754 PRE-REQUISITES: None CO-REQUISITES: None COMPENSATABLE: Yes SHORT MODULE DESCRIPTOR: (max 425 characters) This module will introduce students to multi-user, networked relational database environment (ORACLE) and SQL, focus on access, construction, data manipulation and reporting. ELEMENTS OF ASSESSMENT Use HESA KIS definitions] WRITTEN EXAMINATION COURSEWORK PRACTICAL E1 (Examination) 0% C1 (Coursework) 35% P1 (Practical) 0% E2 (Clinical 0% A1 (Generic 0% Examination) Assessment) T1 (Test) 65% SUBJECT ASSESSMENT PANEL Group to which module should be linked: Camborne Professional body minimum pass mark requirement: MODULE AIMS: To introduce students to the concepts and issues concerning multi-user networked relational databases in a practical environment. To provide a solid foundation in SQL queries, statements and reports. ASSESSED LEARNING OUTCOMES: (additional guidance below) At the end of the module the learner will be expected to be able to: Construct effective SQL statements and provide appropriate reports using appropriate command constructs. Explain the methods of providing data consistency and concurrency within a given database environment. Describe the features of a given database configuration. 12 January DATE OF APPROVAL: FACULTY/OFFICE: Academic Partnerships 2012 DATE OF IMPLEMENTATION: 01 September SCHOOL/PARTNER: Cornwall College
SECTION A: DEFINITIVE MODULE RECORD. Proposed changes must be submitted via Faculty Quality Procedures for approval and issue of new module code. MODULE CODE: CORC2109 MODULE TITLE: Multi-user Databases CREDITS: 10 FHEQ Level: 5 JACS/HECos CODE: I240/ 100754 PRE-REQUISITES: None CO-REQUISITES: None COMPENSATABLE: Yes SHORT MODULE DESCRIPTOR: (max 425 characters) This module will introduce students to multi-user, networked relational database environment (ORACLE) and SQL, focus on access, construction, data manipulation and reporting. ELEMENTS OF ASSESSMENT Use HESA KIS definitions] WRITTEN EXAMINATION COURSEWORK PRACTICAL E1 (Examination) 0% C1 (Coursework) 35% P1 (Practical) 0% E2 (Clinical Examination) 0% A1 (Generic Assessment) 0% T1 (Test) 65% SUBJECT ASSESSMENT PANEL Group to which module should be linked: Camborne Professional body minimum pass mark requirement: MODULE AIMS: To introduce students to the concepts and issues concerning multi-user networked relational databases in a practical environment. To provide a solid foundation in SQL queries, statements and reports. ASSESSED LEARNING OUTCOMES: (additional guidance below) At the end of the module the learner will be expected to be able to: Construct effective SQL statements and provide appropriate reports using appropriate command constructs. Explain the methods of providing data consistency and concurrency within a given database environment. Describe the features of a given database configuration. DATE OF APPROVAL: 12 January 2012 FACULTY/OFFICE: Academic Partnerships DATE OF IMPLEMENTATION: 01 September SCHOOL/PARTNER: Cornwall College