CUSTOMER CustomerID CustomerName Customer Address CustomerCity CustomerState CustomerPostalCode 1 Contemporary 1355 S Hines FL Gainesville 32601-2871 Casuals Blvd 2 Value Furniture 15145 S.W. Plaro TX 75094-7743 3 Home 17th St 1900 Allard Albany NY 12209-1125 Furnishings Ave. 4 Eastern Furniture 1925 Beltline Carteret NJ 07006-3188 Rd. 1 5 Impressions 5585 Westcott Sacramento CA 94206-4066 Ct. 6 Furniture 325 Flatiron Dr. Boulder CO 80514-4432 Gallery 7 Period 394 Rainbow Seattle WA 97954-5589 Furniture Dr. 8 Califomia 816 Peach Rd. Santa Clara CA 98915-7754 Classics 9 M and H Casual 3709 First Street Clearwater FL 34620-2314 Furniture 10 Seminole 2400 Rocky Seminole FL 34646-4423 Interiors Point Dr. 11 American 2424 Missouri Prospect NJ 07508-5621 Euro Lifestyles Ave N. Park 12 Battle Creek 345 Capitol Battle Creek M 49015-3401 Furniture 13 Heritage Ave. SW 66789 Colege Carlisle PA 17013-8834 Furnishings Ave. 14 Kaneohe 112 Kiowal St. Kaneohe HI 96744-2537 Homes 15 Mountain 4132 Main Ogden UT 84403-4432 Scenes Street ORDER OrderID OrderDate Customer l 1001 21/Oct/15 1 1002 21/Oct/15 B 1003 22/Oct/15 15 1004 22/Oct/15 5 1006 24/Oct/15 3 1006 24/Oct/15 2 1007 27/Oct/15 11 1008 30/Oct/15 12 1009 05/Now/15 1010 06/Nov/15 4 1 ORDERLINE Order ID ProductID Ordered Quality 1001 1 2 1001 2 2 1001 4 1 1002 3 5 1003 3 3 1004 6 2 1004 8 2 1005 4 4 1006 4 1006 5 2 1006 7 2 1007 1 3 1007 2 2 1008 3 3 1008 8 3 1009 4 2 1009 7 3 1010 8 10 PRODUCT Product ID Product Description | ProductFinish | ProductStandard Price | ProductlineID 1 2 End Table Coffee Table Natural Ash Cherry 175 1 200 2 3 Computer Desk | Natural Ash 375 2 4 Entertainment Natural 650 3 Center Maple 5 Writers Desk Cherry 325 1 B 8-Drawer Desk White Ash 750 2 7 Dining Table Natural Ash 800 2 B Computer Desk Walnut 250 3

A unique identifier for a data row that consists of more than one field is commonly called a: primary plus key composite primary key foreign key none of the above

Insert the following data into your database tables.STUDENTSSTUDENT_ID STUDENT_NAME STUDENT_SURNAMES123456 Neo PetleleS246810 Derek MooreS369121 Pedro NtabaS654321 Thabo JoeS987654 Dominique WoolridgeMODULESMODULE_ID MODULE_NAME MODULE_CREDITDATA6212 Database Intermediate 30INPU221 Desktop Publishing 20PROG6211 Programming 2A 15PROG6212 Programming 2B 15WEDE220 Web Development (Intermediate) STUDENT_MODULESSTUDENT_ID MODULE_IDS123456 PROG6211S123456 PROG6212S246810 DATA6212S369121 DATA6212S369121 INPU221S369121 WEDE220S987654 PROG6211S987654 PROG6212S987654 WEDE220LECTURERSLECTURER_ID LECTURER_NAME LECTURER_SURNAMEL578963 Kwezi MbeteL876592 Julia RobinsL916482 Trevor JanuaryLECTURER_MODULESMODULE_ID LECTURER_IDDATA6212 L578963INPU221 L876592PROG6211 L916482PROG6212 L916482WEDE220 L876592Correct INSERT statements used and all data correctly inserted per table.

Alter table product so that column productType is an integer instead of a varchar, not null should be maintained. Alter table product so that column productType is a foreign key to table productType, column id Alter table customer so that column zipCode is a foreign key to table çityState. column zipCode Alter table customer to drop column city and state Alter table employee so that column zipCode is a foreign key to table çityState. column zipCode Alter table employee to drop column city and state Alter table supplier so that column zipCode is a foreign key to table çityState, column zipCode Alter table supplier to drop column city and state

USE MICROSOFT SQL SERVER

Display only the sales territories that have more than one salesperson.

Create a list showing only the EmployeeID, Sales, and Projected Sales sorted from highest to lowest amount for Sales

You may find the following hierarchy useful when you code your classes. A fee invoice for an MS student should look like VALENCE COLLEGE ORLANDO FL 10101 The purpose of this project is to create a fee invoice application for students attending Valence College, a college in the State of Florida. There are two types of students: graduate (PhD and MS) and undergraduate. An out- of-state undergraduate student pays twice the tuition of a Florida-resident undergraduate student (all pay the same health and id fees of $35). A graduate student is either an PhD or an MS student. PhD students don't take any courses, but each has an advisor and a research subject. Each Phd student must supervise at least one lab. A lab can be supervised by more than one PhD student (Labs can't be supervised by undergraduate students nor MS students). MS students can only take graduate courses, and undergraduate students can only take undergraduate courses. At this time, Valence College offers the following list of…

Database name: Ch03_StoreCo Table name: EMPLOYEE EMP CODE EMP TITLE EMP LNAME EMP FNAME EP NTIAL EMP DOe STORE CODE imson John 21-May-64 Ratula 09-Feb-60 Nancy Lotte 2 Ms 3 Ms. Oreenboro R 02-Oct-61 4 Jervie Robert 01Jun-71 23-Nov-59 4 Mrs Runperstro SM. Smth 25-Dec-65 Renselser Ogalo Johneson Cary A 31--62 7 M 8 Ms Roberto 10-Sep-60 19-Apr-55 06-Ma6 21-Oct-72 Ekzbeth Endemar Jack 2. 10 Ms. Rose 11 M Broderick Ton 08-Sep 74 25-Au4 25May6 24-May-64 03-Sep-60 12-Nov.70 24 Jan-71 12 M Washington Alan Y 13 M Snth Peter IN 14 Ms Smth Sherry 15 M Olenko Howard 16 M Archiso Barry 17 Ms Grimaido Jenine 4. 18 M. Roserberg Andrew D 03-Oct-60 06-Mar-70 19 M Rosten Peter F 20 M Mckee Robert 1 21 Ma Baunann Jenniter A 11-Dec-74 Table name: STORE STORE YTD SALES REGION_CODE P CODE STORE CODE STORE NAME 1 Access anction 1003455 76 14217 39 986783 22 944568 56 2 Database Coner 3 Tuple Charge 4 Atribute Aley 5 Prinary Key Point 1 29300 45 15 Table name: REGION REGION CODE REOION DESCRPT 1 East 2 west…

List 10-15 application that you have encountered or know.