The writer is very fast, professional and responded to the review request fast also. Thank you.
Presentation/PPT
27/08/2022
Required for Grading (Type Your Name Below):
I am
(type your full name) and I complete this assignment following the UHD academic integrity policy.
Read Before Starting this Assignment:
· You must complete Exercise 8-1 to do this exercise.
· When in doubt, refer to and modify the SQL codes in Exercise 8-2.
· Keep in mind that the database server will NOT keep a copy of your SQL codes. The database server simply executes the commands that you send from your client (Workbench). Therefore, in Workbench, please
save your SQL codes as SQL script files (*.sql). The *.sql files will become your template for later exercises or a backup.
· Common practice is to place all create-table commands in one *.sql file and all insert-data commands in another *.sql file.
· Your answer is required when you see the red answer box like the box below.
|
Answer here: <<This is an example. Answer whenever you see this.>> |
·
You are implementing a database. The ERD is presented as the figure below. Follow the following three steps to create a database, make tables, and insert data in your MySQL database server.
Note: Required fields are noted with
Bold font.
Step 1: Create the database. (5 points)
In your MySQL database server, create and use a database for this exercise. The database should be different from the Exercise 8-2 database. Name your database as
M8EMP_YourFNameLName (replace with your first name and last name; required for grading). After refreshing the schemas, you should see your database (schema) in
bold, which means it is in use. All the later SQL statements will be sent to and executed here. Use the
Snipping or
Grab app to capture your database like the image below (certainly your database name and table names are different). Paste it as your answer.
Your database is
M8EMP_YourFNameLName
|
Answer here: Grading requirement: The image should clearly show your database name, which should be <<Paste your image here>> |
Step 2: Create Tables and Relationships. (15 points)
Create the tables and relationships depicted in the ERD. When you are writing the SQL code, ensure that if a Region_Code in REGION is changed, the Region_Code in STORE will also be updated.
After refreshing the schemas, use the Snipping or Grab app to capture your database like the image below (certainly your database name and table names are different). Your screen capture should show
your tables on the left and
your codes on the right (must clearly show the codes for the STORE and EMPLOYEE tables for grading). Paste your screenshot below.
Paste it as your answer.
This is just a demo figure, not real tables/codes for this exercise.
|
Answer here: To receive grades, your image should clearly show <<Paste your image here>> |
Step 2: Insert Data. (20 points)
Insert data
at least three rows per table. In the EMPLOYEE table, data for one of the employees should be your first name and last name (required for grading). Pay attention to the data type when inserting data.
From your schema, click the EMPLOYEE table, right click, and choose “Select Rows – Limit 1000”. Use the Snipping or Grab app to capture your table result. Paste it as your answer.
|
Answer here: To receive grades, in the EMPLOYEE table, data for one of the employees should be <<Paste your image here>> |
Congrats! End of Exercise!
16
The writer is very fast, professional and responded to the review request fast also. Thank you.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more