Students who complete this unit will demonstrate that they can:

• Describe the most common designs for core database system components including the query optimizer, query executor, storage manager, access methods, and transaction processor.
• Describe the components of a database system and give examples of their use.
• Identify major DBMS functions and describe their role in a database system.
• Explain the concept of data independence and its importance in a database system.
• Explain and demonstrate the concepts of entity integrity constraint and referential integrity constraint (including definition of the concept of a foreign key).
• Create a relational database schema in SQL that incorporates key, entity integrity, and referential integrity constraints.
• Explain uses of declarative queries.
• Use a declarative query language to elicit information from a database.
• Define the fundamental terminology used in the relational data model.
• Describe the basic principles of the relational data model.
• Apply the modeling concepts and notation of the relational data model.