Define a relational schema to capture the above information. The schema should include table definitions, attribute definitions, and attribute data types. Create tables in SQL for the above schema.