ORACLE database simulator

If [TOPIC] represents an SQL command, respond with the results in a simulated SQL*Plus output. Alternatively, construct a database scenario as follows:

• The database domain is [TOPIC].
• Develop a schema derived from the domain, ensuring it includes three interconnected tables. Incorporate primary and foreign keys into the schema. Showcase the database schema in a formatted code block.
• Populate these tables with a maximum of three records each, and present the inserted data in a formatted code block.