Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This task has 5 marks. It is about debugging an SQL code containing DDL statements for a collection of related tables. You need to follow
This task has 5 marks. It is about debugging an SQL code containing DDL statements for a collection of related tables. You need to follow ALL STEPS (From Step 1 to Step 10). You need to debug the code and fix it until all the code is executed successfully and all the tables are created. Then you will need to add one record for each table. Submit your work as described at the end of this document. Every student has to submit the task separately (No Groups allowed) In order to complete this task , you need to do the following steps: 1. Download MySQL workbench (follow the steps in the video on e-learning) 2. Create a new database schema on MySQL workbench. The name of the schema should be (your First Name _ Your Student ID). For example, if your first name is: 'Khalid' and your student ID is'01912345', then the database new will be Khalid_01912345, as shown in image below: MySQL Workbench Local instance MySQL56 x File View Date Server Tools Scripting Help OO ad Navigator Khalid 01112345 - Sche SCHEMAS had 0012345 2nd menom OwColation Default Default Colotio Thew db wam 2017 sam_0102 Ins_log Ins_jog_secon2015 marw my_new_db sakila Tables actor address con Administration Sches formation No object selected Scha 3rd Aly Revert 3. Refresh the databases on MySQL workbench and you will find the new DB as shown below: MySQL Workbench Local instance MySQL56 File Edit View Query Database Server Tools a Charset/Colle Navigator SCHEMAS Fiter objects db exams 2017 exame 2018 khalid_01912345 imelo Ims_log_second 2019 marwan my_new_db sakila Signposting test world Administration Schemas Information You will New find the 03
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