Database Example: Restoring the Author and Author-Paper Tables

Preface

Examples for this HTML/PHP script are taken from accepted papers from SIGCSE 2008. In a few cases, the status of a paper is listed here as "submitted" rather than "accepted" to provide a better example. Independent of the information reported here, all papers were accepted and are included in the SIGCSE 2008 Proceedings, available through the ACM Digital Library.

Connect to the Database

logging into MySQL database: done
selecting database: done

Remove Records from Author Table

defining query: DELETE from confAuthor
executing query: done

Remove Records from Author-Paper Table

defining query: DELETE from confAuthorPaper
executing query: done

Insert New Records into Author Table

defining query for authors 1 through 12: INSERT INTO confAuthor values (1, "Michal", "Armoni", "Weizmann Institute of Science", "made-up-1@school1.edu"), (2, "Noa", "Lewenstein", "Netanya Academic College", "made-up-2@school2.edu"),(3, "Mordechai", "Ben-Ari", "Weizmann Institute of Science", "made-up-3@school1.edu"),(4, "Irene", "Polycarpou", "Florida International University", "made-up-4@school4.edu"),(5, "Ana", "Pasztor", "Florida International University", "made-up-5@school4.edu"),(6, "Malek", "Adjouadi", "Florida International University", "made-up-6@school4.edu"),(7, "Joan", "Lucas", "State University of New York, College at Brockport", "made-up-7@school5.edu"),(8, "Jonathan", "Jarvis", "Advanced Micro Devices", "ficticious1@company1.com"),(9, "Marc", "Corliss", "Hobart and William Smith Colleges", "made-up-8@school6.edu"),(10, "Christopher", "Lewis", "VMware, Inc.", "ficticious2@company2.com"),(11, "Li", "Xu", "UMass Lowell", "made-up-9@school7.edu"),(12, "Ariel", "Ortiz", "Tecnologico de Monterrey, Campus Estado de Mexico", "made-up-10@school8.edu");
executing query: done

Insert New Records into Author-Paper Table

defining query for paper 4: INSERT INTO confAuthorPaper VALUES (1, 1), (2, 1), (3, 1), (4, 2), (5, 2), (6, 2), (7, 3), (8, 3), (9, 4), (10, 4),(11, 5), (12, 6)
executing query: done

Wrap Up

closing database: done