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

  Script that creates and calls a function named

Write a script that creates and calls a function named fnDiscountPrice that calculates the discount price of an item in the OrderItems table (discount amount subtracted from item price). To do that, this function should accept one parameter for th..

  Convert requirement to logic and then to sql

Prepare the SQL query for each of given requirements. Convert requirement to logic, then to SQL. Illustrate the names of all products which have been sold.

  Write sql statement to create view

Write a SQL Statement to create a View called vwEmployeeTerritories that will do the following: Return all Employees and their Territories (use INNER JOIN).

  Display all the lastnames from the customers table

Display all the LastNames from the Customers table and any associated OrdersIDs from the Orders Table. Show the LastName even if they do not have any associated orders. Order the results by LastName in ascending order.

  How to select the primary key

How to select the primary key from the candidate keys? How do foreign keys relate to candidate keys? provide examples from either your workplace or class assignments

  Write a program in towers of hanoi

How to write a program in towers of hanoi using pl/sql language

  Create a view named productsummary

Create a view named ProductSummary that uses the view you created in exercise 4. This view should return some summary information about each product.

  Select distinct cmdclient

SELECT DISTINCT CMDclient.'Client Code SCA' as GuestCode, CMDextras.ArrivalDate as arr, CMDextras.DepartureDate as dep, CMDapr.FirstName as fname, CMDapr.Surname as lname

  If the value for the listprice column is a negative number

If the value for the ListPrice column is a negative number, the stored procedure should raise an error that indicates that this column doesn't accept negative numbers. Similarly, the procedure should raise an error if the value for the DiscountPer..

  Identify the attributes of the entities

Identify the various entities and their attributes involved in the application and identify the attributes of the entities that are unique to each entity.

  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.

  Pretend that you are on the boards

Pretend that you are on the boards of the American National Standards Institute (ANSI) and the International Organization for Standards (ISO), two of the organizations who standardized SQL

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