Dr Andrew Scott G7VAV
MBCS, MIET, Member ACM, Member IEEE
My photo
Senior Lecturer
School of Computing
    and Communications

D35 InfoLab21
Lancaster University
Lancaster, LA1 4WA
United Kingdom
 
April 2024
Mo Tu We Th Fr Sa Su
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 1 2 3 4 5
6 7 8 9 10 11 12
SCC 201: Database Systems
Recommended Texts
Elmasri and Navathe
Ramez Elmasri, Shamkant B. Navathe,
Fundamentals of Database Systems
Pearson Education, 13 April 2006, Paperback: 1168 pages
ISBN:032141506X
Connolly and Begg
Thomas Connolly, Carolyn Begg,
Database Systems: A Practical Approach to Design, Implementation and Management
Addison Wesley, 24 May 2004, Paperback: 1236 pages
ISBN:0321210255
Syllabus
Part I
  • Introduction
  • Relational Model
  • Relational Algebra
  • Schemas and Views
  • Structured Query Language (SQL)
  • JDBC
  • Normalisation
    • First Normal Form
    • Second Normal Form
    • Third Normal Form and BCNF
    • Higher normal forms
Part II
  • Files
  • Secondary Files
  • Search and B-Trees
  • Hashing
  • Access Routines
  • Query Processing and Optimisation
  • Concurrency and Transactions
  • Concurrency: locking
Pile of slides
SQLite
JDBC
Installing and running MySQL and Connector/J
for client 18.190.217.134
© Andrew Scott 2006 - 2024,
All Rights Reserved
http://www.andrew-scott.uk/
Andrew Scott
http://www.andrew-scott.co.uk/