Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Do in C++ PART1 C/C++ programming with sqlite3 (Week05 Activity -sqlite3 example) Project Description Design and implement C/C++ program (a2partl.c or.cpp) to do the following
Do in C++
PART1 C/C++ programming with sqlite3 (Week05 Activity -sqlite3 example) Project Description Design and implement C/C++ program (a2partl.c or.cpp) to do the following tasks, to have a Makefile to compile the program, and to run the program to show each task done. You may use the sample programs (test0.c- test5.c) from Week05 Activity (sqlite3) Tasks/Steps to do. Task #0. Design and implement C/C++ program (book0.c) to do the following items: (1) to create sqlite3 db file (emp) as you may use test0.c program as a basis of your program. Task#1. Design and implement C/C++ program (bookl.c) to define a table named book with following sql statement. CREATE TABLE IF NOT EXISTS classics ( author'varchar (128) DEFAULT NULL, title varchar (128) DEFAULT NULL, category valrchar (16) DEFAULT NULL, year' char (4) DEFAULT NULL, isbn char (13) NOT NULL DEFAULT '', PRIMARY KEY (isbn Task#2. Design and implement C/C++ program (book2.c) to insert the records into table book with the records as listed below INSERT INTO classics. ('author',title,category', 'year',ISbn . ) VALUES ('Mark Twain', 'The Adventures of Tom Sawyer', 'Fiction', '1876' 9781598184891'), 'Jane Austen','Pride and Prejudice', 'Fiction', '1811', '9780582506206') ('Charles Darwin', 'The Origin of Species','Non-Fiction', '1856' 9780517123201'), ('Charles Dickens', 'The old Curiosity Shop', 'Fiction', '1841', 9780099533474), ('William Shakespeare''Romeo and Juliet', 'Fiction', '1594', 9780192814968), Herman Melville', 'Moby Dick', 'Fiction', '1851', '9780199535729" Task#3. Design and implement C/C++ program (book3.c) to select all the records from table book to be printed Task#4. Design and implement C/C++ program (book4.c) to update a record in table book so that the book's category will be changed from 'Fiction' to 'Play' for "Romeo and Juliet" and print the resulting content of the table. Task#5. Design and implement C/C++ program (book4.c) to delete a record in table book so that "Moby Dick" will be deleted from the table, and to print the resulting content of the tableStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started