Introduction to Databases

Description

After completing this course, the student should be able to: describe and explain the basic principles of databases; construct  a conceptual data model; describe the relational implementation model and convert a conceptual scheme to an implementation scheme; build a (relational) database; work with relational query languages, in particular SQL and relational algebra; understand and apply the principles of correct database design, including functional dependencies and normalization; explain and use techniques for efficient data retrieval; characterize and use principles of query processing and query optimization; know database management components such as transactions and recovery techniques and be able to explain their functionality.