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

  Write statement which creates table named part

Write the statement which creates table named Part, with Id field as an int idendity PK, a SupplierId int field, a Description string field of size 25, a Count int field, a Class string field

  Create a new database in sql server and run

Create a new database in SQL Server and run the following CREATE TABLE commands. Note that you must run the CREATE TABLE statements in the order presented (and load the data in the order presented) to avoid conflicts resulting from foreign key con..

  What could the mds that violate 4nf be

Let's define the rating of a director to be the average rating of all his/her movies. Find the names and ratings of all directors who have directed movies starring Al Pacino.

  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

  Perform the tasks below by using the correct sql statements

Create a view so that supplier 'ASP' can only see his information from the l_foods table.  Call this view_l_foods_ASP.  Show columns supplier_id, product_code, menu_item, description, and price in your view.

  Display account number and balance for all customers

This assessment item is designed to test your understanding of arrays/arraylists, objects, classes, methods, sorting and searching.

  Describe the meaning of keyword exists and not exists

Describe the meaning of the keyword EXISTS. Describe how any and all relate to EXISTS and NOT EXISTS. Write a query which will display names of any customers who are interested in all artists.

  Strengths and weaknesses of three dbms software

Research Report around 800 words strengths and weaknesses of three DBMS software packages for utilization as a company-wide customer information database. Please compare Microsoft Access, Microsoft SQL Server, and Oracle.

  Display the customerid from the orders table

Display the CustomerID from the Orders table and the sum of the associated ItemPrice multiplied by Quantity using Gross Sales (with a space) as the column name from the OrderItems table.

  Indicate the changes

Indicate the changes (using the shorthand representation) that you would need to make to the original Premiere Products database design to support the following requirements. There is no relationship between customers and sales reps.  When a custo..

  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 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