[SOLVED] Create a Table exercise

I’m working on a MySQL question and need guidance to help me study.

Struggling to find relevant content or pressed for time? – Don’t worry, we have a team of professionals to help you on
[SOLVED] Create a Table exercise
Get a 15% Discount on this Paper
Order Now

URL: https://nationalzoo.si.edu/animals/list

Based on the link received, post the following information, in the respective questions.

  1. A PDF document with all the description of the homework as required below
  2. A Workbench design file with the diagram describing your model, as specified below
  3. The MySQL script creating a database that will implement the design completely.

Start all your file names with your email id (e.g. mboicu for me), followed by (-s1a1-), and you may add a name for your database.


You must create a SINGLE entity design and SINGLE table implementation for the model provided.


Your homework must include the following sections.


You must include one or more screen shots showing the required model data. At least 5 data items (entity instances, rows) must be included.


You must include a phrase describing the entity as in requirements. You must identify at least 3 descriptive attributes (columns), in addition to the primary key (id). If your link does not contain 3 attributes, you must identify the ones present.

For instance, for the class example IST Faculty, one may include:

A list with all faculty is stored and managed. For a faculty we keep the G number (id), name, photo, academic title (e.g. Associate Professor) and administrative title (e.g. Chair), if any.


You must create the design of the entity, and include an image with the design in the PDF file. Be sure, you create the corresponding attributes and specify if they are required/optional and unique or not.

Also, be sure you include the file as an attachment to the corresponding question. No points given without the source file, or a different source file.


You must implement the design as presented. To do so you must create a SCRIPT file that performs the following operations:

  • Drop the database if already exists. Create a database with a suggestive name. Mark that database as default. (0.1 points)
  • Create the table (0.20)
  • Show the tables in the database and show the structure of the created table (0.1)
  • Insert 5 rows in the table (0.20)
  • Show the content of the table (0.20)

In the PDF file, you must include your script and an execution of the script either in command line or in MySQL Workbench (screenshots). The source file/screenshots must be signed with your name during execution (e.g. including comments). Image/file not signed (-0.30 points)

You must attach a runnable SQL SCRIPT (a text file). If not included, or not runnable, no points will be given.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
Sign up, place your order, and leave the rest to our professional paper writers in less than 2 minutes.
step 1
Upload assignment instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Get personalized services with MyCoursebay
One writer for all your papers
You can select one writer for all your papers. This option enhances the consistency in the quality of your assignments. Select your preferred writer from the list of writers who have handledf your previous assignments
Same paper from different writers
Are you ordering the same assignment for a friend? You can get the same paper from different writers. The goal is to produce 100% unique and original papers
Copy of sources used
Our homework writers will provide you with copies of sources used on your request. Just add the option when plaing your order
What our partners say about us
We appreciate every review and are always looking for ways to grow. See what other students think about our do my paper service.
Social Work and Human Services
Great Work!
Customer 452587, September 8th, 2021
The writer went above and beyond as usual. Always a great experience with these writers.
Customer 452707, December 4th, 2022
IT, Web
Great job on the paper!!
Customer 452885, January 30th, 2023
Comprehensively done. Thank you
Customer 452583, July 20th, 2021
Looks good. Thank you!!
Customer 452525, April 27th, 2022
Criminal Justice
Looks good! Thank you Jason
Customer 452711, January 25th, 2022
Thank you for the outstanding work .
Customer 452635, June 5th, 2022
As usual, the writers do amazing work.
Customer 452707, October 1st, 2022
i got the paper a bit late but it is good quality will for sure come back and use this website.
Customer 452611, September 9th, 2021
Perfect as usual!!! Thanks team!
Customer 452453, May 26th, 2021
IT, Web
Did an excellent job with the body of the paper and staying on the topic.
Customer 452885, October 27th, 2022
Social Work and Human Services
The paper is impressive. Very professional and per the instructions
Customer 452533, May 24th, 2021
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat

Get top-notch homework help now. 20% off first 10 orders!


Thank you for choosing MyCoursebay. Your presence is a motivation to us. All papers are written from scratch. Plagiarism is not tolerated. Order now for a 15% discount

Order Now