CSE 278 Lecture Notes - Lecture 14: Referential Integrity, Operand, Unique Key

• School: Miami University
• Department: Computer Science & Software Engineering
• Course: CSE 278
• Professor: Dr. Fabio Guerinoni

Document Summary

Cse 278 - lecture - databases with c++ programs. Many are familiar with insert, delete, update. The modification of a database is a delicate issue that requires more than this course. The order of attributes listed doesn"t have to be those of table, but values given must agree with this order. The tuples must contain exactly the number of attributes. As we discussed earlier, attributes not listed are given two possible values: The second is used if indicated in schema. Not null might be specified even for primary key. Recall queries create temporaries that may be considered relations. We can use them instead of explicit values. Say we have movies in our db with some little known studio, we might assure referential integrity . This inserts only the new studios into studio. Where studioname not in (select name from studio); Almost same syntax as select, except has word delete and no attributes specified.