User Account

All Pages

Create the needed tables in the sql server environment

Assignment Help PL-SQL Programming
Reference no: EM13324901

Given the following sample database diagram, do the following:

470_U4IP_a.png

Create the needed tables in the SQL server environment (just tables, no relationships yet).

Use integer (INT) data types for all ID columns.

Hire_Date, Start_Date, and End_Date should all be DATE data types.

Salary and Commission_Pct should be DECIMAL data types.

All other data types should be VARCHAR.

In addition, create 3 additional tables that could be consistent in a database for a human resources(HR) application,including an appropriate table name and appropriate columns.

Create and submit a screenshot of your database diagram based on the tables, and generate the data definition language (DDL) for each table.

Submit a consolidated Word document with the screenshot and the DDL for all tables (text only, no screenshots).

 

Reference no: EM13324901

Questions Cloud

Find the cars position after the mile marker : A car moves with a constant acceleration of 2.1 m/s2. At a time of 1 s, it is 170 m beyond a mile marker, Find the car's position after the mile marker at time 5 s
Public health importance of HIV-AIDS-theoretical application : AIDS is the acquired immune deficiency syndrome and is the finale stage of the infection caused by the human immunodeficiency virus (HIV). HIV/AIDS has a tremendous public health importance in the United States and around the globe. The Diffusion of ..
What is the direction of the force exerted by the particle : A particle with a charge of ? 3.00?C is placed at the point P described in part A. What is the direction of the force exerted by the particle
The design and layout of a new facility : An important OM decision that is not made often is the design and layout of a new facility. The main OM goal is to assure that the layout and design support the organization's operations in the most efficient and effective manner
Create the needed tables in the sql server environment : Create and submit a screenshot of your database diagram based on the tables, and generate the data definition language (DDL) for each table.
Find the electric field strength at midpoint between spheres : Two 2.0-cm-diameter insulating spheres have a 6.00cm space between them. find the electric field strength at the midpoint between the two spheres
How do customers effect a business level strategy : How do customers effect a business level strategy? If you were thinking of opening a small business what issues should you study about a community and the people in that community?
What is the distance between the centers of adjacent atoms : Zinc has a density of 7.14 g/cm3, and the mass of a zinc atom is 1.09 10-25 kg. What is the distance between the centers of adjacent atoms
Calculate the sensitivity of the test : Find the 96th percentile of the distribution of reaction time (at least approximately). That is, find the value such that about 96% of the distribution is below this point - Find the probability the reaction time is 500 or less.

Reviews

Write a Review

PL-SQL Programming Questions & Answers

  Write sql statement to add new record to part table

Write SQL statement which creates the stored procedure which adds new record to the Part table, and returns value of newly created PartID PK value in out parameter.

  Write a select statement that returns these columns

Write a SELECT statement that returns these columns from the Products table: The date_added column A column that uses the CAST function to return the date_added column with its date only (year, month, and day)

  You have been asked to design a data model

Law Associates is a large legal practice based in Sydney. You have been asked to design a data model for the practice based upon the following specification

  Find the sum of the elements of a

A is an ArrayList of size N. The elements of A are integers, they are in sorted order increasing from the low end of the array, and no two integers are the same. Variable x is an integer. Which of the following operations takes time that is less t..

  Design new transaction by sql statements

Code SQL statements to update view as follows: change spelling of Mark Tobey to Mark Toby. Design new Transaction for Mark Toby. Suppose you have essential transaction, work, and customer data.

  Create a pl-sql block using the hr schema

Create a PL/SQL block to achieve the following using the HR schema and select the name, salary, and department of the employee with the maximum salary.

  Write a pl-sql block

Write a PL/SQ block - Select the average salary of all employees in department number 20.

  Write the queries in sql

Write your queries so that the final answers will never include duplicates, but add the keyword DISTINCT only in cases where duplicates would otherwise be produced.

  Write sql statement which creates stored procedure

Write SQL statement which creates stored procedure with one int input parameter. Stored procedure selects supplierId field and total of all Count field values for each group of supplierId's from Part table.

  Trigger named products_insert

Create a trigger named Products_INSERT that inserts the current date for the DateAdded column of the Products table if the value for that column is null. Test this trigger with an appropriate INSERT statement.

  Write a sql query for each of the following requirement

MIS 4300 / ACCT 4300 Database Fundamentals Spring 2014. How many times the vendor has placed an order for the item ID = 1 (rename it as NUMORD)?

  Let the user type his first and last name

The program should let the user type his first and last name.

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