SQL Foundations I Module 1 Public

Intro to SQL

Design entity relationship diagrams, generate and deploy relational constraints, create tables, populate and manipulate table data

Required Evidence

Generate an ERD with three tables

Generate an ERD with three tables, consisting of primary and foreign keys as appropriate; explain how you chose the keys. Submit an URL where your ERD is located More Info

Generate statements (ddl) to create all objects

Generate statements (ddl) to create all objects from the ERD. These must be valid SQL statements. It is recommended you use SQLFiddle to post working examples. Submit an URL where your work is located, with valid code. More Info

Craft 3 insert statements to populate data

Craft 3 insert statements to populate data into the tables. It is recommended you use SQLFiddle to save an example of your work, and then submit the URL for your SQLFiddle. More Info

Write 3 update and delete statements

Write 3 update and delete statements to manipulate the data in each table. Submit a URL for SQLFiddle or other location where your work can be publicly viewed. More Info

Badge Overview

http://onyx.csit.parkland.edu/~csc191/modules/module1/index.html

MODULE 1: Database theory and design, CREATE, UPDATE, DELETE, INSERT

Learning Objectives

  • design and explain entity relationship diagrams
  • analyze, generate and deploy relational constraints
  • create tables
  • populate tables with data and manipulate table data

Tasks

  1. Generate an ERD with three tables, consisting of primary and foreign keys as appropriate; explain how you chose the keys
  2. Generate statements (ddl) to create all objects from the ERD
  3. Craft 3 insert statements to populate data into the tables
  4. Write 3 update and delete statements to manipulate the data in each table

Badge Experts

 

Charles Schultz

sacrophyte

Created badge on 1/18/16
 

Jacob Uden

jaco

Badge awarded on 10/9/16
 

Jay Fisher

jmfisher

Badge awarded on 9/21/17
 

K'Tyn Fowler

kfowler

Badge awarded on 10/14/16
 

Matt Purnell

mpurnell1

Badge awarded on 11/26/17
 

Randy McCarthy

randyiv

Badge awarded on 11/8/16
 

Summer Lewis

slewis52

Badge awarded on 10/6/16
 

Victoria Becu

Vbecu1

Badge awarded on 12/17/16

Badge Learners

 

AHMAD BASIM YOUSEF

Ahmadbq

  •  
Joined badge on 8/26/20
 

Brian Chemase Anikayi

anikayi

  •  
Joined badge on 12/13/20
 

Francisco Cruz

FranciscoCruz11

Joined badge on 10/20/16
 

KGM Media

KGM-Media

  •  
Joined badge on 7/26/20
 

Mangai Neelavannan

Mangai

Joined badge on 5/19/18
 

Ricardo J Vargas

rvargas8

Joined badge on 10/8/17
 

Ruchita Gathani

rgathani28

  •  
Joined badge on 2/17/20
 

Sharon Dow

Sdow3

Joined badge on 10/4/18
 

dustin bobzin

dustinninja

Joined badge on 10/12/16