module specification

This module builds upon the student's general understanding of database design and implementation from prior learning. It discusses some key issues underpinning database   management   systems   and   their   development,  provides   a   strong coverage  to  advanced SQL,  which helps  preparing  for  professional  certification. Introduces  some  current  topics  in  database  technology such as NoSQL.  In  addition,  the module  contains  a  substantial  practical  element  utilising  advanced  SQL  and full- stack web development framework application enabling students to   gain   transferable   skills   in   designing   and developing relatively complex ‘real life’ database applications using web database technologies.

The module will enable students to:
•Gain in-depth   understanding   of   some   key   issues pertinent   to   the management and development of modern database applications.
•Acquire skills  in  advanced  SQL  which  provides  an  opportunity  for  gaining professional certification.
•Introduced to current developments in database technology thereby raising students’  awareness  and  understanding  of  the  future  trend  in  SQL and NoSQL  systems development.
•Design and  develop  relatively  complex  business  web database application  using  industry-standard  database  products  (e.g.  Oracle Server/SQL Server/ MongoDB with .NET Core and MVC Framework).

Successful completion of Level 5 or equivalent

-Database architectures, key issues in database systems and their management. LO1

-Types of databases and their comparison (e.g., Relational and non-relational),cloud computing, data mining. LO1, LO4

-Database security: identification and authentication; discretionary access control and mandatory access control. LO1, LO2

-Distributed databases: distributed architectures; transparency; replication; fragmentation; distributed query processing. LO1, LO2, LO4

-Advanced coverage of SQL related to SQL certification, including:
Single-Row Functions; Aggregating Data using Group Functions; Advanced Subqueries; Manipulating Data. (DML statements, merging rows, control transactions)
Creating and maintaining constraints; Creating and maintaining other database objects including sequences, indexes and synonyms. LO1

-Web data development environment and tools: Oracle SQL developer; ADO.NET and full-stack web application development. LO2, LO4, LO5

-Designing, building and developing substantial Web Data applications: e.g.: MVC framework. LO2, LO5

Topics will be introduced through a combination of formal lectures, tutorials, supervised workshop sessions, and blended learning as follows:

-Lecture (1 hour / week):
  Introduce the designated topics in the syllabus, ranging from key aspects of database management and development to current database technologies.

-Tutorial/ Workshop (2 hour / week):
  Tutorial sessions aim to consolidate the understanding of topics covered in the lectures including class and group discussions in the tutorial sessions.
  Workshop sessions facilitate students to gain adequate hands-on experience and practical proficiency of using the chosen database development environment and tools.

-Blended learning:
  Lecture notes and other support learning material will be available on the university VLE network (e.g. WebLearn)

-Reflective learning:
  Students will be expected and encouraged to produce reflective commentaries and an action plan for personal development on the learning activities and tasks that they carry out to complete their work, e.g. in the form of an assessed section of their coursework report.

In addition, students are strongly advised to read widely of relevant materials from books, journals and the internet in order to acquire a better understanding of the subject.

On successful completion of this module students should be able to:

- LO1: Demonstrate a clear understanding of some key issues which affect database systems and their management.

- LO2: Gain a considerable exposure to the practical issues, as well as their theoretical underpinning, pertinent to the development of modern web database applications, including database development environment and tools (e.g., Oracle SQL developer/SQL Server/MongoDB with a full-stack development framework).

- LO3: Demonstrate a sufficient level of knowledge and proficiency in advanced SQL, which provides an opportunity to prepare for the first stage of Oracle professional certification.

- LO4: Demonstrate an enhanced awareness of some current developments in database technologies.

- LO5: Design and develop substantial ‘real life’ web-data application for a given business scenario, with a professional approach to the system documentation.

The assessment strategy for the module aims to enable the students to demonstrate their achievement on the stated learning outcomes:

•The students’ knowledge and understanding of the key issues of database management and developments are assessed by an unseen Examination. (LO1, LO2, LO4)
•The students ‘practical problem-solving skills and critical thinking/evaluation on the design and development of database systems (using SQL and database development tools) are assessed by an individual Coursework based on a given business scenario. (LO2, LO5)
•The Class Test enables the students to demonstrate their knowledge and proficiency in advanced SQL relevant to professional certification. (LO3)

Arrangements for formative and summative feedback:

•Formative feedback to the students is provided on an on-going basis both through informal tutorial/workshop discussions and on a one-to-one basis, covering major topics of study and students’ progress on the module.
•Summative feedback will be available following the class test and the coursework.

Link to the booklist: https://rl.talis.com/3/londonmet/lists/A441794C-1305-9F08-DF4E-9479BE57BF57.html?lang=en&login=1