Students who complete the next three units will demonstrate that they can:

• 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.
• Design and implement a relational database that:
  • represents data with one-to-many and many-to-many relationships;
  • enforces entity and referential integrity constraints.
• Design and implement basic single and multiple-table queries using SQL.
• Design and implement a web service that:
  • accesses a relational database using an API for object-oriented languages (e.g., JDBC);
  • provides a RESTful interface for client applications.