Programme/Approved Electives for 2023/24
Available as a Free Standing Elective
Successful completion of CSC-10029 Fundamentals of Computing or equivalent, and CSC-10024 Programming I or equivalent.
This module introduces students to databases and database management systems by providing theoretical knowledge and practical experience in data modelling, database design, implementation and administration. The module develops the following Keele Graduate attributes:2. An appreciation of the development and value of your chosen subjects of study, awareness of their contexts, the links between them, and awareness of the provisional and dynamic nature of knowledge.3. Information literacy: the ability to locate, evaluate and synthesise large amounts of frequently conflicting information, ideas and data.4. The ability creatively to solve problems using a range of different approaches and techniques, and to determine which techniques are appropriate for the issue at hand.6. The ability to communicate clearly and effectively in written and verbal forms for different purposes and to a variety of audiences.7. The knowledge, skills, self-confidence and self-awareness actively to pursue your future goals.
To introduce students to databases and database management systems by providing theoretical knowledge and practical experience in data modelling, database design, implementation and administration.
Intended Learning Outcomes
describe and advise upon the benefits and characteristics of database models and database management systems (DBMS) and the importance of data independence, and comment upon the level of data independence offered by a particular DBMS: 2determine whether a given relational database is well designed (ie. meets BCNF criteria) and transform a schema into BCNF: 2create and query a relational database using command level SQL: 1describe and advise upon the important aspects of a database implementation, operation and maintenance (including storage structures, recovery, concurrency and security mechanisms): 1,2use data modelling techniques for the design of databases: 1,2design and build a small database system with a web interface: 1show awareness and knowledge of other types of database interfaces: 2identify the important characteristics of the relational model for the purposes of developing relational databases: 1,2
20 hours lectures 20 hours practical work (labs)5 hours tutorials/workshops103 hours Independent study/coursework2 hour Examination
1: Coursework weighted 40%
Description of Module Assessment
Practical assessment of database developmentDesign and implementation of a small database.2: Open Book Examination weighted 60%
Online open-book examThe exam will cover all topics addressed in the lectures. This exam will have short-answer questions focusing on theoretical as well as problem-solving skills learned in the module. The exam will have three questions and candidates are asked to attempt all three questions. The paper will be released on the KLE as a Word document on the morning of the Exam and should be completed within 24 hours. Students should answer each question using Word, clearly labelling each question as they provide their answers. Answers should be as accurate and concise as possible.
Although students have been given a significant amount of time to complete this exam paper, we expect most students to complete the exam in about 2 hours. International students will be asked to notify the School if they need an extension due to different time zones.