Phone Number Data
Phone Number Data
IT-FPX2230 Intro to Database Systems
Capella University
Part B
1. Copy the SQL that successfully creates the table and paste it into a
Word document for this assessment CREATE TABLE phone_numbers (
phone_number_id INT AUTO_INCREMENT PRIMARY KEY,
phone_number VARCHAR(20) NOT NULL,
phone_type VARCHAR(50),
volunteer_id INT,
, FOREIGN KEY (volunteer_id) REFERENCES volunteers(volunteer_id)
);
2. Copy the INSERT statements and paste them in the Word document.
INSERT INTO phone_numbers (phone_number, phone_type,
volunteer_id)
VALUES
('123-456-7890', 'Home', 1),
('987-654-3210', 'Mobile', 2),
('111-222-3333', 'Work', 3),
('444-555-6666', 'Home', 3),
03:53:49 GMT -05:00
Phone Number Data
IT-FPX2230 Intro to Database Systems
Capella University
Part B
1. Copy the SQL that successfully creates the table and paste it into a
Word document for this assessment CREATE TABLE phone_numbers (
phone_number_id INT AUTO_INCREMENT PRIMARY KEY,
phone_number VARCHAR(20) NOT NULL,
phone_type VARCHAR(50),
volunteer_id INT,
, FOREIGN KEY (volunteer_id) REFERENCES volunteers(volunteer_id)
);
2. Copy the INSERT statements and paste them in the Word document.
INSERT INTO phone_numbers (phone_number, phone_type,
volunteer_id)
VALUES
('123-456-7890', 'Home', 1),
('987-654-3210', 'Mobile', 2),
('111-222-3333', 'Work', 3),
('444-555-6666', 'Home', 3),
03:53:49 GMT -05:00
