[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.

DATABASE SCOPE:

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

DESCRIPTION:

Your homework must include the following sections.

SECTION 1 WEB SITE DESCRIPTION (0.10 points)

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

SECTION 2 ENTITY REQUIREMENTS (0.20 points)

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.

SECTION 3 ENTITY DESIGN (0.4 points)

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.

SECTION 4 ENTITY IMPLEMENTATION (0.8 points)

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)
$0.00
*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.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your 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.
Pro service tips
How to get the most out of your experience with MyCoursebay
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Wellness
The skilled writer did a GREAT job on assignment. There are a few details I will add, but overall very happy with their work. Thank you
Customer 452547, June 13th, 2021
Social Work and Human Services
Thank you for the great job
Customer 452469, February 3rd, 2021
Psychology
Thank you so very much!!!
Customer 452517, May 11th, 2021
Exploring Gender in Science, Technology, and Mathematics
Very good work
Customer 452769, July 2nd, 2022
Social Work and Human Services
Great Work!
Customer 452587, August 31st, 2021
Medicine
Great job! Thank you.
Customer 452707, May 29th, 2022
Criminal Justice
always great!
Customer 452465, February 23rd, 2021
ENVIRONMENT SCIENCE
great
Customer 452813, June 26th, 2022
Social Work and Human Services
Thank You! Great Work!
Customer 452587, September 14th, 2021
Nursing
Writer went above and beyond. Can't believe how much work they put in for the price.
Customer 452707, July 10th, 2022
Communications
Thank you very much
Customer 452669, November 17th, 2021
Nursing
Another great paper! Thank you!
Customer 452707, June 16th, 2022
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
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

Order your essay today and save 30% with the discount code ESSAYHELP

NEW

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