ERD Model Based on the specification received create an ERD in MySQL Workbench. Sign the ERD by
Fantastic news! We've Found the answer you've been seeking!
Question:
- ERD Model
- Based on the specification received create an ERD in MySQL Workbench.
- Sign the ERD by writing your name in a text object.
- Take a picture of your ERD.
- Include in the report file the following:
- A heading: Task 1 - ERD Model
- The signed screenshot(s) (image) of the ERD
- Task 2 - Create a database
- Start writing the SQL script in MySQL Workbench to perform the following operations:
- Include a comment: Task 2 Create a database by ... (your name)
- If there is a database with the provided name, delete that database.
- Add a database with that name.
- Mark the created database as the default database for the following operations.
- Show all the databases, find the created one in the list
- Execute and debug the script in MySQL Workbench until runs without error and performs the above operations.
- Include in the report file the following:
- A heading: Task 2 - Create database
- A screenshot (image) of the source code for this task only (crop the image if necessary) - top of the screen
- A screenshot (image) of the results for the performed operations - bottom of the screen
- Start writing the SQL script in MySQL Workbench to perform the following operations:
- Task 3 - Create tables
- Continue writing the SQL script in MySQL Workbench, adding the following operations:
- Include a comment: Task 3 - Create tables by ... (your name)
- List all the tables in the database (no table expected).
- Create the tables with the required specification.
- List all the tables in the database (again - the new table must appear).
- Show the structure of the created tables.
- Execute and debug the script in MySQL Workbench until runs without error and performs the above operations.
- Include in the report file the following:
- A heading: Task 3 - Create tables
- A screenshot (image) of the source code for this task only (crop the image if necessary) - top of the screen
- A screenshot (image) of the results for the performed operations - bottom of the screen
- Screenshots with the generated tables by the above commands, included in the order of the commands- middle of the screen in different tabs
- Continue writing the SQL script in MySQL Workbench, adding the following operations:
- Task 4 - Add data
- Continue writing the SQL script in MySQL Workbench, adding the following operations:
- Include a comment: Task 4 - Add data by ... (your name)
- Show all the data in your tables (no data expected).
- Add at least 5 rows of data in each of the tables, start with the provided data items in the order they are provided, and imagine new data for the other ones. Be sure you follow the constraints in your problem.
- Show all the data in your table (at least five rows expected in each table).
- Execute and debug the script in MySQL Workbench until runs without error and performs the above operations.
- Include in the report file the following:
- A heading: Task 4 - Add data
- A screenshot (image) of the source code for this task only (crop the image if necessary) - top of the screen
- A screenshot (image) of the results for the performed operations - bottom of the screen
- Screenshots with the generated tables by the above commands, included in the order of the commands - middle of the screen in different tabs
- Continue writing the SQL script in MySQL Workbench, adding the following operations:
- Task 5 - Query the data
- Continue writing the SQL script in MySQL Workbench, adding the following operations:
- Include a comment: Task 5 - Query the data by ... (your name)
- Perform the queries from your specification.
- Execute and debug the script in MySQL Workbench until runs without error and performs the above operations.
- Include in the report file the following:
- A heading: Task 5 - Query the data
- A screenshot (image) of the source code for this task only (crop the image if necessary) - top of the screen
- A screenshot (image) of the results for the performed operations - bottom of the screen
- Screenshots with the generated tables by the above commands, included in the order of the commands - middle of the screen in different tabs
- Continue writing the SQL script in MySQL Workbench, adding the following operations:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: