Create a trigger for the Invoices table that automatically inserts the vendor name and address for a paid invoice into a table named ShippingLabels. The trigger should fire for an insert or update operation, but a row should be added to the ShippingLabels

Create a table-valued function named fnDateRange, similar to the stored procedure below. The function requires two parameters of data type smalldatetime. Don't validate the parameters. Return a result set that includes the InvoiceNumber, InvoiceDate, Invo

Create a view named NONPAPERBACK. It consists of the book code, title, publisher name, and price for every book that is not available in paperback. a. Write and execute the CREATE VIEW command to create the NONPAPERBACK view. b. Write and execute the comm

1. Create a view named PLUME. It consists of the book code, title, type, and price for every book published by the publisher whose code is PL. a. Write and execute the CREATE VIEW command to create the PLUME view. b. Write and execute the command to retri

Write PL/SQL or T-SQL procedures to accomplish the following tasks: a. Obtain the name and credit limit of the customer whose number currently is stored in I_CUSTOMER_NUM. Place these values in the variables I_CUSTOMER_NAME and I_CREDIT_LIMIT, respectivel

Stats Question
Q)
Four years ago, Bling Diamond, Inc., paid a dividend of $1.29 per share. Bling paid a dividend
of $1.9 per share yesterday. Dividends will grow over the next five years at the same rate they
grew over the last four years. Thereafter, div

Statistics Problem:
Q uestion)
Group 1
n
5
M
10
S2
4
Group 2 Group 3
5
12
6
5
14
5
a. using a significance level of .05, decide whether you can reject the null hypothesis that the
groups come from identical populations (steps not required):
b. Determine t

Stats Question:
Ques)
Would a bigger sample help us to access manufacturing consistency? suppose instead of the 50candy bags we work with bags that contain 200 m&m's each. we calculate the proportion of
green candies found
a)explain why it is appropriate

Stats Question:
There are 187 workers at a factory. 25 of the workers were chosen at random to complete a task.
The average completion time for the 25 workers was 8.636 minutes with a standard deviation of
3.9265 minutes.
1. Construct a 90% confidence int

Statistics Question:
Q)
In a study of 28 criminals convicted of antitrust offenses, the average age was 58 years, with a
standard deviation of 7.2 years. Construct a 98% confidence interval on the true mean age.(give
answer to one decimal point)
_to _year

C ProgramComputes the mean and standard deviation of an array of data and displays the difference
between each value and the mean.
Ans )
#include <stdio.h>
#include <math.h>
#define SIZE 8 /* maximum number of items in list of data */
int main(void) cfw_

STATS Questions:
1)
A random variable X is binomial with n = 15 and p = 0.2 What is the probability that X is at least
2?
Solution:
P(Sucsses)=0.2, q ( Failure)=0.9 ; n=15
P(x<=2) = p(x=0)+p(x=1)+p(x=2)
Formula of Binomial Distribution P(X = r) =nCr p^r (

STATS:
Q:
Three hundred viewers were asked if they were satisfied with TV coverage of a recent disaster.
Gender Female Male Satisfied 90 49 Not Satisfied 117 44
(a) Find P(satisfied). (Give your answer correct to two decimal places.)
(b) Find P(satisfied

DATABASE:
Write a procedure that updates all the payment dates to the current date + 10 days for a given
student (name) in the invoice table using cursors.
Sol:
USE tempdb
go
IF OBJECT_ID ( 'FirstUpdate', 'P' ) IS NOT NULL
DROP PROCEDURE FirstUpdate;
go
C

Query to find procedure having CONVERT statement for NULL value
select a.name, b.text from sysobjects a , syscomments b where a.id =b.id and b.text like
'%CONVERT%, NULL)%'

Query To Find Default & Null Constraint in DATABASE
SELECT a.Table_Name,a.column_name,a.Default_Name,a.[definition],b.NULLABLE
FROM ( select so.id,so.name as Table_Name,sc.name as column_name,dc.[name] as
Default_Name,
dc.[definition],
dc.parent_column_id

Find The Duplicate Names
SELECT loginame,id, name,type
FROM sysobjects
WHERE UPPER(name) IN
(
SELECT UPPER(name)
FROM sysobjects
WHERE type IN ('U', 'P', 'V', 'TR')
GROUP BY UPPER(name)
HAVING COUNT(*) > 1 )
ORDER BY name,type

Create a column that accepts null values but has a unique constraint can only have a single row with a null value. Write a trigger that prohibits duplicates, except for nulls. Use the following table If an INSERT or UPDATE statement creates a duplicate va

1. Write the SQL Statement(s) to create these tables be sure to note Primary and Foreign Keys and CONSTRAINTS. 2. Write the SQL statement to print the following REMEMBER TO USE JOINS AND ORDER BY!: AGENT NAME, CUST LNAME, CUS_INSURE-TYPE, CUS_RENEW_DATE.

Write PL/SQL or T-SQL procedures to accomplish the following tasks: a. Obtain the first name and last name of the author whose number currently is stored in I_AUTHOR_NUM. Place these values in the variables I_AUTHOR_FIRST and I_AUTHOR_LAST. Output the con

SQL: Assume the BOOK table contains a column called TOTAL_ON_HAND that represents the total units on hand in all branches for that book. Following the style shown in the text, write the code in PL/SQL or T-SQL for the following triggers: a. When inserting

Write a PL/SQL or T-SQL procedure to retrieve and output the book code, title, book type, and price for every book whose publisher code is stored in I_PUBLISHER_CODE
SOLUTION: 1. CREATE PROCEDURE sPUBLISH_dETAILS @I_PUBLISHER_CODE varchar(2) AS BEGIN SELE

Write Access functions to accomplish the following tasks: a. Delete the author whose number is stored in I_AUTHOR_NUM. b. Change the last name of the author whose number is stored in I_AUTHOR_NUM to the value currently found in I_AUTHOR_LAST. c. Retrieve

PROCEDURE: Write a stored procedure in PL/SQL or T-SQL that will change the price of a book with a given book code. How would you use this stored procedure to change the price of book 0189 to $8.49?
SOLUTION: CREATE PROCEDURE sChangePrice AS BEGIN UPDATE

SQL Procedure
Write PL/SQL or T-SQL procedures to accomplish the following tasks
1.
Obtain the first name and last name of the author whose number currently is stored in
I_AUTHOR_NUM. Place these values in the variables I_AUTHOR_FIRST and
I_AUTHOR_LAST. O

SQLite DATABASE:
1. (Used Cars) Must have 5 tables and contain a Primary key for each table. Must
have each of the relationships. a (1:1, 1:M, M:M) and be defined with Foreign
Keys.
2. Must create 1 index on a non-keyed field. Must have 1 Unique and not n