IT1050 – Introduction to Database Systems

This subject is an introduction to database management. It first identifies the need for database systems in commerce, industry and government. Database design methodology using entity relationship diagrams is described. The relational model of database management is then explained. Importance of Functional dependencies and Normalisation is highlighted. Techniques for accessing a database using relational algebra and relational calculus are explained. Use of the language SQL for interacting with a database is discussed in detail. Storage for data in a database and improving access using indexing techniques using B-tree and hashing are covered. Query processing algorithms and query optimization are described. Transaction processing is discussed in detail including concepts like concurrency, recovery, and security. Importance of the need for a level of professionalism when designing and implementing database solutions.