Registry
Module Specifications
Archived Version 2020 - 2021
| |||||||||||||||||||||||||||||||||||||
Description This module aims to familiarise the student with all aspects of database deployment in the modern business environment. It aims to ensure that the student has a sound grasp of key database technologies and software architectures and their environments and how these support on business processes and systems. The module gives the student a practical understanding of database deployment. It provides the student with the practical skills which will allow them to understand all aspects of database management from the point of view of provision of timely information to key business processes. | |||||||||||||||||||||||||||||||||||||
Learning Outcomes 1. Demonstrate a comprehensive understanding of the software architecture of a major database management system which is deployed widely in industry. 2. Apply the development lifecycle of software applications which use database technology. The student will be familiar with the design and implementation and rollout stages of such applications. 3. Design and build basic database applications using a variety of interfaces to the database (e.g. SQL, PHP) 4. Interact with a large database management system and ancillary application systems | |||||||||||||||||||||||||||||||||||||
All module information is indicative and subject to change. For further information,students are advised to refer to the University's Marks and Standards and Programme Specific Regulations at: http://www.dcu.ie/registry/examinations/index.shtml |
|||||||||||||||||||||||||||||||||||||
Indicative Content and
Learning Activities Database development processDatabase development process; developing a database applicationEnhanced E-R Model and Business RulesRepresenting super-types and sub-types; entity clusteringLogical database design and the relational modelRelational data model, integrity constraints, transforming EER diagrams into relations, normalisationPhysical database design and performancePhysical database design process, designing fields, using and selecting indexesClient/server database environmentClient/Server architecturesData WarehousingBasic concepts of data warehousing, data warehouse architectures, some characteristics of data warehouse dataData Quality and IntegrationManaging data quality, data integration, data transformationData and Database AdministrationRoles of data and database administrators, managing data security, database backup and recovery | |||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||
Indicative Reading List
| |||||||||||||||||||||||||||||||||||||
Other Resources None | |||||||||||||||||||||||||||||||||||||
Programme or List of Programmes | |||||||||||||||||||||||||||||||||||||
Archives: |
|