Understand the roles of primary and foreign keys in relational databases and how they establish relationships.
Define primary keys and foreign keys in the context of relational databases. Explain their purpose and how they are used to establish relationships between tables. Provide a simple example using two tables, [table_name_1] and [table_name_2].
Generate a detailed relational database schema, including tables, columns, data types, and relationships, for a specified application.
Take an existing relational schema and normalize it to a specified normal form, explaining the steps.
Design a normalized relational database schema for a specified application type, including tables, columns, relationships, and data types.
