Information Management (INFE312)
Database systems; components of database systems, DBMS functions, database architecture and data independence, hypertext, hypermedia and multimedia. Data modeling. Entity-relationship model. Object-oriented model. Relational data model. Entity and referential integrity. Relational algebra and relational calculus. Relational database design. Functional dependency and normal forms. Transaction processing. Distributed databases. Physical database design; storage and file structures, indexed files, hashed files, B-trees, files with dense index, files with variable length records.