1 / 8

Databases 2

Databases 2. Level 3, 10 credit module Prerequisite: 06-19321 Software System Components 2 (or some other introductory course in databases) 2 lectures & 1 exercise class / week Weekly exercise sheets [unassessed; but IF YOU DO THEM you receive feedback on these]. Focus of the module:

emmanuel-parsons
Download Presentation

Databases 2

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Databases 2 • Level 3, 10 credit module • Prerequisite: 06-19321 Software System Components 2 (or some other introductory course in databases) • 2 lectures & 1 exercise class / week • Weekly exercise sheets [unassessed; but IF YOU DO THEM you receive feedback on these]

  2. Focus of the module: • We use the public-domain PostgreSQL system • Not a training programme in a particular database management system • Focus on giving an intro to fundamental aspects of database theory & practice

  3. What is covered 1. Querying a relational database with SQL 2. Modelling a real-world situation with (extended) entity-relationship diagrams * ER modelling * Extended ER diagrams * Translating EER diagrams to tables (SQL CREATE statements)

  4. What is covered (cont'd) 3. Logical analysis of database designs * Relational algebra * Functional dependencies * Normalisation

  5. What is covered (cont'd) 4. Relational Database Management System (RDBMS) implementation technology * File organisation and retrieval * Indexes * Algorithms for relational operators * Query Execution * Query Optimisation * Transactions

  6. Possibly more... * XML * Query optimisation * Multimedia databases

  7. Assessment • 20% continuous assessment • 3 in-class assessed tests, 50 mins each • Announced ~1week in advance • Marks made available via the web • 80% written exam in May • Undergrads (BA, Bsc, BEng or MEng) can NOT resit the exam • Msc have one resit opportunity

  8. What is expected of you • Regular attendance at lectures • Coming prepared (with notes) for the exercise class so you can complete a large fraction of exercise in the class • Collecting feedback promptly & reviewing any mistakes you might have made • Approaching me in office hours to clear up any questions promptly • Have fun in learning!

More Related