Run by School of Computer Science and Electronic Engineering
20.000 Credits or 10.000 ECTS Credits
Semester 1 & 2
Organiser: Mr Andy Harbach
Overall aims and purpose
To provide students with a practical understanding of database systems including the concept of a database, database management systems, and SQL.
To provide an in depth understanding of the database design process including conceptual, logical and physical design.
To be able to implement database systems, and consider issues such as security, transactions, and locking.
Indicative content includes:
- Fundamental database concepts; what is a database, tables, queries, etc.
- SQL as a language and its function within databases.
- Database design and normalisation; conceptual, logical and physical design concepts and techniques.
- Implementation of a database design.
- Security concerns, concepts, and mechanisms.
- Transactions and concurrency control.
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.
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.
Equivalent to the range 70%+. Assemble critically evaluated, relevent 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.
Describe the major characteristics of a relational database.
Create conceptual, logical and physical database designs.
Describe the concept and benefit of transactions in a database context.
Use SQL to query, create, and manipulate a database.
Create ER models for particular applications.
|Basic SQL Queries Lab||10.00|
|Conceptual Design Lab||10.00|
|Class test 1||20.00|
|Class test 2||20.00|
|Multi-table Queries Lab||10.00|
|Logical Design Lab||10.00|
|Physical Design lab||10.00|
Teaching and Learning Strategy
Formal lectures covering theory and demonstrating practical topics.
Interactive sessions covering writing SQL, case studies, and revision.
Practical sessions writing SQL and using appropriate modelling techniques to design a database system. Includes marking where students are expected to explain their work to a member of staff. Also includes class tests.
To include reading around the subject, revision, finishing lab work and completing assignments.
- Literacy - Proficiency in reading and writing through a variety of media
- Numeracy - Proficiency in using numbers at appropriate levels of accuracy
- Computer Literacy - Proficiency in using a varied range of computer software
- Self-Management - Able to work unsupervised in an efficient, punctual and structured manner. To examine the outcomes of tasks and events, and judge levels of quality and importance
- Exploring - Able to investigate, research and consider alternatives
- Information retrieval - Able to access different and multiple sources of information
- Critical analysis & Problem Solving - Able to deconstruct and analyse problems or complex situations. To find solutions to problems through analyses and exploration of all possibilities using appropriate methods, rescources and creativity.
Subject specific skills
- Solve problems logically and systematically;
- Access and synthesize information and literature sources;
- Demonstrate familiarity with relevant subject specific and general computer software packages.
- Knowledge and understanding of facts, concepts, principles & theories
- Use of such knowledge in modelling and design
- Problem solving strategies
- Analyse if/how a system meets current and future requirements
- Deploy theory in design, implementation and evaluation of systems
- Knowledge of information security issues
- Specify, design or construct computer-based systems
- Evaluate systems in terms of quality and trade-offs
- Methods, techniques and tools for information modelling, management and security
- Knowledge of systems architecture
- Specify, deploy, verify and maintain information systems
- System Design
- Knowledge and understanding of computational modelling
- Specify, deploy, verify and maintain computer-based systems
Talis Reading listhttp://readinglists.bangor.ac.uk/modules/ice-1601.html
Courses including this module
Compulsory in courses:
- N109: BSc Bus Analytics w Financial Tech year 1 (BSC/BAFT)
- N312: BSc Banking with Financial Tech year 1 (BSC/BKFT)
- I110: BSc Computer Information Systems year 1 (BSC/CIS)
- I11B: BSc Computer Information Systems (4 year with Incorp Found) year 1 (BSC/CIS1)
- IN00: BSc Computer Information Systems for Business year 1 (BSC/CISB)
- IN0B: BSc Computer Information Sys for Bus (4 year w Incorp Found) year 1 (BSC/CISB1)
- IN02: BSc Computer Information Systems for Business (Franchised) year 1 (BSC/CISBF)
- I111: BSc Computer Information Systems with International Exp year 1 (BSC/CISIE)
- I11P: BSc Computer Information Systems with Industrial Placement year 1 (BSC/CISP)
- G400: BSC Computer Science year 1 (BSC/CS)
- G40B: BSc Computer Science (4 year with Incorporated Foundation) year 1 (BSC/CS1)
- G40F: BSc Computer Science year 1 (BSC/CSF)
- I102: BSc Computer Science (with International Experience) year 1 (BSC/CSIE)
- G40P: BSc Computer Science with Industrial Placement year 1 (BSC/CSIP)
- H118: BSc Data Science & Artificial Intelligencetellig year 1 (BSC/DSAI)
- H113: BSc Data Science and Machine Learning year 1 (BSC/DSML)
- H114: BSc Data Science and Visualisation year 1 (BSC/DSV)
- H117: MComp Computer Science year 1 (MCOMP/CS)