Using any database (one we have created before or a new one), create a program that uses Scanners OR Window Builder to take input from the user and perform: • One 'SELECT' query • One 'INSERT' query • One 'UPDATE' query • One 'DELETE' query *The queries you decide to perform are completely up to you*

Using any database (one we have created before or a new one), create a program that uses Scanners OR Window Builder to take input from the user and perform: • One 'SELECT' query • One 'INSERT' query • One 'UPDATE' query • One 'DELETE' query The queries you decide to perform are completely up to you

Programming Logic & Design Comprehensive

9th Edition

ISBN:9781337669405

Author:FARRELL

Publisher:FARRELL

Chapter7: File Handling And Applications

Section: Chapter Questions

Problem 1GZ

See similar textbooks

Similar questions

Compulsory Task Follow these steps: HHyperion Dev ● Create a program that can be used by a bookstore clerk. The program should allow the clerk to: add new books to the database ● O id O update book information O O Create a database called ebookstore and a table called book. The table should have the following structure: 3001 3002 3003 3004 delete books from the database search the database to find a specific book 3005 title A Tale of Two Cities The Lion, the Witch and the Wardrobe Harry Potter and the Philosopher's J.K. Rowling Stone The Lord of the Rings Alice in Wonderland author Charles Dickens 1. Enter book 2. Update book 3. Delete book 4. Search books 0. Exit C. S. Lewis J.R.R Tolkien Lewis Carroll qty 30 40 25 37 12 ● Populate the table with the above values. You can also add your own values if you wish. The program should present the user with the following menu: Copyright © 2021 Hyperion Dev. All rights reserved.
The SQLiteOpenHelper and SQLiteCursor classes are described, with a focus on how they may be used to perform create, read, update, and delete (CRUD) actions on a SQLite database.
Cooper College maintains a master file of students and credits earned. Each semester the master is updated with a transaction file that contains credits earned during the semester. Each file is sorted in Student ID number order. start Declarations num masterID string masterName num masterCredits num transID num transCredits string bothDone = "N" num HIGH_VALUE = 999999 InputFile master InputFile trans OutputFile newMaster getReady() while bothDone = "N" detailLoop() endwhile allDone()stop getReady() open master "studentFile.dat" open trans "semesterCredits.dat" open newMaster "updatedStudentFile.dat" readMaster() readTrans() checkBoth()return readMaster() input masterID, masterName, masterCredits from master if eof then masterID = HIGH_VALUE endifreturn readTrans() input transID, transCredits from trans if eof then transID = HIGH_VALUE endifreturn checkBoth() if masterID =…
Follow these steps: Create a program that can be used by a bookstore clerk. The program should allow the clerk to: o enter new books into the database o update book information o delete books from the database o search the database to find a specific book. Create a database called ebookstore and a table called books. The table should have the following structure: id 3001 3002 3003 3004 3005 Title A Tale of Two Cities Philosopher's Stone Harry Potter and J.K. Rowling the The Lion, the Witch and the Wardrobe The Lord of the Rings Alice in Wonderland Author 1. Enter book 2. Update book 3. Delete book Charles Dickens 4. Search books e. Exit C.S. Lewis J.R.R Tolkien Lewis Carroll Qty 30 40 25 37 Populate the table with the above values. You can also add your own values if you wish. The program should present the user with the following menu: 12 The program should perform the function that the user selects. The implementation of these functions is left up to you.
what is the best method to check a database for information entered into a search bar by a user? for example, my database will have many animals. i want to make sure they come up appropriately, or that a message will be shown to the user that the animal is not in this list. i need to create a function that will do this
Develop a C++ program to connect to a MS Access database (“Student.accdb” – attached to this assignment) and use SQL commands to manipulate its records. You may use MS Access, SQLite or another DB engine and drivers. Scope The user will be given a menu to choose from the following options: Press (S) to select and display all students records Press (D) to delete a student by ID# Press (U) to update a student’s graduation year Press (I) to insert a new student Press (Q) to quit For user option# 1, first display the header and then display every record on a separate line. See example below Student ID First Name Last Name Major Graduation Year 1 Joe Doe Computer Science 2018 2 Emma Smith Electrical Engineering 2019 3 Juan Perez Marketing 2019 For user option#2, confirm back to the user whether the deletion was successful or the ID provided was not found in the students records. For user option#3, prompt the user to enter a student ID, validate if the student ID exists…
2. load_friendsdb This function does the reverse of save_friendsdb -- it takes a single argument, filename, and opens that specified file for reading. Then it reads the file one line at a time and creates a new friends database to return. Like in the previous function, each line will contain a friend's name followed by a tab, then the friend's height, and then a newline. Sample calls should look like this: >>> load_friendsdb("friendsdb.tsv") [{'name': ' bimmy', 'height': 600}, {'name': Ian Donald Calvin Euclid Zappa', height': 175}]
What are the advantages of making an index variable local to the loop it controls?
2. load_friendsdb This function does the reverse of save_friendsdb -- it takes a single argument, filename, and opens that specified file for reading. Then it reads the file one line at a time and creates a new friends database to return. Like in the previous function, each line will contain a friend's name followed by a tab, then the friend's height, and then a newline. Sample calls should look like this: >>> load friendsdb("friendsdb.tsv") [{'name': ' bimmy', 'height': 600}, {'name': 'Ian Donald Calvin Euclid Zappa', height': 175}]
This is the most effective file organization method in which one must handle all data records in a file named
Blood Donor Management System The blood donation clinic is looking at creating a database to store the donors’ details. The clinic is hoping to start by adding donor names and assign them unique IDs. They then want to add their details and relevant information such as blood type, first name, last name and contact number. Write an interactive program that allows a clinic administrator to store donors’ details on the SQLite 3 database with the following specifications: 2.1 The program must have a menu for the administrator to select one of the following:• Register a donor• Display the record of all registered donors• Update the existing record• Delete a record• Exit the program 2.2 The program should display feedback messages for any successfully executed task and use exception handlers for any errors produced in the code. 2.3 The program must have the following functions:• The donor_register function to add donors• The donor_update function to update the donor details• The donor_remove…
4. Movie Store System This is a system for selling and buying DVDs and videos of movies. There will be three types of users. First the regular customers, they can access the database of DVDs and videos with different types of search. Second there is a group of users that can post DVDs or/and videos to be sold. These users have access to add movies to the database, so that regular customers can search for these movies. When the customer has finished searching for a DVD and/or a video he/she can communicate a message to the seller in order to buy the product from him. The third class of user is the administrator; this user will be in charge of administrating the database and users. The administrator will be in charge of giving and revoking selling privileges to regular customers so that they are able to add videos and DVDs in the database. Use Visual Paradigm to answer the above question with following four UML diagrams: UML Diagram to be used: USE CASE (For Documentation), Class Diagram…