Petvax Normalized Database Lab Part 2 Assignment Help
Petvax Normalized Database Lab Part 2 Assignment Help walks students through the exact deliverables and steps required to complete the second part of the PetVax normalized database lab. The assignment requires students to submit a single PDF containing a fully normalized ERD built in Lucidchart and the corresponding SQL CREATE TABLE statements. Completing both components and uploading the file to the Brightspace dropbox is mandatory, as missing the submission results in a grade of zero regardless of any quiz completion.
What You Are Submitting Part 2 of this lab is one PDF file that contains: Your ERD of the fully normalized PetVax design. You must build the ERD in Lucidchart — no other tool is accepted. – https://lucid.co/lucidchart The SQL (CREATE TABLE statements) for that same design. Your ERD must include every entity and every relationship in your design — do not leave any table or link out. Both the ERD and the SQL must be in the same PDF. Upload it to the Brightspace dropbox for Summer Lab 3. ⚠️ No file, no grade: You must submit this PDF. If you do not submit the file, your grade for this lab is 0, even if you completed the Brightspace quiz. Tools You Will Need Tool Use Lucidchart (free account) Draw the ERD and generate the SQL A PDF printer or "Save as PDF" Combine the ERD and SQL into one file (Optional) Microsoft Access or SQLite Test that your SQL runs without errors Part A — Build the ERD in Lucidchart Step 1 — Start an ER diagram Sign in to Lucidchart and create a new blank document. Turn on the Entity Relationship shape library (left panel → Shapes → search "ERD" → enable the entity shapes). Step 2 — Add every entity Add one entity box for every table in your fully normalized design. Do not leave any table out. For every attribute in each table, fill in three things using the standard ERD entity rows: the column name; its data type (for example, Number, Short Text, Date/Time, Yes/No, Currency); its key marker — PK for the primary key, FK for each foreign key.