Course Resources Archive
IT220: Database Application Development
Module Title | Database Application Development |
---|---|
Module Code | IT220 |
Module Tutor | Andrew Tomlinson |
School | Computing and Technology |
CAT Points | 30 |
Level of Study | 5 |
Pre-requisites | Before taking this module you must pass IT120 |
Co-requisites | None |
Restrictions | None |
Brief Description | The module explores the ideas behind large-scale database development. It gives the student skills in Oracle, SQL, PL/SQL and interface development tools. Students will learn how to rapidly build enterprise-level database applications using Agile development techniques. |
Indicative Syllabus | Developing large multi-user databases. Practical development skills include SQL, PL/SQL, application development tools, and essential skills in Oracle. Theory and methodologies relevant to enterprise application development will be studied and then applied. |
Learning Outcomes | i Knowledge and Understanding By the end of this module, students will be able to: a) build, maintain and interrogate a database using SQL and other relevant database languages b) design and build appropriate database interfaces using commercial development tools c) explain fundamental theories, concepts and terms that support database development and database architecture d) understand and apply application development lifecycles and their components e) apply systems analysis and requirements specifications to build databases and their interfaces f) troubleshoot common database development problems g) compare and contrast vendor SQL and ANSI SQL ii. Skills On successfully completing the module students will have developed skills in: a) Communication and Literacy: students will need to explain complicated database technologies, and document and justify their specification choices. b) Problem Solving: the challengers facing database developers will be explored; students will investigate solutions and implement them. c) Independent Learning and Working: students will explore commercial database development tools and will be encouraged to formulate and evaluate solutions to representative system problems. d) Information and Communications Technology: students will use Oracle, SQL, PL/SQL and application development tools. e) Specific Vocational: students will gain database development skills, including: database design; database programming; data management; designing and building database interfaces. Oracle products will be used throughout. |
Learning and Teaching Activities | Staff/student contact approximately 30% including lectures, workshops and student led tutorials Student private study: approximately 70% |
Assessment (For further details see the Module Guide) | 001: 20% Coursework: Standard: 1500 words or equivalent 002: 30% Coursework: Project and Report: 2500 words or equivalent 003: 50% Coursework: Project Presentation and Report: 4000 words or equivalent |
Special Assessment Requirements | None |
Indicative Resources | The Library Catalogue contains full details of the current reading list for this module. Further details may also be found in the Module Guide. |