Final answer:
The question involves creating an ER Diagram using Oracle Data Modeler, converting it to a Relational Model, adding attributes and data types, generating SQL code, and testing this code in an Oracle database server, with the process to be documented by screenshots.
Step-by-step explanation:
The task requires using Oracle Data Modeler to first create an ER Diagram (Entity-Relationship Diagram) which is also known as a Logical Model. You then need to convert this ERD into a Relational Model, where you will also be adding additional attributes and their corresponding data types.
After this, you are to generate the SQL code from the model and finally, test this code on your Oracle database server to ensure that it works as intended. As part of the submission, you are expected to provide screenshots in a Word document that detail each step of your work to demonstrate your progress and the final results.
To begin, use Oracle Data Modeler to represent the tables, fields, and relationships found in the Access database diagram. Once the Logical Model (ER Diagram) is complete, transition to the Relational Model
, where you specify the data types for each field such as VARCHAR2 for strings, NUMBER for integers, DATE for dates, etc. Following the creation of the Relational Model, use the Oracle Data Modeler's feature to generate the SQL code, which will include the commands to create tables,
define constraints, and setup any specified relationships as foreign keys. The final step is to execute the generated SQL script in your Oracle database server and validate the functionality. Remember to capture screenshots along the way to document your process.