module specification

CC5002 - Databases and Web-based Information Systems (2018/19)

Module specification Module approved to run in 2018/19
Module title Databases and Web-based Information Systems
Module level Intermediate (05)
Credit rating for module 30
School School of Computing and Digital Media
Total study hours 300
 
81 hours Scheduled learning & teaching activities
219 hours Guided independent study
Assessment components
Type Weighting Qualifying mark Description
Coursework 60%   Coursework - development of a database-driven web-based information system for a specified business problem
Unseen Examination 40%   2-hour exam
Running in 2018/19 No instances running in the year

Module summary

This module provides an appreciationof database and web-based information systems.It coverstechnical aspectsof analysing, designing and implementing database and web-based information systems. Both server-side programming language (e.g. ASP.NET) and back-end database programming language (e.g.Oracle SQL) skills are taught. 

Prior learning requirements

Successful completion of  level 4 or equivalent

Module aims

The aims of this module are to:
Provide students with an understanding of the concepts and fundamentals of database and web-based information systems.
Equip students with knowledge and skills for analysing, designing and implementing database systems.
Develop students with knowledge and skills to develop database-driven web-based information systems

Syllabus

• Concepts and fundamentals of database and web-based information systems
• The relational model:  data models, the terminology of the relational model, primary/foreign keys, and data integrity
• Database analysis and design techniques: fact finding, entity relationship modelling, and normalisation
• Data definition, manipulation, and control with SQL: creation, insertion, deletion, update, querying, and views
• Database Administration: the database team, privacy, backup and recovery, monitoring, applications support, operating support, testing databases
• Data Warehousing and data mining in business applications
• Web-based information system development
• Server-side programming language (e.g. ASP.NET): web forms, web objects, database connectivity
• Building and deploying web database applications as an information system
• Business related issues in the context of database and web-based information systems
 

Learning and teaching

Topics will be introduced through the medium of formal lectures, supported by tutorial and workshop sessions, and blended learning as follows:
- Lecture (1 hour / week):
Introduction of the major topics identified in the syllabus, plus for practical exercises, directed reading and other further study
- Tutorial/ Workshop (2 hour / week):
Consolidating understanding of topics introduced in the lecture via class and group discussions, informal presentations and other activities in the tutorial sessions.
Database and web-based information system design and development skills will be further developed through lab-based workshops. Specific practical exercises are set to support students' development of skills in essential database design and web applications development.
- Blended learning:
Using the University’s VLE and online tools to provide deliver content, assessment and feedback, to encourage active learning, and to enhance student engagement and learning experience.

Students will be expected and encouraged to produce reflective commentaries on the learning activities and tasks that they carry out to complete their work.

Learning outcomes

LO1. appreciate the context, role and architecture of database and web-based information systems
LO2. produce an Entity Relationship model from an example problem specification
LO3. manipulate and extract data stored in a database using SQL
LO4. design and implement a database system from a conceptual data model
LO5. develop a dynamic website that interacts with a database using ASP.NET
LO6. appreciate business related issues in the context of database and web-based information systems
 

Assessment strategy

The module will be assessed by a practical piece of coursework (70%) and a 2-hour unseen examination (30%).

The coursework is designed mainly to assess the practical aspects of the module. It is divided into two parts: database design (LO3, LO4) and web-based information system development (LO5).It requires the student to analyse, design and implement a database-driven web-based information system for a specified business problem. It will provide students with the opportunity to undertake research on current issues and practical techniques in database and web-based information systems. It will also enable students to apply their knowledge to a practical business problem, demonstrating their skills for problem-solving and critical thinking/evaluation (LO6).

The unseen examination will provide an opportunity for students to demonstrate their understanding of database and web-based information systems concepts and techniques (LO1,LO6) and their ability to apply these techniques appropriately to the solution of given problems/scenarios(LO2, LO3).The examination will test the students' retention, understanding and insight of material drawn from the module.
 

Bibliography

Bibliography:
1. Connolly, T., Begg, C. & Holowczak, R., 2008. Business Database Systems 1st ed., Addison Wesley.
2. Connolly, T.M. & Begg, C.E., 2009. Database Systems: A Practical Approach to Design, Implementation and Management 5th ed., Addison Wesley.
3. Meyne, H. & Davis, S., 2002. Developing Web Applications with ASP.NET and C#, John Wiley & Sons.
4. Shah, N.D., 2001. Database Systems Using Oracle: A Simplified Guide to SQL and PL/SQL 1st ed., Prentice Hall.

Web resources:
SQL Quick Reference - http://www.w3schools.com/sql/sql_quickref.asp
ASP.NET Tutorial - http://www.w3schools.com/aspnet/default.asp
Oracle Library-  http://www.oracle.com/pls/db111/homepage