Material on Blackboard
Oracle
Staffordshire University has subscriptions to electronic book services such as Safari Tech Books, Ebrary and Netlibrary. There are titles in each of the collections that will support students studying Database Technology. Staffordshire University has subscriptions to IEEExplore, ACM Digital Library, Elsevier Science Direct and Infotrac Computer Database all offering full text electronic access to journals and conference proceedings.

None

Database Systems: A Practical Approach to Design, Implementation and Management, Connolly and Begg, Addison Wesley, 5th Edition, 16 April 2009, ISBN-10: 0321523067

Additional directed Online reading of papers from Oracle, Microsoft, User Group Meetings and Conferences, Journals, etc.

Research based element Assignment (1000 words) 30% assessing Learning outcome 1
Practical implementation element Coursework 70% assessing Learning outcome 2

Database technology fundamentals:
- Database concepts, Database theory
- Data modelling, Process modelling
- Components of a DBMS
- Concurrency/Optimisation
- Web database technologies
Data Manipulation
Database creation:
- Applying the physical design, Constructing and managing tables
- Creating views and sequences, Referential integrity, Triggers
Managing Tables:
- Data dictionary, Constraints, Indexes

The 12 hours contact time will be used for two main purposes. At the beginning it will be used to establish a broad overview of the module, give a detailed explanation of the modules assessments, and put in place the mechanisms to be used for gaining formative feedback, and for how to raise queries. The second usage of contact time will be related to education delivery itself. The time will mainly be divided between teaching main topics, key aspects and concepts, spending time reviewing student assignment progress in order that each student gets formative feedback, and provide the opportunity to get support with practical sessions in a face-to-face format.
The independent study hours will involve the student using the provided on-line material on Blackboard VLE. Such material will include lecture notes, practical exercises, weekly tasks, investigative case studies, problem based tasks, and self assessment questions to attempt.
Students will also be actively encouraged to discuss relevant aspects within discussion forums that are part of the VLE on a weekly basis. The forums will allow discussion with a student's peer group as well as the module tutor.