User Account

All Pages

How primary and foreign-key relationships are applied

Assignment Help PL-SQL Programming
Reference no: EM13324981

Individual Project

At this point, you will add data to your database and validate that they loaded properly. In tabular format, include 3 rows for each table, making sure that the primary-key and foreign-key relationships are properly applied.

Next, you will insert the 30 rows of data that you identified (using the concepts you worked on identifying the primary and foreign keys), then perform queries using JOIN syntax of the database.

Task 1: Create 3 rows of data for each table ensuring that the referential integrity is valid.

Task 2: Add the 30 rows of data to the appropriate table in your database (using any appropriate method available).

Task 3: SELECT all columnsand all rowsof the 10 tables. Create a screenshot of each query and output data, and submit them.

Task 4: Write SELECT statements for the following (include a screenshot of the SQL and its execution, including the resulting data):

Display the employee id, first_name, last_name, and department_name for all employees.

Rows returned

Display the employee id, first_name, last_name, and job title_name for all employees.

Rows returned

Display the employee id, first_name, last_name, department_name, and job title_name for all employees.

Rows returned

Combine all of the SQL statements (text only) and screenshots into a single Word document, and submit it for grading.

Reference no: EM13324981

Questions Cloud

Explain raoult''s law and dalton''s law of partial pressure : Describe, using Raoult's law and Dalton's law of partial pressure, why the vapor pressure of a pair of miscible ideal liquids will always be somewhere in between the vapor pressures of the pure liquids (at the same temperatures).
Writing poetry called the poet''s companion : Kim Addonizio and Dorianne Laux have written a book on writing poetry called The Poet's Companion
Write an application that uses an array : Write an application that uses an Array to store 10 messages of type String. You will store this Array with 10 messages of your choosing.
Identify the verb phrase : Identify the verb phrase.
How primary and foreign-key relationships are applied : At this point, you will add data to your database and validate that they loaded properly. In tabular format, include 3 rows for each table, making sure that the primary-key and foreign-key relationships are properly applied.
Define the two half reactions for the pt electrode : You are titrating 100.0 mL of 0.0200 M Fe3 in 1 M HClO4 with 0.100 M Cu to give Fe2 and Cu2 using Pt and saturated Ag | AgCl electrodes to find the endpoint. (a) Write the balanced titration reaction. (b) Complete the two half reactions for the Pt..
How far from the basket was the player if he made a basket : The given information is that a basketball is shot from an initial height of 2.40 m with an initial speed 14m/s directed at an angle 37 degrees above the horizontal
Show the user level thread implementation : multitasking and one to one relationship between user level threads and kernel level threads which allows one or more threads from a process to issue blocking system calls while other threads(within that process) continue to run. Explain with desi..
Determine the speed of a point on the equator : How many radians does a point on Earth's surface move in 6 hours as a result of the Earth's rotation? What is the speed of a point on the equator

Reviews

Write a Review

PL-SQL Programming Questions & Answers

  Create a database model

Create a database model and Submit the table creation statements for the Database Model.

  Write pl-sql procedures and functions

Write PL/SQL procedures and functions to populate and query that database

  Sql questions

Write a query to display using the employees table the EMPLOYEE_ID, FIRST_NAME, LAST_NAME and HIRE_DATE of every employee who was hired after to 1 January, 1995.

  Run the lab_03_01.sql script

Run the lab_03_01.sql script in the attached file to create the SAL_HISTORY table. Display the structure of the SAL_HISTORY table.

  Write sql queries

Write a query to display the last name, department number, and salary of any employee whose department number and salary both match the department number and salary of any employee who earns a commission.

  Explaining sql insert statement to insert new row in cds

Write down a SQL insert statement to insert new row in "CDS" table.

  Write down name of actors in ascending order

Write down actors (or actress, your choice, but not both) who have won at least two (2) Academy Awards for best actor/actress. Provide the actor name, movie title & year. Order the result by actor name."

  What is an sql injection attack

What is an SQL injection attack? Explain how it works, and what precautions must be taken to prevent SQL injection attacks.What are two advantages of encrypting data stored in the database?

  Determine resonant frequency in series rlc resonant circuit

Given the series RLC resonant circuit in the figure, operating at variable frequency, determine: The resonant frequency ω o ,  The circuit’s quality factor Q , The cut-off frequencies, f 1  & f 2  and the bandwidth BW

  Query that uses cube operator to return lineitemsum

Write summary query which uses CUBE operator to return LineItemSum (which is the sum of InvoiceLineItemAmount) group by Account(an alias for AccountDesciption).

  Query to show customers were missing for existing orders

As DBA, your manager called a meeting and asked why there are so many orders for customers that don't exist in the customer table. Write query which would shows which customers were missing for existing orders. Use a join or a subquery.

  Sql query into a relational algebra statement

Turn this SQL query into a relational algebra statement? SELECT Request.reqfor, Ordering.invamt, Ordering.invnbr, Ordering.invdat

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd