Dr Andrew Scott G7VAV

My photo
 
June 2019
Mo Tu We Th Fr Sa Su
27 28 29 30 31 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


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 54.209.227.199: 52420
© Andrew Scott 2006 - 2019,
All Rights Reserved
http://www.andrew-scott.uk/
http://www.andrew-scott.co.uk/
http://www.andrew-scott.eu/