This page displays the selected Module Descriptor.
Printer friendly version
Session: 2022/23
Last modified: 21/07/2022 16:35:36
|
Title of Module: Database Design |
|---|
|
Code: COMP11007 |
SCQF Level: 11
(Scottish Credit and Qualifications Framework) |
Credit Points: 20 |
ECTS: 10
(European Credit Transfer Scheme) |
|---|
| School: | School of Computing, Engineering and Physical Sciences |
|---|
| Module Co-ordinator: | Junkang
Feng |
|---|
| Summary of Module |
|---|
The module begins with the notion of the database approach to data management against the background of structured and unstructured data and the phenomena dubbed ‘data universe explosion’. Then the life cycle of database development is outlined.
Database conceptual design using the entity-relationship (ER) data model is examined in a great detail. The relational data model and the theory that support its definition and manipulation are then explained. The most popular technology for managing structured data is the relational database management system (RDBMS). Common functionalities and utilities of RDBMS are looked at through laboratory practicals. Furthermore, the process of mapping a conceptual design in ER to a relational schema is covered in detail. To create a relational database that is free from certain types of operational anomalies, the concept of normalisation and the most commonly used normal forms for relational databases are discussed and practised on. Issues in physical design when implementing a relational database are then examined. The industry standard query language for relational databases is the Structured Query Language (SQL), which is covered in detail.
Therefore through this module the student will learn knowledge of solid theoretical foundations and gain practical skills for the design and implementation of relational databases.
During the course of this module students will develop their UWS Graduate Attributes (https://www.uws.ac.uk/current-students/your-graduate-attributes/). Universal: Academic attributes - critical thinking and analytical & inquiring mind; Work-Ready: Academic attributes - knowledge and skills for Database Design; Successful: autonomous, driven and resilient.
|
| Module Delivery Method |
|---|
| Face-To-Face | Blended | Fully Online | HybridC | HybridO | Work-based Learning |
| |  | | | |
Face-To-Face
Term used to describe the traditional classroom environment where the students and the lecturer meet synchronously in the same room for the whole provision.
Blended
A mode of delivery of a module or a programme that involves online and face-to-face delivery of learning, teaching and assessment activities, student support and feedback. A programme may be considered “blended” if it includes a combination of face-to-face, online and blended modules. If an online programme has any compulsory face-to-face and campus elements it must be described as blended with clearly articulated delivery information to manage student expectations
Fully Online
Instruction that is solely delivered by web-based or internet-based technologies. This term is used to describe the previously used terms distance learning and e learning.
HybridC
Online with mandatory face-to-face learning on Campus
HybridO
Online with optional face-to-face learning on Campus
Work-based Learning
Learning activities where the main location for the learning experience is in the workplace.
|
| Term(s) for Module Delivery |
|---|
|
(Provided viable student numbers permit).
|
| Term 1 | | Term 2 | | Term 3 | |
[Top of Page]
| Learning Outcomes: (maximum of 5 statements) |
|---|
On successful completion of this module the student will be able to:
L1.
Demonstrate good understanding of the database approach to data management;
L2.
Demonstrate an extensive understanding of data modeling concepts and methodologies for relational database design;
L3.
Demonstrate the ability to design and implement relational database systems;
L4.
Use SQL to define and manipulate data stored in a relational database. |
| Employability Skills and Personal Development Planning (PDP) Skills |
|---|
| SCQF Headings |
During completion of this module, there will be an opportunity to achieve
core skills in:
|
|---|
| Knowledge and Understanding (K and U) |
SCQF Level 11.
Critical understanding of the concepts of the Relational model and the theory that supports it.
Extensive, detailed knowledge and understanding of the concepts of the Entity-Relationship model and the database design process. |
| Practice: Applied Knowledge and Understanding |
SCQF Level 11.
Critically analyzing a database data requirements and using database design techniques to design and implement a relational database.
Using SQL to retrieve, interpret and manipulate data in a relational database. |
| Generic Cognitive skills |
SCQF Level 11.
Bringing together information from a variety of sources;
Dealing with complex design, implementation and data manipulation issues and make informed judgment. |
| Autonomy, Accountability and Working with others |
SCQF Level 11.
Working with others in groups or teams and demonstrate leadership where appropriate;
Systematically practice in ways that addresses their own learning needs and reflects on own and others’ roles and responsibilities. |
| Pre-requisites: |
Before undertaking this module the student should have
undertaken the following:
|
|---|
Module Code:
| Module Title:
|
| Other: | |
| Co-requisites | Module Code:
| Module Title:
|
|---|
* Indicates that module descriptor is not published.
[Top of Page]
| Learning and Teaching |
|---|
Lectures will be used for exposition of topics, provide context and suggest appropriate background material. Lab sessions will provide practical experience in selected topics, and tutorials will provide time for working on exercises, and discussing directed further reading and feedback on the student’ perspective on the topics.
Independent study hours consists of two parts: Coursework (42 hours) and self study (120 hours) |
Learning Activities
During completion of this module, the learning activities undertaken to
achieve the module learning outcomes are stated below:
| Student Learning Hours
(Normally totalling 200 hours):
(Note: Learning hours include both contact hours and hours spent on other learning activities) |
| Lecture/Core Content Delivery | 20 |
| Tutorial/Synchronous Support Activity | 8 |
| Laboratory/Practical Demonstration/Workshop | 20 |
| Independent Study | 152 |
| 200
Hours Total
|
|
**Indicative Resources: (eg. Core text, journals, internet
access)
|
|---|
The following materials form essential underpinning for the module content
and ultimately for the learning outcomes:
Lecture Notes and lab sheets;
‘Database Systems’, 6th ed., Connolly T.M., and Begg C.E., Addison Wesley, 2015.
‘Modern Database Management’, 11th Edition Jeffrey A. Hoffer, Mary B. Prescott,
Fred R. McFadden, 2013.
‘Fundamentals of Database Systems’, 5th Ed., Elmasri R., and Navathe S.B., Benjamin Cummings, 2007.
‘An Introduction to Database Systems’, Date, C.J., Addison Wesley, 2003.
Hardware and Software: PC, MS Access 2013/2016.
|
|
(**N.B. Although reading lists should include current publications,
students are advised (particularly for material marked with an asterisk*) to
wait until the start of session for confirmation of the most up-to-date
material)
|
| Engagement Requirements |
|---|
In line with the Academic Engagement Procedure, Students are defined as academically engaged if they are regularly engaged with timetabled teaching sessions, course-related learning resources including those in the Library and on the relevant learning platform, and complete assessments and submit these on time. Please refer to the Academic Engagement Procedure at the following link: Academic engagement procedure |
[Top of Page]
Supplemental Information
| Programme Board | Computing |
|---|
| Assessment Results (Pass/Fail) |
No
|
|---|
| Subject Panel | Business & Applied Computing |
|---|
| Moderator | Carolyn Begg |
|---|
| External Examiner | C Luo |
|---|
| Accreditation Details | Not applicable |
|---|
| Version Number | 2.13 |
|---|
[Top of Page]
| Assessment: (also refer to Assessment Outcomes Grids below) |
|---|
| coursework assignment worth 60% of the final mark (Two assessments worth 20% and 40% respectively) |
| Two Class tests worth 15% and 25% respectively of the final mark |
(N.B. (i) Assessment Outcomes Grids for the module
(one for each component) can be found below which clearly demonstrate how the learning outcomes of the module
will be assessed.
(ii) An indicative schedule listing approximate times
within the academic calendar when assessment is likely to feature will be
provided within the Student Handbook.)
|
Assessment Outcome Grids (Footnote A.)
Footnotes
A. Referred to within Assessment Section above
B. Identified in the Learning Outcome Section above
[Top of Page]
Note(s):
- More than one assessment method can be used to assess individual learning outcomes.
-
Schools are responsible for determining student contact hours. Please refer to University Policy on contact hours (extract contained within section 10 of the Module Descriptor guidance note).
This will normally be variable across Schools, dependent on Programmes &/or Professional requirements.
|
| Equality and Diversity |
|---|
This module is appropriate for any student. Any special needs will be catered for and coordinated by the School and the School’s Enabling Support Co-coordinators.
UWS Equality and Diversity Policy |
|
(N.B. Every effort
will be made by the University to accommodate any equality and diversity issues
brought to the attention of the School)
|