Dr Andrew Scott G7VAV

My photo
 
June 2018
Mo Tu We Th Fr Sa Su
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 8


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