| CODE | CIS3012 | ||||||||||||
| TITLE | Data Management for Information Professionals | ||||||||||||
| UM LEVEL | 03 - Years 2, 3, 4 in Modular Undergraduate Course | ||||||||||||
| MQF LEVEL | 6 | ||||||||||||
| ECTS CREDITS | 4 | ||||||||||||
| DEPARTMENT | Computer Information Systems | ||||||||||||
| DESCRIPTION | The beginning of the stuy-unit is dedicated to provide an understanding of the basics of databases and its associated terminology in use to describe data structures and data inter relationships. The study-unit quickly progresses to introduce the basics of SQL, a de facto standard for databases, for creating, updating and retrieving data from these data sources. After presenting basic data definition and manipulation constructs, attention is given for the retrieving of data through various combinations of restrictions, and combining data from a number of data sources. Of particular interest to information professionals is how SQL handles graph data and unstructured data, and controls interactions to a database through data driven coding. The later part of the stuy-unit relays on database management knowledge to build ebooks, web-pages through Content Management Systems (CMS), for example WordPress, and visualisation of data artefacts. To facilitate this basic knowledge of the web, web mark-up and styling languages (e.g. HTML, and CSS) are adopted. JSON and/or XML data encoding is also presented to enable the student's understanding and capability to read and export data from different repositories. Study-Unit Aims: The main aims are: - To provide an understanding of the pragmatics of building, marinating and using databases; - To encourage students to repack and present data in formats and layouts best suited for their data consumers; - To provide students with an appreciation and effective leverage of data visualisation. Learning Outcomes: 1. Knowledge & Understanding: By the end of the study-unit the student will be able to: - Explain a relational database as expressed by its structural rules (e.g. tables, keys and other constraints). - Operate SQL and its main sub languages (e.g. definition, manipulation, control) constructs to manage and maintain a database. - Select the right SQL construct to extract the required data. - Test the data quality of content and the preprocessing procedures deployed over data sources. - Classify web interface artefact's and identify what support a web page through stored data is needed for creating the right active environment. - Assemble and select a better usage of web-pages and web-sites generators that can interface with local and external databases. 2. Skills: The following skills are to be realized by using high level and automated computerized tools, which have a multitude of libraries that are applicable in information management (e.g. WordPress and PostgreSQL): - Use of SQL to retrieve and transform data; - Use of SQL to monitor and maintain data quality; - Use of SQL to retrieve data from a few internal (e.g. local) data sources; - Use of SQL to retrieve data from a few external (e.g. other database) data sources; - Use appropriate data management tools and data languages to move data from one repository to another; - Use a Content Management System (CMS) to create web-pages to display and manipulate data related to information content; - Use of a CMS to weave together related web-pages into a site; - Use the right tool to visualize data held in databases. Main Text/s and any supplementary readings: - Obe, R. O. & Hsu, L. S. (2017). PostgreSQL: Up and Running. O'Reilley Media Inc. - MacDonald, M. (2020). WordPress: The Missing Manual. O'Reilley Media Inc. and/or - Messenlehner, R. & Coleman, J. (2019). Building Web Apps with WordPress. O'Reilley Media Inc. |
||||||||||||
| ADDITIONAL NOTES | Pre-requisite Qualifications: LIA1100 Introduction to ICT for Information Professional | ||||||||||||
| STUDY-UNIT TYPE | Lecture and Practicum | ||||||||||||
| METHOD OF ASSESSMENT |
|
||||||||||||
| LECTURER/S | Owen Sacco Kelly Steer Joseph Vella (Co-ord.) |
||||||||||||
|
The University makes every effort to ensure that the published Courses Plans, Programmes of Study and Study-Unit information are complete and up-to-date at the time of publication. The University reserves the right to make changes in case errors are detected after publication.
The availability of optional units may be subject to timetabling constraints. Units not attracting a sufficient number of registrations may be withdrawn without notice. It should be noted that all the information in the description above applies to study-units available during the academic year 2024/5. It may be subject to change in subsequent years. |
|||||||||||||