Exam 3 study guide

Coverage:

Notes: ERDtoSchema, ERDBasketballSchema, week08notes01.

Labs: 6

Entity Relationship modeling:

Degree

Cardinality (min and max)

Relationship notation

Many to many relationships form new weak entities

Mysql SQL for creating, deleting, inserting into, and deleting from tables:

Constraints

Primary keys

Foreign keys

Under what conditions are Foreign Key constraints violated?

What does on delete cascade mean?

ERD Notation / Creating tables from ERDs

Know how to apply the rules shown in http://cs.sou.edu/~nordquip/cs360/notes/ERDtoSchema.html.

Given an ERD, write SQL to create tables to implement this ERD.

Stored Procedures

How to declare

Parameters: IN, OUT

How to return a value

How to call

How to pass arbitrary data back to the caller using a select statement

How to write a continue or exit handler for “duplicate entry for key” and “foreign key constraint fails” errors. (Not for Spring, 2019)