To be able to use the database, we have to give a namespace in our application we write: *
Q: Please Explain this code Step by Step (How Code Works). #include #include #include char…
A: Program is given and need to explain how it is work.
Q: The struct song is defined as : typedef struct { char* title; char* artist; int year; }…
A: #include <stdio.h>#include <stdlib.h>#include <unistd.h>#include <time.h>…
Q: You're given a folder containing the following files listed and other files. Lis the folder and…
A: Given:
Q: NOTE: Avoid extra whitespaces. #include Records char name[50]; int grade;
A: GIVEN: Complete the given program by filling the blanks.
Q: n be used to quickly grow an application, but some features of an application make it impossible to…
A: Key-value storeThe key-value approach is used in this form of the NoSQL database, which represents a…
Q: Create a subprogram called Birthday_sub that accepts today's date as default parameter and writes…
A: PROCEDURE BIRTHDAY_SUB (date); BEGIN INSERT INTO B_C_File ( first_name, last_name,…
Q: • Returns False if two Food objects do not have all the same attributes • This method should not…
A: Python used to answer this question
Q: What is the value of dept after performing the following operations? char dept[20]="Final"; char…
A: Answer:
Q: write method called BinarySearch which accept unsorted integers numbers and a key. The method should…
A: As no programming language was mentioned, the below work is done in C++. Code:- #include…
Q: void removeStudent() { System.out.print("\n Enter StudentID to remove: "); long id =sc.nextLong();…
A: I reason why it is going back to the menu after reading ID is, after removing you are not printing…
Q: studentNumber (int), courseCode (char array [8]), finalGrade (float). 200201078 CENG104 89.75…
A: Declare an integer variable to store user input for options from 0 to 6. Declare variables to hold…
Q: Use pseudocode in designing the logic. Laramie Park District has files of participants in its…
A: Pseudocode:- Pseudocode resembles program code however without being restricted to the syntax of an…
Q: The code is supposed to prompt the user to enter a studentID and if it is in the records then it…
A: students is a list and we are searching the student with id and have to remove this by specifying…
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: 2 Removing class A unique record in the database is identified by ID and Course. Using only ID will…
A: Updated version is given below :-
Q: Write “Handle Return” use cases for each following functionality: (a) Room reservation (b)…
A: Write “Handle Return” use cases for each following functionality: (a) Room reservation (b) Changing…
Q: Use Python Programming - restaurant reservation program. The application offers different…
A: Given: Use Python Programming - restaurant reservation program. The application offers different…
Q: Write a function that takes three input parameters: ‘mintCalorie’, ‘maxCalorie’, and ‘range’.…
A: Since no programming language is mentioned, I am using python. Algorithm: Start Implement a…
Q: case 5: System.out.print("Enter the student's ID code: "); String studentid = readInput.next();…
A: There Should be Closing Curly Braces for Closing the loop.
Q: True or FalseAn application works directly with a database, modifying rows, deleting rows, adding…
A: An application needs a DataSet object for the database. The data can be modified after the DataSet…
Q: Python with File Method Restaurant reservation program. The application offers different…
A: It is defined as a powerful general-purpose programming language. It is used in web development,…
Q: int total = 1; while (total < 8) { total = total + 3; System.out.println(total);…
A: int total=1; while(total<8) { total=total+3; System.out.println(total); }…
Q: BY JAVA Write a program to read and store four student’s id number and their grade, sort them into…
A: import java.util.Scanner;class Student{ String id; float grade;}public class SortID_yourID{…
Q: In c# visual studio add a windows form and run stored procedure using parameters. Please write…
A: In c# visual studio add a windows form and run stored procedure using parameters. Please write…
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: R, how to find the number of rows in an object? Please use the which statement
A: Answer:
Q: Briefly explain the difference between new operator and delete operator.
A: Dynamic Memory Allocation is used to avoid wastage of memory in programming
Q: Write a test_book.py file. Complete the following tasks. A . Create 2 book objects with the…
A: Answer:- Python code:- test_book.py import pickle from book import book # save_books() function #…
Q: Purpose of this assignment: To allow student to be able to implement a Java-based application by…
A: In This program, We to execute Java Program for which - Customer Data in input.txt file -> Here,…
Q: Given what is supposed to be typed and what is actually typed, write a function that returns the…
A: Coded using JavaScript.
Q: Write a program in c Build an application for a car rental company. It should offer the following…
A: Given: Build an application for a car rental company. It should offer the following features: •…
Q: You cannot create a shared pointer that does not reference an object. O True False
A: According to the information given:- We have to choose the correct option to satisfy the statement.
Q: Java Project: Overview: Next year, God willing, Arab Open University will organize an international…
A: Answer:
Q: You are to create a database of books that are stored using a vector. Keep track of the author,…
A: You are to create a database of books that are stored using a vector. Keep track of the author,…
Q: There should be an explanation of the GetConsoleTitle function.
A: We need to define the term:- GetConsoleTitle function:- This is used to retrieve the title of the…
Q: Use Python Programming - restaurant reservation program. The application offers different…
A: if(choice == "a"): if (len(reservation) == 0): print("There are no reservations!!")…
Q: Take the supplied cars_db.sql and create your Cars database (you will have to create the Cars…
A: Actually, Java is a programming language originally developed by James Gosling at Sun Microsystems…
Q: Add the purple code to your Main Code Section
A: checkerObj = PriceChecker() # Load levelsList from the records in levelsFile…
Q: In C LANGUAGE: You will build a system to manage patients’ data in a hospital. The hospital patient…
A: /HEADER FILES #include<stdio.h>//Use for standard I/O Operation #include<windows.h>…
Q: The report should show each salesperson’s sales and the total sales for that salesperson. The report…
A: The given question is to generate a report in the above given format that is to find out each sales…
Q: ______ does not end a request. response.write() response.end()…
A: The correct option would be a response.write().
Q: 6. Tailacess.log will returns
A: Generally Tailacess is used to access the file in the path. Tailacess has many methods to access the…
Q: esforce Trigger: this question you have to write a trigger condition that will use for the insert…
A: The Scenario of the trigger is that there is a checkbox on Account object called "Create Contact".…
Q: Fill-in-the-Blank You should only use the delete operator to deallocate memory that was dynamically…
A: GIVEN: Fill-in-the-Blank You should only use the delete operator to deallocate memory that was…
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: Suppose that the application requires you to model students. A student has a name and an address.…
A: 1. Create class Student 2. Add all the given data member 3. Add all the the getter and setter 4.…
Q: $(function(){ // jQuery methods go here... }); What is the purpose of this code with respect to…
A: Hi. Let's move on to the solution in the next step.
Q: (java programming language) Write a program to read and store four student’s 21SP registered course…
A: Problem: To read and store four student’s 21SP registered course and their grade point sort them…
Step by step
Solved in 2 steps
- Which of the following data dictionary objects should be used to view information about the constraints in a database? USER_TABLES USER_RULES USER_COLUMNS USER_CONSTRAINTS None of the above objects should be used.· Make an Application called “ Student Management System ” that connect with database called university , the database contain 3 Tables o Student Table \ this Table contain all Data About Student in University { 1. Id --- int , primarykey 2. Name --- String 3. Gpa --- Double 4. College --- IT 5. Age --- int } o Course Table \ this Table contain all Data About Courses in University { 1. CourseId ---- String 2. CourseName ---- String 3. TeacherName ---- String 4. college ---- String 5. number Of Student ---- int } o Student-Course Table \ this table contain a foreign key for both table “ Student and Course ” and contain data about the student who takes some courses or a courses that have number of Student { studentID --- int , foreign key from Student Table courseID --- int , foreign key from Course Table }· Make an Application called “ Student Management System ” that connect with database called university , the database contain 3 Tables o Student Table \ this Table contain all Data About Student in University { 1. Id --- int , primarykey 2. Name --- String 3. Gpa --- Double 4. College --- IT 5. Age --- int } o Course Table \ this Table contain all Data About Courses in University { 1. CourseId ---- String 2. CourseName ---- String 3. TeacherName ---- String 4. college ---- String 5. number Of Student ---- int } o Student-Course Table \ this table contain a foreign key for both table “ Student and Course ” and contain data about the student who takes some courses or a courses that have number of Student { studentID --- int , foreign key from Student Table courseID --- int , foreign key from Course Table } · The Program should connect to the database and do the following operation : o Add Student o Delete Student o…
- A database for inventory and transaction of Apple store has been developed. There are three tables in this database – Inventory, Transaction, Inventory_history. You can use the following script to create the tables. create table Inventory ( itemid varchar(20) primary key, name varchar(30), price decimal(6,2), quantity int ); create table Transaction ( transid int auto_increment primary key, itemid varchar(20), quantity int, time datetime, foreign key (itemid) references Inventory(itemid) ); create table Inventory_history ( id int auto_increment primary key, itemid varchar(20), action varchar(20), oldprice decimal(6,2), time datetime, foreign key (itemid) references Inventory(itemid) ); 2) Create a trigger “change_quantity” on table “Transaction”. The trigger is fired after a row is inserted in table “Transaction”. After a row is inserted in table “Transaction”, update the “quantity” in table “Inventory”. For example, if 3 iWatch are sold, then the quantity of iWatch in table…Q1. Use the DBCA to Create a Database In this exercise, you will create a database listener (if one does not exist already) and then create a database to be called MYDB_<your name> using the DBCA, on either Windows or Linux. There is no significant difference between platforms. The illustrations that follow happen to be from Windows.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…
- You have been hired at Selianord Group (Pty)Ltd as a Junior database developer where you are going to build a desktop application called LusuFlix. This application will be used at a video rental store. We need different levels of permissions for different users in the database. The store manager should be able to add/update/delete the list of movies. They will be in charge of setting the stock for each movie as well as the daily rental rate. Cashiers should have a read-only view of the list of movies. They should be able to manage the list of customers and the movies they rent. At check out, a customer brings one or more movies. The cashier looks up a customer by their phone number. If the customer is a first-time customer, the cashier asks for their full name, email, and phone number, and then registers them in the system. The cashier then scans the movies the customer has brought to check out and records them in the system. Each movie has a 10-digit barcode printed on the cover.…In this database we have users that can be two types students or instructors. They have groups and memberships. Any user can post and the post type can be video, photo or text. Here is the table structure: CREATE TABLE USER_ ( USER_ID INT NOT NULL AUTO_INCREMENT, CREATE_DATE DATE NOT NULL, PROF_DESC VARCHAR (100), PROF_PIC VARCHAR(40), LOCATION VARCHAR (40) NOT NULL, PRIMARY KEY (USER_ID) ); CREATE TABLE USER_INFO( USER_ID INT NOT NULL, SU_EMAIL CHAR(18), USER_FNAME VARCHAR(15), USER_LNAME VARCHAR (15), USER_DOB DATE, USER_GENDER CHAR(1), PRIMARY KEY (USER_ID), FOREIGN KEY (USER_ID) REFERENCES USER_(USER_ID) ON UPDATE CASCADE ); CREATE TABLE STUDENT ( SU_ID INT NOT NULL, USER_ID INT NOT NULL, YEAR_ VARCHAR (10), MAJOR VARCHAR (20), LOCATION VARCHAR (40) NOT NULL, PRIMARY KEY (SU_ID), FOREIGN KEY (USER_ID) REFERENCES USER_(USER_ID) ON UPDATE CASCADE ); CREATE TABLE INSTRUCTOR ( SU_ID INT NOT NULL, USER_ID INT NOT NULL, DEPARTMENT VARCHAR (40), INSTR_TYPE VARCHAR (40),…In this database we have users that can be two types students or instructors. They have groups and memberships. Any user can post and the post type can be video, photo or text. Here is the table structure: CREATE TABLE USER_ ( USER_ID INT NOT NULL AUTO_INCREMENT, CREATE_DATE DATE NOT NULL, PROF_DESC VARCHAR (100), PROF_PIC VARCHAR(40), LOCATION VARCHAR (40) NOT NULL, PRIMARY KEY (USER_ID) ); CREATE TABLE USER_INFO( USER_ID INT NOT NULL, SU_EMAIL CHAR(18), USER_FNAME VARCHAR(15), USER_LNAME VARCHAR (15), USER_DOB DATE, USER_GENDER CHAR(1), PRIMARY KEY (USER_ID), FOREIGN KEY (USER_ID) REFERENCES USER_(USER_ID) ON UPDATE CASCADE ); CREATE TABLE STUDENT ( SU_ID INT NOT NULL, USER_ID INT NOT NULL, YEAR_ VARCHAR (10), MAJOR VARCHAR (20), LOCATION VARCHAR (40) NOT NULL, PRIMARY KEY (SU_ID), FOREIGN KEY (USER_ID) REFERENCES USER_(USER_ID) ON UPDATE CASCADE ); CREATE TABLE INSTRUCTOR ( SU_ID INT NOT NULL, USER_ID INT NOT NULL, DEPARTMENT VARCHAR (40), INSTR_TYPE VARCHAR (40),…
- Which should be used while creating plugins: custom post types or custom database tables?a. Load a database applicationb. Create a database labelled as MOVIE_LIBRARY in the created folder with the following fields:MovieID, Movie Name, Date Released, Movie Category, Quantity Delivered (table in image attachment) c. Save the table as tblMovies.d. Fill tblMovies with the given data as shown in 2 (b).e. Create a form for the records and name it frmMoviesf. Query the table to look out for movies released in the year 2014 and name it as qryMoviesScripts and Stored Procedures are two different types of things. What's the difference between them? Each one has a different job. Installing Stored Procedures in a database is better than other ways of doing this.