Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Select Healthcare Classification Systems And Databases

Authors: Katherine S. Rowell, Ann Cutrell

1st Edition

0615909760, 978-0615909769

More Books

Students also viewed these Databases questions

Question

=+What classes of input will make good test cases?

Answered: 1 week ago