IT-FP2230-AriazCaleb-Assessment3-1.docx - IT-FP2230 Introduction to Database Systems Weekly Solutions Submission Template Name Caleb Ariaz Date Course

IT-FP2230-AriazCaleb-Assessment3-1.docx - IT-FP2230...

This preview shows page 1 - 2 out of 6 pages.

IT-FP2230: Introduction to Database Systems Weekly Solutions Submission Template Name : Caleb Ariaz Date : Course : IT-FP2230 – Introduction to Database Systems Assessment : Assessment 3 Insert here a copy of your tee log file(s) of all of your SQL statements so that they could be unzipped, loaded, and run in MySQL command line client: tee c:/users/owner/desktop/my.out; Insert here a copy of SQL statements text that you used here (copy and paste SQL statements here): Mysqldump -uroot -p volunteer > “C:\Users\owner\Desktop\volunteerbackup.sql”; DROP database volunteer; CREATE database backupvolunteer; Mysql -uroot -p backupvolunteer < C:\Users\owner\Desktop\volunteerbackup.sql; USE backupvolunteer; CREATE table address (Volunteer_ID int, Name varchar(255), Address varchar(255) primary key); ALTER table address ADD foreign key (Volunteer_ID) references person(Volunteer_ID); INSERT into address values (1',Caleb Ariaz', '1734 Round Mountain Circle, City, St.’); INSERT into address values (2, 'Kameron Nichols', '1244 Bored Way, City, St.’); INSERT into address values (3,'Victoria Ariaz', '3242 Baring Blvd. City, St.’); INSERT into address values (4, 'Nick Nichols', ‘7893 Vista Way, City, St.’); INSERT into address values (5, 'Michael Spivack', ‘7982 Sabatino Drive, City, St.’);
Image of page 1
Image of page 2

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture