Petvax Erd And Sql Database Design Assignment Help
Petvax Erd And Sql Database Design Assignment Help guides students through completing Part 2 of a database lab that requires submitting a single PDF containing a fully normalized ERD built in Lucidchart and the corresponding SQL CREATE TABLE statements. The assignment must be uploaded to the Brightspace dropbox, and failing to submit the file results in a grade of zero regardless of 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.