Andrew's Page: Teaching

Dr Andrew Scott G7VAV

MBCS, MIET, Member ACM, Member IEEE

Senior Lecturer
School of Computing
and Communications

D35 InfoLab21
Lancaster University
Lancaster, LA1 4WA
United Kingdom

April 2024
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

CSc 243: Database Systems

This course aims to:

Give students a solid grounding in relational database theory and to highlight the practical issues in employing databases.
Expose students to the inner workings and file system structures used to support database functionality.
Examine the problems of concurrent user access.
Explore upcoming, state of the art database models.

Recommended Texts

Ramez Elmasri, Shamkant B. Navathe,
Fundamentals of Database Systems
Pearson Education, 13 April 2006, Paperback: 1168 pages
ISBN:032141506X

Thomas Connolly, Carolyn Begg,
Database Systems: A Practical Approach to Design, Implementation and Management
Addison Wesley, 24 May 2004, Paperback: 1236 pages
ISBN:0321210255

Akmal B. Chaudhri, Awais Rashid, Roberto Zicari,
XML Data Management: Native XML and XML-enabled Database Systems
Addison Wesley, 20 March 2003, Paperback: 688 pages
ISBN:0201844524

Akmal B. Chaudhri, Roberto Zicari,
Succeeding with Object Databases: A Practical Look at Today's Implementations with Java and XML
John Wiley & Sons, 30 October 2000, Hardcover: 464 pages
ISBN:0471383848

Michael Stonebroker,
Object-relational DBMSs: Tracking the Next Great Wave
Morgan Kaufmann, 12 August 1999, Paperback: 297 pages
ISBN:1558604529

Syllabus

Part I

History of databases and day to day application scenarios
Relational database systems
- Relational model and relation normalisation
- Relational algebra
- Structured Query Language (SQL)
- Entity-Relationship (ER) model
- Three schema architecture and relational schema definitions in SQL v
  Relational database access from Java
Physical data organisation and access
- Primary file organisation
- Secondary file organisation

Part II

Query optimisation
Transaction processing and concurrency control
Object-oriented database systems
- The ODMG standard
- Object database evolution
- Commercial object-oriented database systems
Object-relational database systems
The Java Data Objects standard
XML Data Management
XML-enabled database systems
Native XML database systems
Data Warehouses

JDBC

Installing and running MySQL and Connector/J

for client 3.15.10.137

http://www.andrew-scott.uk/

Andrew Scott

http://www.andrew-scott.co.uk/