Table of contents

Key team contact details 3

2 Assessment and feedback 6

2.1 Summative assessment grid 6

3 Things you need to know 9

3.1 Attendance 9

Key team contact details

This module is shared across all courses within the Computing subject area.

The names and email details of all respective Course Leader(s) overseeing this module are:

Module overview

Introduction, aims and summary of content

The module aims to provide students with the knowledge and skills to model, design and build a small relational database system using Oracle. It also introduces students to systems theory and its application to information systems used within business organisations.

Key aims are:

• Develop sound group working skills

Outline of topics.

• SQL for database definition and manipulation

• Transaction processing and concurrency issues

Please refer to Blackboard for detailed information on each of the weekly learning sessions.

https://online.uwl.ac.uk

Learning outcomes to be assessed

Scheduled contact hours

Assessment and feedback

Summative assessment grid

Assessment brief including criteria mapped to learning outcomes

Assessment 1

Assessent criteria:

1. User requirements: Identify four stakeholders and, identify at least 12 functional requirements that your database system should be able to meet (3 requirements per group member). As the case study contains only an outline of a business scenario, you will also need to state any business rules, assumptions, etc., that your group has made in the course of putting together the database design. These need to be submitted with your design.

2. An ER diagram covering the data requirements of the scenario, together with a completed entity specification form for each entity shown on your ER diagram. The specification form can be found on Blackboard.

Group work is successful when group members are communicating effectively. Each group needs to publish the day/time of their one hour weekly face to face meeting on Blackboard. All interactions and interim work needs to be recorded on the Blackboard ‘group’ facilities which have been set up for each group.

Individual group members must submit (via Blackboard)

Assessment criteria:

This assessment requires your group to implement the database design produced in the assessment 1 (amended appropriately following feedback provided by your tutor). This must be implemented using Oracle sqlDeveloper and a script file produced to allow your tutor to set up (and remove) your complete database implementation.

What your group needs to submit:

c. SQL view creation scripts for two views that would benefit this application (the script should be annotated to explain the rationale for this view).

d. SQL scripts for between 12 SQL queries/reports/triggers (ie 3 per group member) that meet some significant user requirements (as outlined in Assignment 1 Part B) and demonstrate the functionality of the system. Each query script should be annotated to explain the rationale for the query (what it shows, who would use it and why). Your choice of queries should illustrate the breadth and potential of the implemented database, as well as a good understanding of SQL. Higher marks will be awarded for more complex queries or triggers, providing these satisfy valid requirements.

6. A completed Peer Assessment Form for each member of the group. Please note that failure by a group member to submit peer review forms will result in the deduction of 5 marks from that member’s overall mark.

Assignment marks for each group member may be moderated by your tutor based on evidence provided on Blackboard, seminar attendance, peer review forms and demonstration. Lack of evidence of attendance, or lack of collaboration by an individual will lead to a reduction of marks by the tutor, and in the most extreme cases, a fail grade for this part of the assignment.

Learning materials

The reading list for this module is available on Blackboard in the module area or by searching https://uwl.rl.talis.com/index.html. This shows real-time availability of books in the library and provides direct links to online resources, recommended by your lecturer.

Remember to log into Blackboard daily to receive all the latest news and support available at your module sites!

Things you need to know

Attendance

Attendance is crucial for this module, particularly at seminar sessions where you will be conducting a large part of your group work. It is also crucial for your success as a student overall. Over the years, it has become clear that there is a very clear link between students’ attendance levels and their module marks, so please make sure you give yourself the best possible chances for success through attending your classes, seminars and tutorials. You are expected to attend all forms of learning activity associated with your course of study regularly, and to engage in your course as required by the University’s Attendance and Engagement Monitoring Policy. Attendance is monitored using student card swipe data so please always remember to ‘touch-in’ with your ID card for each class you attend. This may also affect your scholarships, so don’t forget to tap in!

If things don’t go to plan

If an extension is not sufficient and your circumstances have prevented you from submitting on time then you may for instance be able to apply for mitigation. You are encouraged to seek advice from the Students’ Union Advice Service who can support you. Click the link and go to the ‘advice’ section: https://www.uwlsu.com/

Please refer to the University Academic Regulations for further guidance on extensions and mitigation: https://www.uwl.ac.uk/students/current-students/extensions-and-mitigating-circumstances

You are reminded that the University applies penalties to students who commit an academic offence, in which case the Academic Offences Regulations will be used to deal with any cases of academic misconduct including examination offences, plagiarism and other means of cheating to obtain an advantage.

If you have an issue or complaint about the module, you should speak to your Module Leader, Tutor or Course Leader informally in the first instance. Your Course Representative can also raise your concerns at Course Committees, which take place each semester. If you are unable to resolve it informally, you should refer to the Complaints Procedure which is outlined in the Student Handbook (https://www.uwl.ac.uk/students/current-students/student-handbook) and consult the Students’ Union about it. The University aims to ensure that issues are resolved informally as quickly as possible to have minimum impact on your studies.

Getting support for your studies

Student support

In addition to the support listed in the previous section, there is also more help offered by UWL Student Support Services. These are located in The Street at St. Mary’s Road, Ealing campus, but offer drop-in sessions at all UWL sites. They offer a wide range of support and advice services consisting of Student Advice, and Funding & Immigration advice; Careers; Counselling; Disability/Mental Health; Inter-faith Advisor; Placement & Employment; Volunteering; Student Welfare; and Scholarships and Bursaries.

Contact Student Services (general) for more information at:

Module evaluation – have your say!