COMP518

Database and Information Systems

Aims

To provide a deep, systematic and critical understanding of the nature of information systems and particularly database systems, including web technology for databases.

Syllabus

  1. DB and DBMS: Access and Oracle (1 lecture)

  2. The relational model and relational algebra (2 lectures)

  3. Database analysis and design techniques: ER models (6 lectures)
    1. Conceptual design Entity Relationship models (2 lectures)
    2. Logical design (2 lectures)
    3. Normal forms (2 lecture)
  4. Transaction management (5 lectures)
    1. Transactions (2 lectures)
    2. Serializability, Atomicity (1 lecture)
    3. Concurrency control, Locking (2 lectures)
  5. SQL and its dialects (5 lectures)

  6. Database connectivity (1 lectures)
    1. The JDBC environment
  7. Web Technologies and DBMSs (2 lectures)

Recommended Texts

Connolly and Begg, Database Systems.

Silberschatz, Korth and Sudarshan, Database Systems Concepts 

Tahaghoghi, Learning Mysql

Nixon, Learning PHP,Mysql and Javascript



Learning Outcomes

  1. At the end of the module students should have a critical understanding of the nature of relational databases.
  2. At the end of the module students should be able to design and implement large-scale database systems.
  3. At the end of the module students should develop a basic understanding of web technologies applied to databases and database connectivity.

Learning Strategy

Formal Lectures: Students will be expected to attend two hours of formal lectures in a typical week plus two hours of supervised tutorial. Much of the material will be presented in the form of "do-it-yourself" work sheets.

Private study: In a typical week students will be expected to devote six hours of unsupervised time to private study. The time allowed per week for private study will typically include three hours of time for reflection and consideration of lecture material and background reading, and three hours for completion of "do-it-yourself" worksheets and practical exercises.