Advanced OOP Q1: Create a Database with 8 Attributes “User ID, Question, Option 1, Option 2, Option 3, Option4, Answer, Score". Select random record from database and display it on the GUI. This allow user to select the one option from the given option if the selected option is the right answer then move to next question and each user can answer at least 5 questions. And If the User pick the wrong Question a pop up shows its wrong and allow him to pick again, each user should try 3 times if it's still wrong move to the next question. You have to Save the score of each User. Question1: What is the color of an Apple. Purple :O Yellow Orange Black

Advanced OOP Q1: Create a Database with 8 Attributes “User ID, Question, Option 1, Option 2, Option 3, Option4, Answer, Score". Select random record from database and display it on the GUI. This allow user to select the one option from the given option if the selected option is the right answer then move to next question and each user can answer at least 5 questions. And If the User pick the wrong Question a pop up shows its wrong and allow him to pick again, each user should try 3 times if it's still wrong move to the next question. You have to Save the score of each User. Question1: What is the color of an Apple. Purple :O Yellow Orange Black

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Create an application that connects to the Personnel.mdf database that you created in Programming Problem 1. The application’s form should display the Employee table in a DataGridView control. The form should also have the following controls: • A button that, when clicked, sorts the data in ascending order by hourly pay rate. • A button that, when clicked, sorts the data in descending order by hourly pay rate.
Scenario and Database Model: InstantRide InstantRide is the new ride sharing application in the city and it has just started its operations. With the help of the InstantRide mobile application, the users request a ride with their location. Drivers and cars are assigned to the request; and then the driver picks up the user to ride their requested location. Information for the users, drivers and cars are stored in the database as well as the travel transactions. In the USERS table, information for the users are stored with their first name, last name and email: In the DRIVERS table, all the drivers in the InstantRide are stored with their name, driving license number and check and rating information: In the CARS table, all the cars in the InstantRide system are kept with the license plate, model and year: Finally, the transactions of the rides are stored in the TRAVELS table. For each travel, start and end time with location are stored. In addition, the involved driver, car and…
In the following pseudocode of creating a trigger, the first UPDATE is the ____ of the trigger, and the second UPDATE is the ____ of the trigger. CREATE TRIGGER MyTrigger AFTER UPDATE OF attr ON MyTable ... WHEN ... UPDATE MyTable .... Group of answer choices Action; action Condition; action Event; action Event; condition
Assignment Two: We will write three procedures on our tables, the first of which I have provided as an example. proclnsertPlayer takes one IN VARCHAR(16) paramater and returns an error code in the second SMALLINT (INOUT) parameter. The procedure checks the parameter and, if there are no errors, inserts the value into tblPlayers. Documentation of errors Condition Error code No errors 1st param Null or zero len playerID taken 1 proclnsertGame will receive two IN VARCHAR(16) interpreted as
Assignment Create a database in Access. In the database include the following tables: • Student info which has the following fields o First Name o Last Name o StudentID (primary key) • Courses table which includes the following fields: o CourselD (primary key) o Course Name o CRN • Schedule which contains the following fields: o StudentID o CourselD Create the proper relationships between the tables. Fill the tables with at least 5 students and 2 different classes. You can generate the data randomly by using the Mockaroo site Or you can review Extra Material for more links on how to generate random data Create a report to print out the course and the names of the students taking that course (so group by course). Make sure the report is well formatted, looks professional, include a professional header and a footer.
class Database:def __init__(self, db_name):self.db = sqlite3.connect(db_name)self.cursor = self.db.cursor()def create_table(self, table_schema):self.cursor.execute(table_schema)self.db.commit()def insert_data(self, table_name, data):for i in range(len(data)):keys = ", ".join(data.columns)values = ", ".join([f"'{value}'" if pd.isna(value) else str(value) for value in data.iloc[i]])self.cursor.execute(f"INSERT INTO {table_name} ({keys}) VALUES ({values})")self.db.commit()def search_data(self, table_name, year):self.cursor.execute(f"SELECT * FROM {table_name} WHERE year={year}")result = self.cursor.fetchone()if result is not None:return resultelse:return Nonedef delete_data(self, table_name, year):self.cursor.execute(f"DELETE FROM {table_name} WHERE year={year}")self.db.commit()return self.cursor.rowcount > 0 Please rewrite (or convert) the code above with format: def QueryBuilder( Data_Base, Query_Type, Query_Tuple):'''''' Build Query_String'''''' return Query_String
JavaFX program Create a JavaFX GUI that allows the user to retrieve records from the product table in the example database. The GUI should allow the user to specify desired fields, desired order, and a where condition. Display only the desired fields in the desired order for the desired where condition.You may display the records in the GUI in any way you wish. database below
SQL Injection Challenge 5 If you can buy trolls for free you'll receive the key for this level! Super Meme Shopping Hey customers: Due to a shipping mistake we are completely over stocked in rage Memes. Use the coupon code Please TakeARage or RageMemeForFree to get yours for free!!!. Picture Cost Quantity $45 $15 NOT BAD $3000 0 E $30 Please select how many things you would like to buy and click submit Coupon Code: Place Order
When the Search button is pressed in the screen depicted, the getSales() function from the PosDAO.java class is called, the parameters of this function are the from date and to date.The getSales () function should return a list of Pos objects that matches the criteria specified, Note this function has to perform two INNER JOINs in to combine all three tables in order to get all the needed data to fill the Pos object. The database schema is also depicted. The PosDAO, Product, SalesDetails and Pos classes are shown BELOW Write the getSales() function public class PosDAO { private Connection conn; PreparedStatement stmt = null; public boolean openConnection(){ try { // db parameters String url = "jdbc:mysql://localhost:4306/swen2005"; String user = "root"; String password = ""; // create a connection to the database conn = DriverManager.getConnection(url, user, password); if (conn!= null){ return true;…
import sqlite3 from sqlite3 import Error # Creates connection to sqlite in-memory database def create_connection(): """ Create a connection to in-memory database :return: Connection object """ try: conn = sqlite3.connect(":memory:") return conn except Error as e: print(e) # YOUR CODE HERE # Use sqlite3.connect(":memory:") to create connection object return conn # query to create the table table_sql = """ CREATE TABLE Horses ( id integer PRIMARY KEY NOT NULL, name text, breed text, height real, birthday text ); """ # query to insert data into the table ins_sql = """INSERT INTO Horses VALUES(1,'Babe','Quarter Horse',15.3,'2015-02-10'); """ # query to fetch all data from the table fetch_sql = """SELECT * FROM Horses;""" # creating db connection conn = create_connection() # fetching a cursor from the connection c = conn.cursor() # executing statement to create table c.execute(table_sql) # executing statement to…
Will be using code Lginter! Registration First Name Last Name Email Address Password Confirm Password Require to have validation of user input Valid email address Make sure the email address does not exist in the database before doing insert into the database Password and Confirm Password are matching Password need to hash before doing insert into database ("password_hash" is a PHP build in function which can be used)
response page checks username and password against arrays of valid usernames and passwords (normally this is done against a database - we'll change it later) If valid - saves username to cookie, and sets session variable LoggedIn to TRUE. If not, sets the session variable to FALSE. Displays link to "content page" (the page you're protecting). Created with Mi Notes