Database design in SQL

You must create a database design in MySQL Workbench and create a short PDF report presenting your design. Your design must be a single-entity design for the provided specification. This is a CLOSED BOOK assignment and you are not allowed to use any external information to solve it. Be sure that you use the description that was assigned to you. Solving a different version of the assignment will result in a grade of zero for this assignment and may result in honor committee referral. You must follow these conventions when you perform your homework. Failing to follow the conventions will be penalized per each mistake and may also constitute evidence of cheating. After you finished the entity analysis based on the provided specification you must draw the ERD in MySQL Workbench and include in your report the following screenshots: You must name the file: D1_A1_lastname_firstname.pdf The report mustcontain:

Requirements: whatever the description says | .doc file

Entity names: singular nouns (or noun phrase) written in CAPITAL LETTERS using _ instead of space must start with a two letter sufix with your first name and last name initials (e.g. if your name is John Doe an entity name will be PERSON_JD) Attribute names: singular nouns (or noun phrase) written in CAPITAL LETTERS using _ instead of space must start with a two-letter sufix with your first name and last name initials (e.g. if your name is John Doe an attribute name will be FIRST_NAME_JD) Additional conventions might be specified by your instructor (e.g. prefix the attribute names with the entity name or abbreviation) A signed screenshot (or more if needed) with the ERD for this entity done in MySQL Workbench (to sign a screenshot you write your name in a text object visible in the screenshot; crop the image to show only the ERD and the text object) A screenshot with the entity (table) description in MySQL Workbench (crop the image to show the entity name and attribute table). Be sure you correctly identify the entity name attributes names attributes domains attributes characteristics (e.g. required/optional and unique/duplicated) and the primary key. Your name Your course and section A suggestive title for your report A short original description of the database (at least two sentences) The two screenshots as described above.