An introduction to the concepts and techniques encountered in database systems. To understand the theoretical background underlying the relational data model. To be able to apply theoretical results to the design and implementation of a database. Design an appropriate database structure to solve a given problem.
Write programs implement a given database design.
Define the components of a database. Compare and contrast a database system and a file system. Explain the types of file structures often used behind the scenes to implement a database. Define the terms encountered in relational database theory. Illustrate and describe the relational table operations that are used to manipulate tables.