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

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

Describe the role of data caching and in-memory databases in optimizing database performance.
Explain the principles of data normalization in database design. How does normalization improve data management and querying efficiency?
Enumerate the primary responsibilities of a Database Administrator (DBA) with regards to configuration management.
Explain the significance of complex data types in a relational database management system (RDBMS).
Explain the key components of a typical database management system (DBMS).
Explain the concept of data normalization in database management. What are the advantages of using normalized data in database systems?
Explain the concept of distributed database management systems (DDBMS) and how they differ from centralized database systems.
Explain the concept of a database management system (DBMS) and its importance in modern computing.
Explain the concept of database virtualization. How does it facilitate database management in cloud environments?
Explain the purpose of database normalization. What are the benefits of a normalized database schema?
Please give an example that explains the role of a database administrator in a web database application.
explain the role of the Database Administrator (DBA) which includes: performance of a database integrity of a database security of a database planning development troubleshooting. Also create a job description for a DBA based on Book Library case-study (You need to create a job description of DBA. Link it with Library case study.) I need Reference