Reference no: EM131927595
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
|
Find fundamental ways to with the stress associated
: The Seven-Step Model of crisis intervention is designed to operate as an integral part of the problem solving process. Many people have crisis situations.
|
|
Find her grade point average
: If A = 4, B = 3, and C = 2, find her grade point average.
|
|
List the crime theory or theories
: Provide theoretical support where needed, to include recommendations on crime control and crime reduction policies you would implement.
|
|
Calculate the project MIRR
: Emily's Soccer Mania is considering building a new plant. Calculate the project's MIRR, given a discount rate of 10 percent.
|
|
Create views that join data between the two database
: 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.
|
|
How do ethics impact the sport psychology professional
: How do ethics impact the sport psychology professional and the exercise psychology professional? How do ethics impact the athlete, the team, the coach.
|
|
What information is required for a nontechnical audience
: What threats do you believe will become more critical in the next twelve months? Why? What information is required for a nontechnical audience?
|
|
What are the project NPV-IRR and MIRR
: What are the project's NPV, IRR, and MIRR? Is this a good investment opportunity for Star Industries? Why or why not?
|
|
What was dan income
: If Dan paid $930 in tax, what was Dan's income? Show work.
|