Answered step by step
Verified Expert Solution
Question
1 Approved Answer
if possible explain steps on how to create in my SQL You must create a database design in MySQL. Workbench and create a short PDF
if possible explain steps on how to create in my 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. Database Conventions 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. - Entily names: singular nouns (or noun phrase) written in CAPITAL LETTERS, using _ instead of space, must end with a two letter suffix with your first name and last name initials (e.g. if your name is John Doe, an entity name will be PERSON_JD) - Altribute names: singular nouns (or noun phrase) written in CAPITAL LETTERS, using_instead of space, must end with a two-letter sulfix with your first name and last name initals (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) Entity Dlagram 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 scroenshots: - A signed screenshot (or more if needed) with the ERD for this entty 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 characterisfics (o.g. required/optional and unique/duplicated) and the primary key, Submission instructions: You must name the fle: D1_A1_lastname_firstname.pdf The report mustcontain: - Your name - Your course and section - A suggestive title for your report. - A short criginal description of the database (at least two sentences) - The two screenshots as described above. 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. Database Conventions 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. - Entily names: singular nouns (or noun phrase) written in CAPITAL LETTERS, using _ instead of space, must end with a two letter suffix with your first name and last name initials (e.g. if your name is John Doe, an entity name will be PERSON_JD) - Altribute names: singular nouns (or noun phrase) written in CAPITAL LETTERS, using_instead of space, must end with a two-letter sulfix with your first name and last name initals (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) Entity Dlagram 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 scroenshots: - A signed screenshot (or more if needed) with the ERD for this entty 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 characterisfics (o.g. required/optional and unique/duplicated) and the primary key, Submission instructions: You must name the fle: D1_A1_lastname_firstname.pdf The report mustcontain: - Your name - Your course and section - A suggestive title for your report. - A short criginal description of the database (at least two sentences) - The two screenshots as described above Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started