Skip to content
Start Your Project
Uncategorized

Normalize PetVax ERD and SQL in Lucidchart correctly

Updated

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.