Which of the following operation will not be allowed on the following table if it is stored in a key-value database? STAR StarlD Starname Fees S1 Shahrukh 5000 S2 Salman 8000 S3 Aamir 10000
Q: Q1\ if your database has the nformation in figure below make the database easy to update and…
A: The table is not normalized as some cells are holding multiple values. Break the tables to…
Q: Oracle Database 18c XE comes with a sample database user named HR. This user owns several database…
A: SQL*PLUS is an batch query tool .It is a command-line user interface, a Windows Graphical User…
Q: 5. Which of the following shortcut is used for displaying error list in SQL server Management…
A: Question 5. Which of the following shortcut is used for displaying error list in SQL server…
Q: Create the database that includes the following tables: Doctor : Phone# (int) Name (Varchar)…
A: Answer: I have written SQL query and also I have attached SQL query and screen shot
Q: Which SQL Command is used to delete a table from the database: a) Update b) Alter c) Drop d) Şelect
A: Update Command is used to update the value in a table. Alter command is used to change the value in…
Q: When working with an Oracle database, which of the following is considered an | advantage of PL/SQL?…
A: When working with an Oracle database,an advantage of PL/SQL
Q: Is this statement true or false? The term "null" refers to a column in a database table that does…
A: Given: Is this statement correct or incorrect? The term "null" refers to a column in a database…
Q: Which type of database constraint does the following trigger implement? a.Key constraint b.Dynamic…
A: Summary: We need to identify the type of database constraint that will implement the given trigger.
Q: if your database has the information in figure below make the database easy to update and modified…
A: The given database in the figure has been normalized up-to third normal form (3NF) by applying a…
Q: |1. which one(s) of the following change(s) the name of a database? a) sp_rename d) alter name c)…
A: (Q1)a and cit changes the namer of the database. (Q2) A,B&D these are the attributes which are…
Q: Using MongoDb do the following activities Create database named First. Create a collection named…
A: 1. use First 2. db.createCollection("dbase6211")
Q: Which of the following is false? a. You can use a query to retrieve specific information from a…
A: Explanation: One can use a query when a database has more than one table. It also possible to get…
Q: List the names of any pair of boats that have the same type. For example, one pair would be Anderson…
A: The Question is of DBMS SQL query in which we have to find out the solution by using a query. A…
Q: Google manages its ongoing invoices and payments using the following database table. Does it confirm…
A: Step 1:- Given:- PaymentID Pay_Amount InvoiceNo DueDate AmountDue Late HD590…
Q: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your…
A: Please refer to the following step for the complete solution of the problem above.
Q: Assume you have StudentsDB database stored in MYSQL server that contains the following 2 tables as…
A: 1. Displaying file upload form to upload multiple imagesusing form multipart attribute in the form…
Q: QUESTION : 1. Write a PL/SQL PROCEDURE that will list the project names given the course ID.…
A: --Following is the code as required. Compile the procedure first and then execute the anonymous…
Q: dd a DISTINCT clause that will remove duplicate entries from the customer_id column. NOTE: The…
A: given - You are working with a database table that contains invoice data. The table includes columns…
Q: A select operation in a relational database is used to cut down on the size of a table by deleting…
A: Given: In a relational database, a select operation is used to reduce the size of a table by…
Q: Oracle Database with code and output on update,delete and insert code of trigger i need it on…
A: Here , CUSTOMERS table we had created : Select * from customers;…
Q: University of Bahrain Information Technology College Computer Science Department ITCS 333 –…
A: have made files upload. php record with every one of the modules you ask in the question. Content…
Q: The best representation of the STAFF table below in the Document oriented databases will be? StaffNo…
A: All the values are to be assigned with the keys and later these are to separated with commas. That…
Q: Which of the following is the correct definition of alias in SQL statement? a. It is a way of…
A: Explanation SQL aliases are used to give a temporary name to table or column. they are used to make…
Q: ) Create a database called cars that has these tables or write the SQL command to create the…
A: Create database: CREATE DATABASE cars; Create tables: Car: CREATE TABLE Car(car_ID int PRIMARY…
Q: The below ERD has been implemented in a SQL database. What will the result be of each of the below…
A: INSERT is a keyword used in SQL to insert a record into the table
Q: 2. Which of the following will allow you to remove your table in the database? A. DELETE FROM…
A: To remove a table we use the DROP TABLE directive. So the correct way is DROP TABLE tableneme;…
Q: Try these commands and comment the role for each command. 1) SQL> conn sys as sysdba Password :…
A: Given 10 SQL commands and these have their own role and perform different action. 1) conn sys as…
Q: The following database will be used in this question: SALESREP SalesRepNo 654 734 345 434 RepName…
A: MySQL code for the CUSTOMER table: CREATE TABLE CUSTOMER(CustNo integer PRIMARY KEY, CustName text,…
Q: Consider the information below and then answer the following questions. Database Name: DEdb Table…
A: 1. CREATE DATABASE DEdb; 2. CREATE TABLE Department(DepId int unsigned not null,DepName…
Q: Write SQL retrieval commands for each of the following queries:a. Display the course ID and course…
A: You didn't provide any tables for query, So I am assume the name of tables and its attributes…
Q: Refer the given table and answer the question that follow: TABLE : CLIENT Client no Client_Name…
A: Given, Two tables: Client Client_details
Q: Which of the following is correct? (refer to the tables in the JustLee Books database.)a. A group…
A: Group function Group functions are built-in SQL functions that operate on groups of rows and return…
Q: Problem: JMS TechWizards is a local company that provides technical services to several small…
A: Note: - As per our guidelines we can only answer one question at a time. Please resubmit the other…
Q: Which one of the following is not a property of Transactions? a) Atomic…
A: Note: We are only allowed to provide 1 answer in one post. please post only one question in one post…
Q: Which SQL Command is used to delete a cable from the database: a) Update 5) Alter =) Drop H) Select
A: Update Command is used to update the value in a table. Alter command is used to change the value in…
Q: 1.Which keyword is used to create a database? 2.The file created by the server to bu
A: 1. CREATE DATABASE is used to to create a database for example CREATE DATABASE Rajnish; Rajnish…
Q: 2 Write a SQL Command to Insert the records in the following tables CUSTOMER88 TABLE: CUST ID CUST…
A: INSERT INTO CUSTOMER88 VALUES(80001,"SUHAIL","HEADACHE","13-JAN-2018",250.000,93523655);INSERT INTO…
Q: Using MySQL workbench to create a database with six tables. You need to set up primary key and…
A: Select this option to generate a statement to drop each object before the statement that creates it.…
Q: The database should contain the following six tables:
A: Solution:
Q: datebase name: gazidata.dbo ogrenciler table: tcno(varchar(50))/primary key, adisoyadi(varchar(50)),…
A: CREATE DATABASE gazidata CREATE TABLE ogrenciler ( tcno varchar(50) PRIMARY KEY, adisoyadi…
Q: Given the Bank database that contains the following tables (primary keys are underlined and foreign…
A: DECLARE c_Number Client.clientNumber%TYPE; c_FName Client.firstName%TYPE; c_LName…
Q: write SQL commands to create tables of a Bank database, where these tables will have the following…
A: Create a table in the bank database using the below-mentioned schema.
Q: 10. Insert the following records to BOOKS table: BookID Category Title Price Writer 1 IT SQL 50…
A: Solution : Here, in BOOKS table there 5 columns. The books details are shown in table. In above…
Q: me Data type Constraint AuthorID Integer, auto-increment Primary key Name Up to 40 characters…
A: Use phpmyadmin to create a MySQL database called “library” that contains the following tables:…
Q: write SQL commands to create tables of a Bank database, where these tables will have the following…
A: HI THEREI AM ADDING SQL COMMAND BELOW TO CREATE GIVEN SCHEMA PLEASE GO THROUGH ITTHANK YOU
Step by step
Solved in 2 steps
- create database GA2gouse GA2gocreate table salesman(salesman_id int primary key, name varchar(30), city varchar(20), commission varchar(30));insert into salesman (salesman_id, name, city, commission) values (5001, 'James Hoog', 'New York', 0.15); insert into salesman (salesman_id, name, city, commission) values (5002, 'Nail Knite', 'Paris', 0.13); insert into salesman (salesman_id, name, city, commission) values (5005, 'Pit Alex', 'London', 0.11); insert into salesman (salesman_id, name, city, commission) values (5006, 'Mc Lyon', 'Paris', 0.14); insert into salesman (salesman_id, name, city, commission) values (5007, 'Paul Adam', 'Rome', 0.13); insert into salesman (salesman_id, name, city, commission) values (5003, 'Lauson Hen', 'San Jose', 0.12); Create table Customer (customer_id int primary key, cust_name varchar(30), city varchar(10), grade varchar(30), salesman_id int,CONSTRAINT FK_salesman_id FOREIGN KEY (salesman_id) REFERENCES salesman(salesman_id));insert into customer…create database GA2gouse GA2gocreate table salesman(salesman_id int primary key, name varchar(30), city varchar(20), commission varchar(30));insert into salesman (salesman_id, name, city, commission) values (5001, 'James Hoog', 'New York', 0.15); insert into salesman (salesman_id, name, city, commission) values (5002, 'Nail Knite', 'Paris', 0.13); insert into salesman (salesman_id, name, city, commission) values (5005, 'Pit Alex', 'London', 0.11); insert into salesman (salesman_id, name, city, commission) values (5006, 'Mc Lyon', 'Paris', 0.14); insert into salesman (salesman_id, name, city, commission) values (5007, 'Paul Adam', 'Rome', 0.13); insert into salesman (salesman_id, name, city, commission) values (5003, 'Lauson Hen', 'San Jose', 0.12); Create table Customer (customer_id int primary key, cust_name varchar(30), city varchar(10), grade varchar(30), salesman_id varchar(30),CONSTRAINT FK_salesman_id FOREIGN KEY (salesman_id) REFERENCES salesman(salesman_id)); i keep getting…create database GA2gouse GA2gocreate table salesman(salesman_id int primary key, name varchar(30), city varchar(20), commission varchar(30));insert into salesman (salesman_id, name, city, commission) values (5001, 'James Hoog', 'New York', 0.15); insert into salesman (salesman_id, name, city, commission) values (5002, 'Nail Knite', 'Paris', 0.13); insert into salesman (salesman_id, name, city, commission) values (5005, 'Pit Alex', 'London', 0.11); insert into salesman (salesman_id, name, city, commission) values (5006, 'Mc Lyon', 'Paris', 0.14); insert into salesman (salesman_id, name, city, commission) values (5007, 'Paul Adam', 'Rome', 0.13); insert into salesman (salesman_id, name, city, commission) values (5003, 'Lauson Hen', 'San Jose', 0.12); Create table Customer (customer_id int primary key, cust_name varchar(30), city varchar(10), grade varchar(30), salesman_id int,CONSTRAINT FK_salesman_id FOREIGN KEY (salesman_id) REFERENCES salesman(salesman_id));insert into customer…
- create database GA2gouse GA2gocreate table salesman(salesman_id int primary key, name varchar(30), city varchar(20), commission varchar(30));insert into salesman (salesman_id, name, city, commission) values (5001, 'James Hoog', 'New York', 0.15); insert into salesman (salesman_id, name, city, commission) values (5002, 'Nail Knite', 'Paris', 0.13); insert into salesman (salesman_id, name, city, commission) values (5005, 'Pit Alex', 'London', 0.11); insert into salesman (salesman_id, name, city, commission) values (5006, 'Mc Lyon', 'Paris', 0.14); insert into salesman (salesman_id, name, city, commission) values (5007, 'Paul Adam', 'Rome', 0.13); insert into salesman (salesman_id, name, city, commission) values (5003, 'Lauson Hen', 'San Jose', 0.12); Create table Customer (customer_id int primary key, cust_name varchar(30), city varchar(10), grade varchar(30), salesman_id varchar(30),CONSTRAINT FK_salesman_id FOREIGN KEY (salesman) REFERENCES salesman(salesman_id)); i keep getting this…create database GA2gouse GA2gocreate table salesman(salesman_id int primary key, name varchar(30), city varchar(20), commission varchar(30));insert into salesman (salesman_id, name, city, commission) values (5001, 'James Hoog', 'New York', 0.15); insert into salesman (salesman_id, name, city, commission) values (5002, 'Nail Knite', 'Paris', 0.13); insert into salesman (salesman_id, name, city, commission) values (5005, 'Pit Alex', 'London', 0.11); insert into salesman (salesman_id, name, city, commission) values (5006, 'Mc Lyon', 'Paris', 0.14); insert into salesman (salesman_id, name, city, commission) values (5007, 'Paul Adam', 'Rome', 0.13); insert into salesman (salesman_id, name, city, commission) values (5003, 'Lauson Hen', 'San Jose', 0.12); Create table Customer (customer_id int primary key, cust_name varchar(30), city varchar(10), grade varchar(30), salesman_id int,CONSTRAINT FK_salesman_id FOREIGN KEY (salesman_id) REFERENCES salesman(salesman_id));insert into customer…create database GA2gouse GA2gocreate table salesman(salesman_id int primary key, name varchar(30), city varchar(20), commission varchar(30));insert into salesman (salesman_id, name, city, commission) values (5001, 'James Hoog', 'New York', 0.15); insert into salesman (salesman_id, name, city, commission) values (5002, 'Nail Knite', 'Paris', 0.13); insert into salesman (salesman_id, name, city, commission) values (5005, 'Pit Alex', 'London', 0.11); insert into salesman (salesman_id, name, city, commission) values (5006, 'Mc Lyon', 'Paris', 0.14); insert into salesman (salesman_id, name, city, commission) values (5007, 'Paul Adam', 'Rome', 0.13); insert into salesman (salesman_id, name, city, commission) values (5003, 'Lauson Hen', 'San Jose', 0.12); Create table Customer (customer_id int primary key, cust_name varchar(30), city varchar(10), grade varchar(30), salesman_id int,CONSTRAINT FK_salesman_id FOREIGN KEY (salesman_id) REFERENCES salesman(salesman_id));insert into customer…
- Computer Science Write a script that creates four login IDs based on the contents of a new table named NewLogins: CREATE TABLE NewLogins (LoginName varchar(128)); INSERT NewLogins VALUES ('BBrown'), ('CChaplin'), ('DDyer'), ('EEbbers'); Use dynamic SQL and a cursor to perform four actions for each row in this table: (1) create a login with a temporary password that's based on the first four letters of the login name followed by “99999”; (2) set the default database to the AP database; (3) create a user for the login with the same name as the login; and (4) assign the user to the PaymentEntry role you created in exercise 1..CREATE TABLE MOVIE( mov_id int NOT NULL, mov_title varchar(255) NOT NULL, mov_releaseDate date, gen_id int NOT NULL, PRIMARY KEY (mov_id), FOREIGN KEY (gen_id) REFERENCES GENRE(gen_id) ); CREATE TABLE GENRE( gen_id int NOT NULL, PRIMARY KEY (gen_id), gen_name varchar(255) NOT NULL ); Search movies by year. Using the tables above, create a stored procedure, called getMovieByYear, that, given a year, returns all the movies which were released in that year. It displays the movie title, movie’s genre name, and release year.please use MySQL Workbench with screenshots of it for the explanation.CREATE TABLE MOVIE( mov_id int NOT NULL, mov_title varchar(255) NOT NULL, mov_releaseDate date, gen_id int NOT NULL, PRIMARY KEY (mov_id), FOREIGN KEY (gen_id) REFERENCES GENRE(gen_id) ); CREATE TABLE GENRE( gen_id int NOT NULL, PRIMARY KEY (gen_id), gen_name varchar(255) NOT NULL );Search movies by year. Using the tables above, create a stored procedure, called getMovieByYear, that, given a year, returns all the movies which were released in that year. It displays the movie title, movie’s genre name, and release year.
- MC 2 . Write an Anonymous PL/SQL block that will insert five records into the database; the records must include the "jpeg" binary files that contains the photographs associated with each record. One technique would be, Create BFILE locators for each of the image files Create 5 INSERT statements into the table CREATE TABLE StudentRecord ( FirstName VARCHAR2 (20) NOT NULL, LastName VARCHAR2 (40) NOT NULL, HomeworkAvg NUMBER(10,2), AttendanceAvg NUMBER (20,2), ExamAvg NUMBER (10,2), StudentID VARCHAR2 (10),Create table Medicine (MInventory_Id int primary key, M_Name varchar (40), Manufacturer varchar (40), Price varchar (20), Quantity int, Exp_Date date); Create table PrescriptionMedicine (Prescription_Id int primary key, MInventory_Id int); Example of a table (Medicine) Insert into Medicine values(101, ‘Biaxin’, ‘Pfizers’, ‘$10.99’, 1, 10/5/02); Insert into Medicine{ String str = tf5.getInt("ID"); Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); Connection con = DriverManager.getConnection("jdbc:sqlserver://NOMBUSO1806:1433;databaseName= Employee ATM", "NOMBUSO1806", "mysql1234"); // write your database username and password PreparedStatement st = con.prepareStatement("select * from Employees where ID=?"); // Search with ATM ID st.setString(1, str); ResultSet rs = st.executeQuery(); // Excuting Query if (rs.next()) { String s = rs.getString(1); String s1 = rs.getString(2); String s2 = rs.getString(3); // Sets Records in TextFields. tf1.setText(s); tf2.setText(s1); tf3.setText(s2); my getInt() is throwing an error that the method is not found. what should i do?