Difference between revisions of "DD Class10"
esse quam videri
(→Fifth Normal Form) |
|||
Line 22: | Line 22: | ||
Fifth Normal Form | Fifth Normal Form | ||
:breaks out data redundancy that is not covered by any of the previous normal forms. | :breaks out data redundancy that is not covered by any of the previous normal forms. | ||
+ | |||
+ | ==HomeWork== | ||
+ | Course adder example | ||
+ | |||
+ | http://iam.colum.edu/dd/classsource/class8/student.aspx | ||
+ | |||
+ | SQL Subquery | ||
+ | |||
+ | <sql>SELECT CourseID, CourseName, CourseNumber | ||
+ | FROM Course | ||
+ | WHERE | ||
+ | ( | ||
+ | CourseID not in | ||
+ | ( | ||
+ | SELECT CourseID FROM StudentsCourses_vw WHERE StudentID = @StudentID | ||
+ | ) | ||
+ | ) | ||
+ | </sql> |
Revision as of 20:31, 29 March 2007
Contents
Create a new user account
Transactions
Whenever you are making changes (insert/update/delete) two more than one table or the results of a select statement are used to update another table you need to use a tracation.
Locks
Commit
Rollback
Stored Procedures
Fourth Normal Form
Fourth Normal Form
- separates independent multi-valued facts stored in one table into separate tables.
Fifth Normal Form
Fifth Normal Form
- breaks out data redundancy that is not covered by any of the previous normal forms.
HomeWork
Course adder example
http://iam.colum.edu/dd/classsource/class8/student.aspx
SQL Subquery
<sql>SELECT CourseID, CourseName, CourseNumber FROM Course WHERE (
CourseID not in ( SELECT CourseID FROM StudentsCourses_vw WHERE StudentID = @StudentID )
) </sql>