Rhedir gan School of Computer Science and Electronic Engineering

20.000 Credyd neu 10.000 Credyd ECTS

Semester 1 a 2

Trefnydd: Mr Andy Harbach

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, locking, and transactions.

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; logical and physical design concepts and techniques.
• Implementation of a database design.
• Security concerns, concepts, and mechanisms.
• Transactions and concurrency control.

da

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.

ardderchog

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.

trothwy

Equivalent to 50%. 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.

1. Examine and describe the major characteristics of a relational database.

2. Understand and apply the conceptual, logical and physical database design methodologies including the different levels of normalising data.

3. Create ER models for particular applications.

4. Appraise the issues of executing multiple queries simultaneously, and how transactions solve them.

5. Use SQL to query, manipulate and secure a database.

Math	Enw	Disgrifiad	Pwysau
GWAITH CWRS	Basic SQL Queries Lab		10.00
GWAITH CWRS	Conceptual Design Lab		10.00
PRAWF DOSBARTH	Class test 1		20.00
PRAWF DOSBARTH	Class test 2		20.00
GWAITH CWRS	Multi-table Queries Lab		10.00
GWAITH CWRS	Implementation Lab		10.00
GWAITH CWRS	Logical Design Lab		10.00
GWAITH CWRS	Physical Design lab		10.00

		Oriau
Lecture	Formal lectures covering theory and demonstrating practical topics.	22
Tutorial	Interactive sessions covering writing SQL, case studies, and revision.	20
Laboratory	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.	38
Private study	To include reading around the subject, revision, finishing lab work and completing assignments.	120

• Llythrennedd - Medrusrwydd mewn darllen ac ysgrifennu drwy amrywiaeth o gyfryngau
• Rhifedd - Medrusrwydd wrth ddefnyddio rhifau ar lefelau priodol o gywirdeb
• Defnyddio cyfrifiaduron - Medrusrwydd wrth ddefnyddio ystod o feddalwedd cyfrifiadurol
• Hunanreolaeth - Gallu gweithio mewn ffordd effeithlon, prydlon a threfnus. Gallu edrych ar ganlyniadau tasgau a digwyddiadau, a barnu lefelau o ansawdd a phwysigrwydd
• Archwilio - Gallu ymchwilio ac ystyried dewisiadau eraill
• Adalw gwybodaeth - Gallu mynd at wahanol ac amrywiol ffynonellau gwybodaeth
• Dadansoddi Beirniadol & Datrys Problem - Gallu dadelfennu a dadansoddi problemau neu sefyllfaoedd cymhleth. Gallu canfod atebion i broblemau drwy ddadansoddiadau ac archwilio posibiliadau

• 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

Gorfodol mewn cyrsiau:

• N2BC: MBA Information Management (with Incorporated Pre-Masters) year 1 (MBA/INFM1)
• N2BG: MBA Information Management (January start) year 1 (MBA/INFMANJ)
• N2AS: MBA Information Management year 1 (MBA/INFOMAN)

Opsiynol mewn cyrsiau:

• G5BC: MSc Computing for Data Science year 1 (MSC/CDS)
• G5BA: MSc Computing year 1 (MSC/COMP)