This is the second video in the 5 database design videos in my oracle sql tutorial series. This video discusses database integrity. Database integrity is broken up into 3 sections: entity integrity, referential integrity, and domain integrity. Entity integrity focuses on the primary key. A primary key should be unique, NOT NULL, and never changing. It should refer to only one individual entity. Referential integrity focuses on protecting the relationships between entities of different tables. When creating relationships between tables, you will associate a column with another column in a different table. Individual entities inside of this table should have relationships with individual entities in the other table. For example, a comment table might have a user_id column. Each individual comment (each row), should have a user_id that points to a user_id in the user table. We protect referential integrity with what are known as foreign key constraints. Domain integrity focuses on the allowed values within a database. This one is probably the most complex because there are so many different things you can do to protect this, some of which involve a server side scripting language to add even more complex rules such as regular expressions. Fortunately, Oracle SQL is a pretty big database system and surely has lots of features that can be used to allow domain integrity. HELP ME! www.patreon.com/calebcurry Subscribe to my newsletter: eepurl.com/-8qtH Donate!: bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: CalebCurry.com Facebook: www.facebook.com/CalebTheVideoMaker Google+: plus.google.com/+CalebTheVideoMaker2 Twitter: Twitter.com/calebCurry Amazing Web Hosting - www.dreamhost.com/r.cgi?1487063 (The best web hosting for a cheap price!)

Be the first to comment