The included DDL and DML txt files will create the databse structure. This is to create a distributed database system. The instructions below are how to create the tables and running the DML. Once that is done, then the views/queries need to be completed.

Use the DDL to create the same tables on a database called 663a and 663b. Once the tables are created, create the database link on 663a.

The script that was used to create was:

CREATE DATABASE LINK fr_a_to_b CONNECT TO DB_USER IDENTIFIED BY "Password" USING '663b';

After the database link is created, test to verify it is working:

SELECT *

FROM DUAL@fr_a_to_b;

Next use the DML txt and run it on the 663a database. This will populate the 663a and 663b database with data.

Proceed to create views and queries. Provide the sql commands in a document for each of the views and queries with screenshot of it working.

Develop 5 Views and 5 Queries

Develop DDL to create views and queries to access those views. Create views that join data between the two database servers to simulate data distribution.

Also, state which database they are ran on and why it is running on that database. (663a or 663b).

Attachment:- DDL & DML.rar