Ask the user to enter the name of a fruit. Your program should search the provided ”fruits-database.txt” for the fruit. If the fruit is available, print the price per pound of the fruit. If it's not in the database, print “The fruit does not exist”.
Q: Write a script that declares two variables and sets them to the counts of all fulltime and all…
A: Answer: SQL Script: DECLARE @FULLTIME AS INT, @PARTTIME AS INTSET @FULLTIME = (SELECT COUNT(*) FROM…
Q: How do you determine if a database object exists?
A: The following methods are available for determining the number of database objects that have been…
Q: In SQL statement, alias is used for which purpose? O a. retrieving information from the database O…
A: Option a is wrong. Aliases are not used to retrieve information from the database Option b is wrong.…
Q: Create a program (using sQL strings) that willinsert one record, increase by 8 % the unit price of…
A: the answer is given below :
Q: How many parameters are there in the given code? CREATE or replace procedure raise_sal (empid…
A: Find Your Answer Below
Q: st ID TID items bought (in the form of brand-item category) 01 T100 {King’s-Crab, Sunset-Milk,…
A: the code is an given below :
Q: What is the value of dept after performing the following operations? char dept[20]="Final"; char…
A: Answer:
Q: Write a function called queryData() which will search the customerArray and output the following…
A: <!DOCTYPE html><html><body> <p>Jeff Smith is a 17 year old Male from London,…
Q: Develop a two small PL/SQL programs. 1. Enter students ID from the keyboard. The program then…
A: here i mentioned PL/SQL small two programs for given problem. also handled NO_DATA_FOUND and…
Q: Question 11 You usually use _______ to reference data values that programs retrieve from the DB.…
A: Data stored in database can be referenced in program to use and reflect back to database.
Q: Write the Java code to calculate your 'CGPA'. The grades history is recorded in a database. Consider…
A: import java.util.Scanner; class CGPACalculation { double sum=0; CGPACalculation(double…
Q: Question 1 You usually use to reference data values that programs retrieve from the DB. scalar…
A: here we have given a brief note on reference data values that programs retrieve from the DB.
Q: public static void enterStudentid(String studentid) { int locator=0; for(int check_database =0;…
A: Required: how can I add an error message saying ( the ID you inter dost exist )like if it is false…
Q: Write a Python program that connects to a sqlite database. Create a table called Horses with the…
A: Code : import sqlite3 from sqlite3 import Error def create_connection(db_file): conn = None…
Q: a. Load a database application…
A: Answer : given data, MovieID Movie Name Date Released Movie Category Quantity Delivered…
Q: To be able to use the database, we have to give a namespace in our application we write: *
A: The.NET Framework Data Provider for OLE DB describes a collection of classes used to access an OLE…
Q: Which of the following is not part of a standard SQL statement? a. Importable programming libraries…
A: Below is the answer to above question. I hope this will be helpful for you..
Q: In c++, Using SQL containers,components, and algorithms show all data from text file movies.txt…
A: ALGORITHM:- 1. Display the menu to the user to display the list of movies present in the file. 2. If…
Q: Here you will be writing a program to maintain the student database. Your program will maintain the…
A: #Menu Structure Program for a Student database #Five arrays to store name, ID, Score1, Score2 and…
Q: The problem with Access forms is that they cannot be customized. True False
A: Access forms are used to present information as per the requirement.
Q: This sl/sql program Please make a procedure that takes two parameters and prints a list of students…
A: A procedure is a collection of code which encloses sql statements within its body. PARAMETERIZED…
Q: In what circumstances does it make sense to assume that two select statements from the same database…
A: Introduction: Union compatibility is achieved when both tables contain the same amount of attributes…
Q: what is the best method to check a database for information entered into a search bar by a user?…
A: A search box, the search field or the search bar is used to navigate computers like file managers,…
Q: create a program in C# to run stored procedure called GetCustomer that is stored in MS Sql server,…
A: I attached your answer below. Give connection properly you can get data from the SQL server. server…
Q: Write code that will open the file CustomerDB.txt for input.
A: Note: Answering in python as no language is mentioned. Input : Open file CustomerDB.txt. Write some…
Q: Example: Parameter style JAVA procedure with XML parameters This example shows the following: •…
A: Code to create a parameter style JAVA procedure with XML parameters CREATE PROCEDURE xmlProc1 ( IN…
Q: Which of the following about dictionaries is false? A) Keys need to be unique B) Values need to be…
A: Answer in step2
Q: The final result of "records.txt" file will look something like this (depending on the number of…
A: creating_records.py from calculating_average import * name_list= [] courselist = [] nostd =…
Q: Exercise #3 Write the method searchKey (char key), which search data key' in the Iist and return its…
A: Note: Answering the question in python as no language is mentioned. Input : List of values Item to…
Q: (uata types are HOT ITCUCU). SalesPerson (salesPersonId, salespersonLastName, dateOfBirth, gender,…
A: Solution: 3.1) 3.1.1) SQL Query: SELECT salesPersonId, salespersonLastname from…
Q: te a Python program to create a SQLite database and connect with the database and print the version…
A: Lets see the solution.
Q: b) Write code segment with SQL statements that will: -Insert these details into the table at the…
A: Assume you have successfully connected your application, developed in Visual Net using ADO to MySQL…
Q: Given is a Python program that connects to a sqlite database and has one table called writers with…
A:
Q: Given a class called Student with the following fields: id (primary key), name, address, credit…
A: Java Class class instances represent the classes and interfaces in a running java application. Every…
Q: The database programs will sort the résumés by?
A: Database program provides file creation, data entry update query and reporting functions.
Q: DECLARE v_emp_id vr emp employees.employee_idXTYPE : :Enter Employee Id; employeesXROWTYPE; BEGIN…
A: Below i have answered:
Q: Write a Python program that connects to a sqlite database. Create a table called Horses with the…
A: Actually, python is a easiest programming language. It is a dynamically typed programming language.
Q: Given is a Python program that connects to a sqlite database and has one table called writers with…
A: Required: Given is a Python program that connects to a sqlite database and has one table called…
Q: Write a Python program to create a table and insert some records in that table. Finally selects all…
A: import sqlite3 from sqlite3 import Error def sql_connection(): try: conn =…
Q: Given is a Python program that connects to a sqlite database and has one table called writers with…
A: List of Modifications done in above code: In create_db() function, Database("Writer.db") created…
Q: Write a Python program to create a table and insert some records in that table. Finally selects all…
A: Python program to create a table and insert some records in that table. Finally selects all rows…
Q: Repeat the example below but this time you should do the following : - Maintain a database in a…
A: we make a different car rental system C++ program which is given below
Q: Every supper key is also a primary key True or false?
A: Super Key: A super key is an attribute (or combination of attributes) that is used to identify all…
Q: Write a Python program that connects to a sqlite database. Create a table called Horses with the…
A: import sqlite3 from sqlite3 import Error def create_connection(db_file): """ create a database…
Q: Write an anonymous block that prompts the user to input a positive integer. It should then print the…
A: In the given code The variable n is declared as a number. The variable i is declared as a number.…
Q: A hospital wishes to maintain database of all the doctors and the patients in the hospital. For each…
A: We need to create a simple hospital management system as per the given scenario.
Q: Given is a Python program that connects to a sqlite database and has one table called writers with…
A: Procedure followed to implement insert_writer(con,data) function:This function inserts a new writer…
Q: Questions Begin Here 1. Write a FUNCTION that will take price as a parameter and give the following…
A: if the price is greater than or equal 1000 and below 2000, set discount to 10 percentage if the…
Q: Write a Java segment of code to create and update the database which is inherit from…
A: The syntax for create is: public abstract void onCreate(SQLiteDatabase db) The syntax for upgrade…
Ask the user to enter the name of a fruit. Your
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
- Use Python Programming - restaurant reservation program. The application offers different reservation rate for adults and children. (see sample below) RESTAURANT RESERVATION SYSTEMSystem Menua. View all Reservationsb. Make Reservationc. Delete Reservationd. Generate Reporte. Exit 2. When the VIEW RESERVATIONS is clicked, this will display all the reservations made: # Date Time Name Adults Children 1 Nov 10, 2020 10:00 am John Doe 1 1 2 Nov 25, 202011:00 am Michelle Franks 2 1 3 Dec 10, 2020 9:00 am Ella Flich 1 1 4 Dec 21, 2020 12:00 pmDylan Cloze 2 1 3. If the user selects MAKE RESERVATION, the user needs to input the following: a. Name (String)b. Date (String)c. Time (String)d. No of Adults (Integer)e. No of Children (Integer) Note: Adult is 500 per head and Kids is 300 per head reservation, save the data in a text file. 4. If DELETE RESERVATION is selected, the user needs to input the reservation number to remove the existing reservation. 5. If the GENERATE REPORT is clicked,…A computer store uses a database to track inventory. The database has a table named Inventory , with the following columns: ProductID INTEGER PRIMARY KEY NOT NULL ProductName TEXT QtyOnHand INTEGER Cost REAL Also assume that the cur variable references a Cursor object for the database. Write Python code that uses the Cursor object to execute an SQL statement that does the following: For every row in the Inventory table in which Cost is equal to 1599.99, set the QtyOnHand column to 22.A computer store uses a database to track inventory. The database has a table named Inventory , with the following columns: ProductID INTEGER PRIMARY KEY NOT NULL ProductName TEXT QtyOnHand INTEGER Cost REAL Also assume that the cur variable references a Cursor object for the database. Write Python code that uses the Cursor object to execute an SQL statement that deletes the row in the Inventory table in which ProductID is equal to 12.
- you have to write an application that helps with monthly bill payments. You have to write an sql code that creates the appropriate database. As the second part you need to write an application that will allow a user to add a payment, add a contractor, display payments for a given month. Additionally, when a user selects a month, your application should provide information of the expenses he/she need to pay that month. Hint: the selected month is a new entry in the database. Java codesIn c++, Using SQL containers,components, and algorithms show all data from text file movies.txt Console Movies program COMMAND MENU show - user is able to see all available movies from movies.txt command: show The Adventures of a Babysitter $10 Barney $25 Larry the Car Man $15 Dora and the missing map $15 Ceasar and the Lunch Lady $10 Suzie and the Bad Kids $13.95 movies.txt with all possible movies: The Adventures of a Babysitter $10 Barney $25 Larry the Car Man $15 Dora and the missing map $15 Ceasar and the Lunch Lady $10 Suzie and the Bad Kids $13.95The symbol table stores the memory address associated with each variable. What is the memory address of the start_time variable in main()? You only need to fill in the last 2 digits of the address. 0x7ffd949d30__ What symbol was added after the data type of MoveSchedule's start_time and end_time parameters? Place a check (✓) beside your answer. int * & start_time What is the memory address of the start_time variable in MoveSchedule()? You only need to fill in the last 2 digits of the address. 0x7ffd949d30__ What happens to the value of the start_time variable in main() when the start_time variable in MoveSchedule is updated? Place a check (✓) beside your answer. start_time in main remains the same start_time in main gets the value assigned to start_time in MoveSchedule start_time in main changes to 0.
- 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…Correct answer will be appreciated.else downvoted.In the following procedure, the parameter age represents a person's age. The procedure is intended to return the name of the age group associated with age. People who are under 18 are considered minors, people who are 65 and older are considered senior citizens, and all other people are considered adults. The procedure does not work as intended. Line 1: PROCEDURE ageGroup(age) Line 2: } result "adult" Line 3: Line 4: IF(age 65) Line 5: { Line 6: result "senior citizen" Line 7: Line 8: RETURN(result) Line 9: Line 10: result "adult" Line 11: IF(age < 18) Line 12: Line 13: result "minor" Line 14: Line 15: RETURN(result) Line 16: } ill cause the procedure to work as intended?
- Develop a two small PL/SQL programs. 1. Enter students ID from the keyboard. The program then finds student's first name, last name and phone, stores them in variables and prints them on the screen. 2. Similar to the above, only this time the program will receive student's first name only (instead of student's ID)Then program finds full name and address and prints it on the screen. For both programs please implement NO_DATA_FOUND and TOO_MANY_ROWS exceptions. (please refer to chapter 8 in PL/SQL by Example book)For number 2 program, display a message "Possibly you have two or more students with the first name ...." in TOO_MANY_ROWS exception block.There should be an explanation of the GetConsoleTitle function.Given is a Python program that connects to a sqlite database and has one table called writers with two columnns: name - the name of a writer num - the number of works the writer has written The writers table originally has the following data: name, num Jane Austen,6 Charles Dickens,20 Ernest Hemingway,9 Jack Kerouac,22 F. Scott Fitzgerald,8 Mary Shelley,7 Charlotte Bronte,5 Mark Twain,11 Agatha Christie,73 Ian Flemming,14 J.K. Rowling,14 Stephen King,54 Oscar Wilde,1 Update the Python program to ask the user if they want to update entries or add new entries. If the name entered already exists in the writers table then the database record is updated, overwriting the original contents. If the name does not exist in the writers table, then add a new record with the writer's name and number of works. The following TODO sections must be completed. Check if a writer exists in the writers table If the writer exists in the table, locate an entry to be updated by writer's name and update the…