Module Descriptors
WEB AND DATABASE TECHNOLOGIES
COIS40901
Key Facts
Digital, Technology, Innovation and Business
Level 4
30 credits
Contact
Leader: Robin Oldham
Email: Robin.Oldham@staffs.ac.uk
Hours of Study
Scheduled Learning and Teaching Activities: 96
Independent Study Hours: 204
Total Learning Hours: 300
Assessment
- Coursework with three weighted milestones 20, 70 & 10 weighted at 100%
Module Details
Module Indicative Content
The module will cover the following topics:
Interface Design
- Usability
- HCI
Web
- Standards
- Storyboarding and navigation maps
- HTML 5
- CSS
- Graphics
- Javascript
Databases
- Data Modelling - use of ERDs
- Validation of data
- DDL and SQL
Web Database connectivity
Interface Design
- Usability
- HCI
Web
- Standards
- Storyboarding and navigation maps
- HTML 5
- CSS
- Graphics
- Javascript
Databases
- Data Modelling - use of ERDs
- Validation of data
- DDL and SQL
Web Database connectivity
Module Special Admissions Requirements
None.
Module Resources
Access to suitable development environments, Modelling tools eg. QSEE Superlite
Web Page Editors such as Adobe Master Collection CS5, Microsoft Expression Studio
Database Management System such as Oracle, SQL Server
Web Page Editors such as Adobe Master Collection CS5, Microsoft Expression Studio
Database Management System such as Oracle, SQL Server
Module Texts
Introducing HTML5, New Riders, Lawson, B. Sharp, R. , 2011, ISBN-10: 0321784421, ISBN-13: 978-0321784421 (Edition: 2)
Prioritizing Web Usability, Nielsen, J., Loranger, H.,2006, New Riders, ISBN-10: 0321350316 | ISBN-13: 978-0321350312 (Edition: 1 )
Designing with Web Standards (Voices that Matter), Zeldman, J., 2009, New Riders, ISBN-10: 0321616952, ISBN-13: 978-0321616951 (Edition: 3)
HTML Dog: The Best-Practice Guide to XHTML and CSS, Griffiths. P. 2006, New Riders, ISBN-10: 0321311396, ISBN-13: 978-0321311399 (Edition: 1)
CSS: The Missing Manual (Missing Manuals), Sawyer McFarland, D. ,2009, Pogue Press / O'Reilly, ISBN-10: 0596802447, ISBN-13: 978-0596802448, (Edition: 2)
Designing Effective Database Systems (Available as e-book in University library), Riordan, R.M., 2005, Addison-Wesley Professional, ISBN-10: 0321290933 , ISBN-13: 978-0321290939 (Edition: 1)
An Introduction to Database with Web Applications, Prigmore,M., Prentice Hall, 2008, ISBN: 978-0-321-26359-9
Prioritizing Web Usability, Nielsen, J., Loranger, H.,2006, New Riders, ISBN-10: 0321350316 | ISBN-13: 978-0321350312 (Edition: 1 )
Designing with Web Standards (Voices that Matter), Zeldman, J., 2009, New Riders, ISBN-10: 0321616952, ISBN-13: 978-0321616951 (Edition: 3)
HTML Dog: The Best-Practice Guide to XHTML and CSS, Griffiths. P. 2006, New Riders, ISBN-10: 0321311396, ISBN-13: 978-0321311399 (Edition: 1)
CSS: The Missing Manual (Missing Manuals), Sawyer McFarland, D. ,2009, Pogue Press / O'Reilly, ISBN-10: 0596802447, ISBN-13: 978-0596802448, (Edition: 2)
Designing Effective Database Systems (Available as e-book in University library), Riordan, R.M., 2005, Addison-Wesley Professional, ISBN-10: 0321290933 , ISBN-13: 978-0321290939 (Edition: 1)
An Introduction to Database with Web Applications, Prigmore,M., Prentice Hall, 2008, ISBN: 978-0-321-26359-9
Module Additional Assessment details
A COURSWORK ASSESSMENT weighted at 100%
Milestone 1 weighted at 20% covering learning outcome 2, comprising
- Interface design documentation
- A set of linked web pages demonstrating application of usability concepts and technical skills
Milestone 2 weighted at 70% covering learning outcomes 1, 3, 4 comprising
- An Entity Relationship Diagram
- A working database which corresponds to the design.
- A report containing a requested query statements and their output.
- A web form which enables rows to be inserted, updated and deleted from the database.
Milestone 3 weighted at 10% covering all learning outcomes
-A report (circa 600 words) evaluating the project as a whole
Milestone 1 weighted at 20% covering learning outcome 2, comprising
- Interface design documentation
- A set of linked web pages demonstrating application of usability concepts and technical skills
Milestone 2 weighted at 70% covering learning outcomes 1, 3, 4 comprising
- An Entity Relationship Diagram
- A working database which corresponds to the design.
- A report containing a requested query statements and their output.
- A web form which enables rows to be inserted, updated and deleted from the database.
Milestone 3 weighted at 10% covering all learning outcomes
-A report (circa 600 words) evaluating the project as a whole
Module Learning Outcomes
1. DEVELOP KNOWLEDGE AND UNDERSTANDING OF THE UNDERLYING FACTS, CONCEPTS, PRINCIPLES AND THEORIES RELATING TO WEB DEVELOPMENT AND DATABASE TECHNOLOGIES.
Knowledge & Understanding
2. DEVELOP KNOWLEDGE AND UNDERSTANDING OF THE UNDERLYING FACTS, CONCEPTS, PRINCIPLES AND THEORIES RELATING TO THE DESIGN OF USER INTERFACES AND USABILITY.
Communication
Knowledge & Understanding
3. DEMONSTRATE THE PRACTICAL SKILLS REQUIRED FOR THE CREATION OF A WEB APPLICATION WITH DATABASE CONNECTIVITY.
Application
4. UNDERSTAND THE BENEFITS AND ISSUES AROUND WEB DATABASE CONNECTIVITY.
Learning
Knowledge & Understanding
2. DEVELOP KNOWLEDGE AND UNDERSTANDING OF THE UNDERLYING FACTS, CONCEPTS, PRINCIPLES AND THEORIES RELATING TO THE DESIGN OF USER INTERFACES AND USABILITY.
Communication
Knowledge & Understanding
3. DEMONSTRATE THE PRACTICAL SKILLS REQUIRED FOR THE CREATION OF A WEB APPLICATION WITH DATABASE CONNECTIVITY.
Application
4. UNDERSTAND THE BENEFITS AND ISSUES AROUND WEB DATABASE CONNECTIVITY.
Learning
Module Learning Strategies
The contact time will be broken down as follows: 52 hours of lectures, 52 hours of tutorials Lectures will be used to deliver technical knowledge and academic concepts Tutorials will be used to develop practical skills