Skip to main content
Home

Information for:

  • Alumni
  • Applicants
  • Current Students
  • Staff
  • Parents
  • Job Vacancies
  • Covid-19
  • Cymraeg
My country:

Main Menu

    • Study Options
      • Study Home
      • Why Study at Bangor?
      • Undergraduate Study
      • Postgraduate Taught Study
      • Postgraduate Research
      • Executive Education
      • Part-time Courses
      • January Start Courses
      • Degree Apprenticeships
      • Study Abroad
      • Work Experience
    • Study Advice
      • Apply
      • Already Applied?
      • Fees and Finances
      • Scholarships and Bursaries
      • Get Ready for University
      • Widening Access
    • Explore Bangor
      • Open Days and Visits
      • Virtual Student Experience
      • Magical Bangor

    Find a Course

    Order a Course Guide

    Open Days

    Clearing

    • Student Life
      • Student Life Home
      • Bangor and the Area
      • Social Life and Entertainment
      • Student Accommodation
      • Clubs and Societies
      • Sport
      • Virtual Student Experience
      • Videos and Vlogs
    • Your Experience at Bangor
      • Student Support
      • Skills and Employability
      • Study or Work Abroad
      • Fees and Finances

    Student Profiles

    Student Videos and Vlogs

    Welcome 2022

    • Choose Bangor
      • International Home
      • Why Bangor?
      • Location
      • Accommodation
      • Student Support
      • Contact Us
      • Bangor University's China website
    • Apply
      • Entry Requirements
      • Tuition Fees and Scholarships
      • How to Apply
      • Already Applied
      • Study Abroad
      • Exchanges
      • Worldwide Partners

    Country Specific Information

    Bangor University International College

    Find a Course

    Clearing 2023

    • Research
      • Research Home
      • About Our Research
      • Research in our Academic Schools
      • Research Institutes and Centres
      • Research Portal
      • Integrated Research and Impact Support (IRIS) Service
      • Energy
      • REF 2021
      • Research News
    • Postgraduate Research Opportunities
      • Postgraduate Research
      • Doctoral School
    • Events and Training Opportunities
      • Researcher Development
    • The University
      • About Us
      • Our Mission
      • Strategy 2030
      • Annual Report & Financial Statements
      • Our Location
      • Academic Schools and Colleges
      • Services and Facilities
      • Vice-Chancellor's Office
      • Working with Business
      • Working with the Community
      • Sustainability
      • Health and Wellbeing
      • Contact Us
    • Working for Us
      • Job Vacancies
    • University Management and Governance
      • Policies and Procedures
      • Slavery and Human Trafficking Statement
      • Management and Governance
    • University and the Community
      • Pontio
      • Sports Facilities
      • Conference Facilities
      • Places to Eat and Drink
      • Public Events
      • Widening Access
      • Services to Schools
    • Business Services
      • Business Services Home
    • Collaboration Hub
      • Collaboration Hub
    • Conferencing and Business Dining
      • Conferencing Facilities
      • Business Dining
    • Intellectual Property (IP) and Commercialisation
      • Intellectual Property (IP) and Commercialisation
    • News
      • Current News
      • Research News
      • Student News
    • Events
      • Events
    • Announcements
      • Flag Announcements
  • Open Days

    • Study Options
      • Study Home
      • Why Study at Bangor?
      • Undergraduate Study
      • Postgraduate Taught Study
      • Postgraduate Research
      • Executive Education
      • Part-time Courses
      • January Start Courses
      • Degree Apprenticeships
      • Study Abroad
      • Work Experience
    • Study Advice
      • Apply
      • Already Applied?
      • Fees and Finances
      • Scholarships and Bursaries
      • Get Ready for University
      • Widening Access
    • Explore Bangor
      • Open Days and Visits
      • Virtual Student Experience
      • Magical Bangor

    Find a Course

    Order a Course Guide

    Open Days

    Clearing

    • Student Life
      • Student Life Home
      • Bangor and the Area
      • Social Life and Entertainment
      • Student Accommodation
      • Clubs and Societies
      • Sport
      • Virtual Student Experience
      • Videos and Vlogs
    • Your Experience at Bangor
      • Student Support
      • Skills and Employability
      • Study or Work Abroad
      • Fees and Finances

    Student Profiles

    Student Videos and Vlogs

    Welcome 2022

    • Choose Bangor
      • International Home
      • Why Bangor?
      • Location
      • Accommodation
      • Student Support
      • Contact Us
      • Bangor University's China website
    • Apply
      • Entry Requirements
      • Tuition Fees and Scholarships
      • How to Apply
      • Already Applied
      • Study Abroad
      • Exchanges
      • Worldwide Partners

    Country Specific Information

    Bangor University International College

    Find a Course

    Clearing 2023

    • Research
      • Research Home
      • About Our Research
      • Research in our Academic Schools
      • Research Institutes and Centres
      • Research Portal
      • Integrated Research and Impact Support (IRIS) Service
      • Energy
      • REF 2021
      • Research News
    • Postgraduate Research Opportunities
      • Postgraduate Research
      • Doctoral School
    • Events and Training Opportunities
      • Researcher Development
    • The University
      • About Us
      • Our Mission
      • Strategy 2030
      • Annual Report & Financial Statements
      • Our Location
      • Academic Schools and Colleges
      • Services and Facilities
      • Vice-Chancellor's Office
      • Working with Business
      • Working with the Community
      • Sustainability
      • Health and Wellbeing
      • Contact Us
    • Working for Us
      • Job Vacancies
    • University Management and Governance
      • Policies and Procedures
      • Slavery and Human Trafficking Statement
      • Management and Governance
    • University and the Community
      • Pontio
      • Sports Facilities
      • Conference Facilities
      • Places to Eat and Drink
      • Public Events
      • Widening Access
      • Services to Schools
    • Business Services
      • Business Services Home
    • Collaboration Hub
      • Collaboration Hub
    • Conferencing and Business Dining
      • Conferencing Facilities
      • Business Dining
    • Intellectual Property (IP) and Commercialisation
      • Intellectual Property (IP) and Commercialisation
    • News
      • Current News
      • Research News
      • Student News
    • Events
      • Events
    • Announcements
      • Flag Announcements
  • Open Days

Information for:

  • Alumni
  • Applicants
  • Current Students
  • Staff
  • Parents
  • Job Vacancies
  • Covid-19
My country:

Search

Close

Breadcrumb

  • Cymraeg

Share this page:
  • Twitter
  • Facebook
  • LinkedIn

Apply Now

Find out how to apply

Open Days

More information

Order a Course Guide

Order Now

Request Information

Get in touch

Chat to our staff and students

Connect through Unibuddy

Module ICL-1004:
Database Design and Management

Database Design and Management (Cambria) 2024-25
ICL-1004
2024-25
School of Computer Science & Engineering
Module - Semester 1 & 2
20 credits
Module Organiser: Josh Davies
Overview

Indicative content includes:

● Fundamentals of database design – For example, Relationships between tables, Primary and Foreign Key, data integrity, fields, Data types(such as TEXT, DATE, NUMBER etc)

● Conceptual data modelling (Entity Relationship Model) – For example Logical relationships including One to one, one to many and Many to Many

● Relational design – functional dependency and normalisation (up to third normal form)

● Create a database structure using a suitable front end database. (Create tables, reports, forms and query the database)

● Create a database structure using SQL commands

● Develop SQL commands to maintain a database (CREATE, INSERT, UPDATE, ROLLBACK, COMMIT, JOIN, ALTER etc)

Assessment Strategy

-threshold -Equivalent to 40%.Uses key areas of theory or knowledge to meet the Learning Outcomes of the module. Is able to formulate an appropriate solution to accurately solve tasks and questions. Can identify individual aspects, but lacks an awareness of links between them and the wider contexts. Outputs can be understood, but lack structure and/or coherence.

-good -Equivalent to the range 60%-69%.Is able to analyse a task or problem to decide which aspects of theory and knowledge to apply. Solutions are of a workable quality, demonstrating understanding of underlying principles. Major themes can be linked appropriately but may not be able to extend this to individual aspects. Outputs are readily understood, with an appropriate structure but may lack sophistication.

-excellent -Equivalent to the range 70%+.Assemble critically evaluated, relevant areas of knowledge and theory to constuct professional-level solutions to tasks and questions presented. Is able to cross-link themes and aspects to draw considered conclusions. Presents outputs in a cohesive, accurate, and efficient manner.

Learning Outcomes

  • Analyse the data requirements of a system to a design and a relational model.

  • Build a database to satisfy the data requirements.

  • Demonstrate understanding of the principles of suitable query language.

  • Develop a design and a relational model for a given scenario.

Assessment method

Coursework

Assessment type

Summative

Description

Implement a Working Database in Access Implement a working database in Access using the designs from Assignment 1. An evaluation on your own performance towards the assignment. 30%, Guideline time to complete this assignment is approximately 21 hours.

Weighting

30%

Assessment method

Report

Assessment type

Summative

Description

The theory of Relational databases and normalisation, including examples. Design a database from a specified scenario. This will include the development of an Entity Relationship Model (ERD)

Weighting

40%

Assessment method

Coursework

Assessment type

Summative

Description

Laboratory exercise on the topic of SQL You will be given a laboratory exercise on the topic of SQL. The questions will be answered using SQL commands. These commands will include, table creation, insertion and querying.

Weighting

30%

Home

Study

  • Undergraduate Study
Home

Follow Us

  • Twitter
  • Facebook
  • Instagram
  • Youtube
  • LinkedIn

Bangor University

Bangor, Gwynedd, LL57 2DG, UK

+44 (0)1248 351151

Contact Us

Visit Us

Maps & Directions

Policy

  • Legal Compliance
  • Modern Slavery Act 2015 Statement
  • Accessibility Statement
  • Privacy and Cookies
  • Welsh Language Policy
Map

Bangor University is a Registered Charity: No. 1141565

© 2020 Bangor University