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

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.

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

1 lecture per week; 2 practicals per week (1:n)1; (1:20)2.

Students will have participated in an award induction workshop where they will learn how to use the Virtual Learning Environment (VLE) employed for the study of this module. Subsequently students will work through the module material provided on the VLE at a pace suggested within the VLE for the module. The material will include activities and review questions that allow students to assimilate the concepts and skills required by the module. Students will be encouraged to discuss relevant aspects within discussion forums that are part of the VLE. The forums will allow discussion with a student's peer group as well as the module tutor.

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.

None.