'Update cascade' diaporamas de présentation

Data Definition Language

Data Definition Language. Based on Chapter 6 of Database Systems (Connolly and Begg). DDL.

588 views • 39 slides

CSE 480: Database Systems

440 views • 35 slides

Relational data integrity

Relational data integrity . Lecture 8 . Outline. integrity constraints and data definition candidate keys foreign keys nulls domains conditional expressions normal forms. Constraints. in real life systems constraints exist between data values

614 views • 25 slides

Geo-Databases: lecture 6 Data Integrity

117 views • 11 slides

Referential Integrity checks, Triggers and Assertions

Referential Integrity checks, Triggers and Assertions. Examples from Chapter 7 of Database Systems: the Complete Book Garcia-Molina, Ullman, & Widom. Movie Database. Movie (title, year, length, inColor, studioName, producerC#) StarsIn (movieTitle, movieYear, starName)

222 views • 10 slides

Referential Integrity MySQL

Referential Integrity MySQL. CREATE TABLE exmp1( id INT NOT NULL, val TEXT, UNIQUE (id) ) TYPE=InnoDB; CREATE TABLE exmp2( id INT, blah TEXT, INDEX(id), CONSTRAINT id_fkey FOREIGN KEY (id) REFERENCES exmp1(id) ON UPDATE CASCADE ) TYPE=InnoDB;. Examples:Zoo animals.

200 views • 2 slides

REFERENTIAL INTEGRITY

REFERENTIAL INTEGRITY. CREATE TABLE EMP (ENAME VARCHAR(30) NOT NULL, ESSN CHAR(9), BDATE DATE, DNO INTEGER DEFAULT 1, SUPERSSN CHAR(9), PRIMARY KEY (ESSN), FOREIGN KEY (DNO) REFERENCES DEPT(Dnm) ON DELETE SET DEFAULT

137 views • 2 slides