Module Specifications..
Current Academic Year 2023 - 2024
Please note that this information is subject to change.
| |||||||||||||||||||||||||||||||||||||||
None |
|||||||||||||||||||||||||||||||||||||||
Description This module provides an overview to data management aspects of Data Science. It provides students with an introduction to Databases. Students should learn how to design and create a database using the entity-relationship model, express queries in SQL, understand relational database theory and validation concepts such as normalisation and functional dependencies. | |||||||||||||||||||||||||||||||||||||||
Learning Outcomes 1. To understand the relational model theory that underpins database design. 2. To translate an informal problem specification into a well-formed Entity-Relationship model and map this to an appropriate relational schema. 3. To demonstrate a proficiency in writing SQL expressions to query and alter the database. 4. To understand the advantages of applying normalisation theory to validate database schemas. 5. To be able to apply summarisation and cleaning techniques in database applications for data science. | |||||||||||||||||||||||||||||||||||||||
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 EnvironmentOverview: Architecture, Components & Functions, Data Models.Relational ModelSchemas, constraints, violations.Relational AlgebraRelational Algebra OperatorsSQLProgramming in SQLData IntegrityCapturing and maintaining integrity in relational databases.Entity-Relationship ModellingUsing the E-R model to capture system requirements and database deployment.Functional DependencyUnderstanding functional dependency theory and rules.NormalisationApplying functional dependencies to ensure normalised databases.Data Preprocessing for Data ScienceSummarisation, cleaning and transformation of data. | |||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||
Indicative Reading List
| |||||||||||||||||||||||||||||||||||||||
Other Resources None | |||||||||||||||||||||||||||||||||||||||
Programme or List of Programmes
| |||||||||||||||||||||||||||||||||||||||
Archives: |
|