You must create database design in MySQL Workbench and create a short PDF report presenting your design. Your design must
You must create 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.
Entity 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)
Attribute 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 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)
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:
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.
You must name the file: D1_A1_lastname_firstname.pdf
The report mustcontain:
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.
You will receive zero points in the following situations:
If you submit screenshots that are not signed or with entities/attributes without your initials as explained above.
Not following the instructions from this semester (e.g. following instructions aspects from previous semesters, e.g. the format of your report)
Not following your specifications (2-3 elements in your design are not based on this semester requirements but they follow previous semesters requirements or other versions of questions from this semester)
Requirements Specification (this is a fictional scenario)
Jim McKay Chevrolet Car Dealer contacted you to improve their inventory database. To proof your knowledge your company must create an initial model of the database. For simplicity, they asked to have a single-entity database. Below is the dialog between a senior DESIGNER and a CUSTOMER representative.
Designer: May you show me some sample data that you want to be stored in the database?
Customer: Yes, we want to keep information for our inventory. Some sample cars in our inventory are:
2020 Chevrolet Suburban LT; MPG: 14 City / 21 Hwy; VIN #: c; PRICE: $64,148;
2020 Chevrolet Silverado 1500 WT; MPG: 15 City / 19 Hwy; VIN #: 3GCNWAEF8LG252540; PRICE: $28,185;
2020 Chevrolet Bolt EV Premier; MPG: 127 City / 108 Hwy; VIN #: 1G1FZ6S00L4121472; PRICE: $35,605;
2019 Chevrolet Malibu LT 1LT; VIN #: 1G1ZD5ST8KF112375; Price: $16,478;
Designer: Are you selling only Chevrolet cars?
Customer: No, we are selling all types of cars, BMW, Buick, Cadillac, ...
Designer: Based on what characteristics do you want to search or make other operations?
Customer: Year, make, model, trim, miles per gallon in the city or highway, VIN and price.
Designer: What properties are always provided for a car?
Customer: Year, make, model, trim, VIN and price. Each car has a unique VIN.
Designer: I need to specify the maximum number of characters (the length) for various names. Looking at your data samples I identified the following: maker - max 17 characters, model - max 12 characters, trim - max 11 characters. Can you have larger names?
Customer: No. They will work for me.