SUBJECT/TOPIC: MySQL Database Management System (xampp)PLEASE ANSWER THIS WITH COMPLETE EXPLANATION AND SOLUTION. ASSESSMENT TASK MySQL Database Management System (xampp) 1. You are creating a database named NewDB. The database uses the server'sdefault character. What SQL statement should you use to create the database?2. You are creating a table in a MYSQL database from previous number. The table isnamed Bikes and includes two columns: BikelD and BikeName. The BikelDcolumn must uniquely identify each row in the table, and values must beautomatically assigned to each row. The BikeName column must include adescriptive name for each model of bike. The names vary in length but shouldnever exceed 40 characters. What SQL statement should you use to create thetable?3. Write a SQL statement to insert the given data into the table countries against eachcolumn.IdCountry1 Malaysia2Thailand3Mongolia4Georgia5Turkmenistan956 Philippines7IsraelHere in the following is the structure of the table "countries".| Field1 Туре| Null | Key | Default | Extra || COUNTRY_IDCOUNTRY_NAME | varchar(40)| varchar(2)| VES IYES |NULLNULL 1. You are creating a SELECT statement that retrieves data from the CDstable. Your query results should include values from the CDName, InStock,OnOrder, and Reserved columns. In addition, the results should include allrows in the table. What SELECT statement should you create?2. You want to modify the SELECT staternent that you created in AssessmentNo. 1 so that the result set includes an additional column. The columnshould add the values of the InStock and OnOrder columns and thensubtract the value in the Reserved column. You want to assign the Totalalias to the new column. What SELECT statement should you create?3. Your next step is to modify the SELECT statement that you created inAssessment No. 2. You plan to limit the rows returned to those rows that121have a Department value of Classical and an InStock value less than 20.What SELECT statement should you create?4. You now want to create a SELECT statement that summarizes data in theCDs table. The result set should include data that is grouped together bythe Department column and then by the Category column. The summaryinformation should include the number of rows for each category, as well astotals for all categories in each department. In addition, the summarycolumn in the result set should be assigned the alias Total, and all groupedcolumns should be sorted in ascending order. What SELECT statementshould you create?5. You now want to modify the SELECT statement that you created inAssessment No. 4 to limit the rows returned to those with a Total value lessthan 3. What SELECT statement should you create?6. You are creating a SELECT statement that retrieves data from the CDstable. Your query results should include values from the CDName column.The values should be sorted in descending order. What SELECT statementshould you create?

Kindly Note: As per our company guidelines we are supposed to answer only first 3 sub-parts. Kindly…

1. You are creating a database named NewDB. The database uses the server's default character. What SQL statement should you use to create the database? 2. You are creating a table in a MYSQL database from previous number. The table is named Bikes and includes two columns: BikelD and BikeName. The BikelD column must uniquely identify each row in the table, and values must be automatically assigned to each row. The BikeName column must include a descriptive name for each model of bike. The names vary in length but should never exceed 40 characters. What SQL statement should you use to create the table? 3. Write a SQL statement to insert the given data into the table countries against each column. Id Country Malaysia 1 2 Thailand 3 Mongolia Georgia Turkmenistan 4 5 6 Philippines 7 Israel Here in the following is the structure of the table "countries". | Field I Type | Null | Key | Default | Extra | | COUNTRY_ID | COUNTRY_NAME | varchar(40) | VES I | VES I varchar(2) | MULL NULL

1. You are creating a database named NewDB. The database uses the server's default character. What SQL statement should you use to create the database? 2. You are creating a table in a MYSQL database from previous number. The table is named Bikes and includes two columns: BikelD and BikeName. The BikelD column must uniquely identify each row in the table, and values must be automatically assigned to each row. The BikeName column must include a descriptive name for each model of bike. The names vary in length but should never exceed 40 characters. What SQL statement should you use to create the table? 3. Write a SQL statement to insert the given data into the table countries against each column. Id Country Malaysia 1 2 Thailand 3 Mongolia Georgia Turkmenistan 4 5 6 Philippines 7 Israel Here in the following is the structure of the table "countries". | Field I Type | Null | Key | Default | Extra | | COUNTRY_ID | COUNTRY_NAME | varchar(40) | VES I | VES I varchar(2) | MULL NULL

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter11: Sql Server Databases

Section: Chapter Questions

Problem 10E

See similar textbooks

Similar questions

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.
Which of the following is a correct statement? a. A commit is issued implicitly when a user exits SQL Developer or SQLPlus. b. A commit is issued implicitly when a DDL command is executed. c. A commit is issued automatically when a DML command is executed. d. All of the above are correct. e. Both a and b are correct. f. Both a and c are correct.
create a SQLITE database or use an existing database and create a table in the database called "Ages": CREATE TABLE Ages ( name VARCHAR(128), age INTEGER ) Then make sure the table is empty by deleting any rows that you previously inserted, and insert these rows and only these rows with the following commands: DELETE FROM Ages; INSERT INTO Ages (name, age) VALUES ('Darrius', 17); INSERT INTO Ages (name, age) VALUES ('Dustin', 25); INSERT INTO Ages (name, age) VALUES ('Aibidh', 24); INSERT INTO Ages (name, age) VALUES ('Baron', 33); INSERT INTO Ages (name, age) VALUES ('Kayden', 33); Once the inserts are done, run the following SQL command:SELECT hex(name || age) AS X FROM Ages ORDER BY X Find the first row in the resulting record set and enter the long string that looks like 53656C696E613333. Note: This assignment must be done using SQLite - in particular, the SELECT query above will not work in any other database. So you cannot use MySQL or Oracle for this assignment.
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'show database CREATE DATABASE [Da]USE PETSTORE' at line 3mysql> use petstoreERROR 1049 (42000): Unknown database 'petstore'mysql> create database [da] -> use petstore -> -> CREATE TABLE USERS (user_id VARCHAR(30), password -> VARCHAR(30), first_name VARCHAR(50), last_name VARCHAR(50));ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[da] ========== whats the wrong with this work , what code is correct when i ma trying to make a new table and a new databse in this mysql commend line ?
Database course: a. Write in SQL a command that creates the table Customers according to the above description. b. Write in SQL a statement that adds a new column named accountID of type Char(8). This column should be defined as a foreign key that relates the table Customers to the table Account. c. Write in SQL a command that deletes the customers whose date of birth is after 22-Dec-1990. d. Write a SQL query that displays the number of customers who born on the 16th day of a month. e. Write in SQL a query that displays the ids of the customers who have the highest income. f. Create a view named ‘customerDetails’ to hold all the details of customers whose first names start with ‘S’ and their incomes are between 500 and 1000 Omani Rials. (I need the codes to copy them please) Photo is there.
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..
Answer the following prompts 1The InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the InstantRide system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENANCE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30)) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team. 2The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENANCE_TYPE_ID…
Q1.) An integrity constraint is a rule that: a. is kept in an external file b. must be followed by data in the database c. can be accessed by authorized users d. can unintentionally be accessed by unauthorized users Q2. __ is a property that lets you change the structure of the database without requiring you to change the programs that access the database. a. Database design b. Data independence c. Integrity constraint d. Data dependence Q3. The basic form of an SQL retrieval command is: a. SELECT-WHERE-FROM b. CREATE-SELECT-FROM c. SELECT-WHERE d. SELECT-FROM-WHERE Q4. Which of the following queries will list the number, name, credit limit, and balance for all customers with credit limits that exceed their balances. a. SELECT CustomerNum, CustomerName FROM Customer WHERE CreditLimit>Balance ; b. SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance ; c. SELECT…
Assistance with SQL statements Previous code; CREATE TABLE Lab4program_piershed ( code VARCHAR(5) PRIMARY KEY, name VARCHAR(20), tel VARCHAR(20));CREATE TABLE Lab4course_xxxx ( cid INT PRIMARY KEY, name VARCHAR(20), credits INT, mycode VARCHAR(5), FOREIGN KEY (mycode) REFERENCES Lab4program_xxxx(code)); 1. Insert 3 records into your Lab4program_xxxx table. The code should be "CPS", "TECH", "MATH", or "BIO". Please copy/paste your SQL statements with the output message in the text that shows you successfully insert 3 records to your table. 2. Insert 4 records into your Lab4course_xxxx table with at least 2 different mycode. Please copy/paste your SQL statements with the output message in the text that shows you successfully insert 4 records to your table.
The relational schema shown below is part of a hospital database. The primary and foreign keys are highlighted in bold. Patient (patientNo, patName, patAddr, DOB)Ward (wardNo, wardName, wardType, noOfBeds)Admission (patientNo, wardNo, admissionDate)Drug (drugNo, drugName, costPerUnit)Prescribed (patientNo, drugNo, unitsPerDay, startDate, finishDate) Write SQL queries based on the hospital database given above: 1. Create the above tables together with its constraints. 2. Insert some data into the tables to check that the tables created are correct. No limit on how many rows you want to add. Insert Syntax:insert into table_namevalues (col1_value, col2_value, etc.); 3. List all the patients’ details, alphabetically by name. IF YOU WANT SOME CHALLENGE4. List all the patients admitted today. (Join between Patient and Admission table)
Write in SQL a command that creates the table Customers according to the above description. Write in SQL a statement that adds a new column named accountID of type Char(8). This column should be defined as a foreign key that relates the table Customers to the table Account . Write in SQL a command that deletes the customers whose date of birth is after 22-Dec-1990 .
You are required to create the following tables in a database named STUDENT_REGISTRATIONS. Ensure that you create the database and table objects exactly as depicted below.STUDENTSSTUDENT_ID VARCHAR(8) NOT NULL PRIMARY KEYSTUDENT_NAME VARCHAR(40) NOT NULLSTUDENT_SURNAME VARCHAR(40) NOT NULLMODULESMODULE_ID VARCHAR(8) NOT NULL PRIMARY KEYMODULE_NAME VARCHAR(40) NOT NULLMODULE_CREDIT SMALLINT NOT NULLSTUDENT_MODULESSTUDENT_ID VARCHAR(8) NOT NULL PRIMARY KEYFOREIGN KEY REFERENCES STUDENTS(STUDENT_ID)MODULE_ID VARCHAR(8) NOT NULL PRIMARY KEYFOREIGN KEY REFERENCES MODULES(MODULE_ID)LECTURERSLECTURER_ID VARCHAR(8) NOT NULL PRIMARY KEYLECTURER_NAME VARCHAR(40) NOT NULLLECTURER_SURNAME VARCHAR(40) NOT NULL LECTURER_MODULESMODULE_ID VARCHAR(8) NOT NULL PRIMARY KEYFOREIGN KEY REFERENCES MODULES(MODULE_ID)LECTURER_ID VARCHAR(8) NOT NULL PRIMARY KEYFOREIGN KEY REFERENCES