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)
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...
Related questions
Question
1. Previous laboratory session
CREATE
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);
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Recommended textbooks for you
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
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
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY