Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Type the following SQL CREATE DATABASE ` [ username ] _ simpleDB ` Replace [ username ] with your username ( do not

Type the following SQL
CREATE DATABASE `[username]_simpleDB`
Replace "[username]" with your username (do not include the square brackets in the SQL -- for example, if your username is user7428, then teh query would be "CREATE DATABASE `user7428_simpleDB`")
Execute the SQL - you should get a response that the SQL was executed but that there was no result
Update the "Database" field to "[username]_simpleDB"
Execute the following SQL
CREATE TABLE `config`(
`config_key` varchar(8) NOT NULL PRIMARY KEY,
`config_value` varchar(32) NOT NULL,
`config_lastChange` date NOT NULL,
`config_userChange` int(11) NOT NULL
)
Execute the following SQL
INSERT INTO `config` VALUES
('theme', 'dark', '2023-01-01',1),
('backup','monthly',CURRENT_DATE,1)
Execute the following SQL
SELECT *
FROM `config`
WHERE
`config_key`='backup'
Looking at the results, notice how the "config_lastChange" value reflects the date you executed the query, attempt to explain why you think this may have happened (you will be graded on your attempt at figuring it out, not on the correctness of your guess)
Click on the button "Show History", select the queries that you executed for this lab. If there was a query that did not work the way you expected, and you made changes and ran it again, only include the one that you want as part of the grading.
On the next screen, you will be prompted for a name for this collection of queries, and provided an opportunity to add commentary to each of the queries. You can use this commentary space to explain how you developed the query (in future labs) or answer other questions (for example, the last query)
Click "Save Collection" - this should prompt a download window. As long as you do not recieve an error message, you should always be able to find your saved query collections via the "Show Collections" button

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Focus On Geodatabases In ArcGIS Pro

Authors: David W. Allen

1st Edition

1589484452, 978-1589484450

More Books

Students also viewed these Databases questions

Question

Differentiate between a data warehouse and an operational database.

Answered: 1 week ago