[SOLVED] Create a Table exercise
Im working on a MySQL question and need guidance to help me study.
URL: https://nationalzoo.si.edu/animals/list
Based on the link received, post the following information, in the respective questions.
- A PDF document with all the description of the homework as required below
- A Workbench design file with the diagram describing your model, as specified below
- 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.