Catalogue of Modules, University of Nottingham

G51DBS Database Systems
(Last Updated:03 May 2017)

Year  09/10

Total Credits: 10

Level: Level 1

Target Students:  First year or second year undergraduate students in the School of Computer Science according to the specific regulations of each course.  Available to JYA/Erasmus students.
  This Module has been identified as being particularly suitable for first year students, including those from other Schools.

Taught Semesters:

SemesterAssessment
Spring Assessed by end of Spring Semester 

Prerequisites: None.

Corequisites:  None.

Summary of Content:  The module introduces database management systems, and the design and use of databases systems. The relational database model and the structured database query language (SQL) are covered. Throughout the module students are given instruction in the use of a relational database management system.

Module Web Links:
   
  • Reading List
  • Method and Frequency of Class:

    ActivityNumber Of WeeksNumber of sessionsDuration of a session
    Lecture 12 weeks2 per week1 hour
    Computing 12 weeks1 per week2 hours

    Activities may take place every teaching week of the Semester or only in specified weeks. It is usually specified above if an activity only takes place in some weeks of a Semester

    Further Activity Details:
    Two lectures and one practical per week.

    Method of Assessment: 

    Assessment TypeWeightRequirements
    Exam 1 60 1 hr written examination 
    Coursework 1 40 One or more pieces of coursework, including practicals in writing SQL 

    Convenor: 
    Dr N Alechina

    Education Aims:  To provide students with a general introduction to the theory and practice of database systems. To enable students to gain experience with a modern database system through the use of the SQL query language. To give an understanding of the structure and workings of database systems. To provide some insight into recent developments in database systems.

    Learning Outcomes:  Knowledge and Understanding: Ability to use SQL and an understanding of embedded SQL. Understanding of the ANSI/SPARC and relational models of database systems. Intellectual Skills: Basic knowledge of the mathematics underlying relational database systems. Ability to design database systems. Professional Skills: The use of SQL for database specification and manipulation. Database administration, including integrity and security control. Transferable Skills: Understanding of the application of database systems.

    Offering School:  Computer Science


    Use the Back facility of your browser to return to the previous page.

    Module Catalogue Search for another module

    [UoN Welcome Page] Return to The University of Nottingham Welcome Page