TEC2331

Principles of database systems

(ENG)

R Simpson

4 points + 26 lecture hours and 13 laboratory hours + First semester + Caulfield

Synopsis: Information management. Structured and non-structured information. The composite office document. Serial storage media. Extracting, sorting, merging, updating data. Randomly addressable storage. Random and relative file organisation. Key transforms. File space allocation. Disc directories. Indexing techniques. Indexed files. Inverted files. Logical data structures; trees, networks, lists, rings. Physical implementations. The database models. Theory and practice of relational database management systems. Text storage. Retrieval strategies. Strategies for archiving information.

Assessment: Examination (2 hours): 50% + Practical work: 50%