Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
3. Add rows to the columns in the Customers table using five of your classmates' personal information. For the CustomerlD, use their Student Numbers. Add the following values to the Vendors table. Modify the existing data types if needed. VendorlD Name V00001 V00002 V00003 Universal Robina Corporation Liwayway Marketing Corporation Monde Nissin ContactNum CityAddress Pasig, MM Pasay, MM Makati, MM 8633-7631 8844-8441 7759-7500 5. Add the following values to the Products table. Modify the existing data types if needed. Quantity 1000 ProductID | Description VendorID PO00101 Jack 'n Jill Piattos V00001 P000102 Jack 'n Jill Nova VO0001 1000 700 850 P001005 Oishi Prawn Crackers V00002 P030007 Nissin Eggnog Cookies V00003

3. Add rows to the columns in the Customers table using five of your classmates' personal information. For the CustomerlD, use their Student Numbers. Add the following values to the Vendors table. Modify the existing data types if needed. VendorlD Name V00001 V00002 V00003 Universal Robina Corporation Liwayway Marketing Corporation Monde Nissin ContactNum CityAddress Pasig, MM Pasay, MM Makati, MM 8633-7631 8844-8441 7759-7500 5. Add the following values to the Products table. Modify the existing data types if needed. Quantity 1000 ProductID | Description VendorID PO00101 Jack 'n Jill Piattos V00001 P000102 Jack 'n Jill Nova VO0001 1000 700 850 P001005 Oishi Prawn Crackers V00002 P030007 Nissin Eggnog Cookies V00003

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

1. Previous laboratory session


CREATE DATABASE myDB;

USE myDB;

CREATE TABLE Customers (
CustomerID int NOT NULL PRIMARY KEY,
FirstName varchar(20),
LastName varchar(20),
Email varchar(20),
Gender varchar(10),
Birthdate date
);

CREATE TABLE Products (
ProductID int NOT NULL PRIMARY KEY,
Description varchar(40),
Quantity int,
Price float,
VendorID int
);

USE myDB;
CREATE TABLE Vendors (
VendorID int NOT NULL PRIMARY KEY,
Name varchar(50),
ContactNum varchar(50),
CityAddress varchar(50)
);

USE myDB;
ALTER TABLE Products
ADD FOREIGN KEY (VendorID) REFERENCES Vendors(VendorID);

Software Requirement: Microsoft SQL Server Management Studio 2017 Express or higher Procedure: 1. Execute the queries from your previous laboratory session. 2. Create queries to perform the next steps. 3. Add rows to the columns in the Customers table using five of your classmates' personal information. For the CustomerlD, use their Student Numbers. 4. Add the following values to the Vendors table. Modify the existing data types if needed. VendorlD Name Vo0001 vo0002 V00003 ContactNum CityAddress Pasig, MM Pasay, MM Makati, MM Universal Robina Corporation Liwayway Marketing Corporation 8633-7631 8844-8441 Monde Nissin 7759-7500 5. Add the following values to the Products table. Modify the existing data types if needed. ProductID Description P000101 Quantity 1000 VendorID VO0001 Jack 'n Jill Piattos Jack 'n Jill Nova Oishi Prawn Crackers Nissin Eggnog Cookies PO00102 1000 VO0001 P001005 700 VO0002 P030007 850 V00003 6. Create UPDATE statements with += and -= operators to add 274 pieces of Nova and deduct 42 pieces of Eggnog. 7. Determine which products have a quantity of less than 1000. 8. Determine which products have a quantity of less than 1000 then display the product's vendor ID and name. 9. Delete one (1) record from the Customers table based on a condition.
Transcribed Image Text:Software Requirement: Microsoft SQL Server Management Studio 2017 Express or higher Procedure: 1. Execute the queries from your previous laboratory session. 2. Create queries to perform the next steps. 3. Add rows to the columns in the Customers table using five of your classmates' personal information. For the CustomerlD, use their Student Numbers. 4. Add the following values to the Vendors table. Modify the existing data types if needed. VendorlD Name Vo0001 vo0002 V00003 ContactNum CityAddress Pasig, MM Pasay, MM Makati, MM Universal Robina Corporation Liwayway Marketing Corporation 8633-7631 8844-8441 Monde Nissin 7759-7500 5. Add the following values to the Products table. Modify the existing data types if needed. ProductID Description P000101 Quantity 1000 VendorID VO0001 Jack 'n Jill Piattos Jack 'n Jill Nova Oishi Prawn Crackers Nissin Eggnog Cookies PO00102 1000 VO0001 P001005 700 VO0002 P030007 850 V00003 6. Create UPDATE statements with += and -= operators to add 274 pieces of Nova and deduct 42 pieces of Eggnog. 7. Determine which products have a quantity of less than 1000. 8. Determine which products have a quantity of less than 1000 then display the product's vendor ID and name. 9. Delete one (1) record from the Customers table based on a condition.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS