CBDB4103 Intermediate Database: Oracle Database Management Assignment

This assignment solution details the creation and management of an Oracle database for a food delivery system. It begins by establishing a workspace in Oracle Apex and creating a database named 'Order Information'. The solution then outlines the creation of four tables: CUSTOMER, RESTAURANT, FOOD, and ORDERS, each with specific attributes and constraints, including primary and foreign keys to ensure data integrity. Data population for each table is provided, populating the tables with sample customer, restaurant, food, and order information. The solution provides SQL statements for various data retrieval and manipulation tasks, including selecting data based on specific criteria, joining tables, updating data, and creating an additional column. Finally, the assignment references the creation of an Oracle Form and includes a bibliography of relevant resources. The assignment demonstrates practical application of database design principles and SQL querying techniques within an Oracle environment.