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.
ES
EssayPanel Expert
Academic Expert · EssayPanel
Expert academic writer and education specialist helping students in the UK, USA, and Australia achieve their best results across all subjects.
Need help with your own assignment?
Our expert writers can help you apply everything you've just read — to your actual assignment, brief, and marking criteria.
Get Expert Help Now →← Previous
MS924 Spreadsheet Modelling & Demand Forecasting Assignment Question Instructions Answer all questions Your submission mus
Next →
HSC301: An introduction to Health and Social Care HSC301 Assignment Brief Qualification Qualifi Level 3 Diploma in Health and Social Care (603/0819/9) Unit Code HSC301 Unit Title An introduction to Health and Social Care Unit Reference