Answered step by step
Verified Expert Solution
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 usernamesimpleDB
Replace username with your username do not include the square brackets in the SQL for example, if your username is user then teh query would be "CREATE DATABASE usersimpleDB
Execute the SQL you should get a response that the SQL was executed but that there was no result
Update the "Database" field to usernamesimpleDB"
Execute the following SQL
CREATE TABLE config
configkey varchar NOT NULL PRIMARY KEY,
configvalue varchar NOT NULL,
configlastChange date NOT NULL,
configuserChange int NOT NULL
Execute the following SQL
INSERT INTO config VALUES
theme 'dark',
backup'monthly',CURRENTDATE,
Execute the following SQL
SELECT
FROM config
WHERE
configkey'backup'
Looking at the results, notice how the "configlastChange" 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started