For this assignment, you will need to write a query for each of the cases mentioned below. All queries should be written against tables that you have created in your previous assignment (see attached for previous assignment).

1- Get the list of all Shippers with the character ‘A’ in any place in their CompanyName (query against the Shipper table). 
2- A query to get the record count in the Employee table. 
3- A Query to return all Emp_ID, Emp_Fname, Emp_Lname, Emp_Email in theEmployee table. Order the result on Emp_Fname and Emp_Lname in descending order (query against the Employee table).
4- A query to get the count of customers who are in one of the New England states(query against the Customer table).
5- A query to get the list of all Customers from ‘MA’ who are not from Boston.

 

 

___________________________________ CREATE TABLE Shipper ( ShipperID CHAR(2) NOT NULL, CompanyName CHAR(20), Phone CHAR(15) ); ____________________________________ CREATE TABLE Employee ( Emp_ID CHAR(3), Emp_Fname CHAR(10) NOT NULL, Emp_Lname CHAR(12) NOT NULL, Emp_Password CHAR(8) NOT NULL, Emp_email CHAR(15) ); ALTER TABLE Employee ADD CONSTRAINT PK_employee_Emp_ID PRIMARY KEY (Emp_ID); _______________________________________ Create TABLE Customer ( Cust_ID CHAR(5) NOT NULL, Cust_Fname CHAR(10) NOT NULL, Cust_Lname CHAR(12) NOT NULL, Cust_Password CHAR(8) NOT NULL, Cust_email CHAR(15), Cust_address CHAR(30), Cust_city CHAR(12), Cust_state CHAR(2), Cust_zip CHAR(9), Locked_flag CHAR(1), Emp_ID CHAR(3) ); ALTER TABLE Customer Add constraint PK_customer_Cust_id primary key (Cust_ID); ALTER TABLE Customer Add constraint FK_Customer_Emp_ID foreign key (Emp_ID) references Employee (Emp_ID);

• 1495515782-Assignment hard copy.txt
• 1495515783-phpproject.zip

ComputerScienceExpert

(11)

Status NEW Posted 23 May 2017 04:05 AM My Price 11.00

-----------

Attachments

file 1495515784-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer