Silahkan diunduh materi untuk pertemuan 4 mengenai Aljabar Relational. Meskipun namanya berbau matematika namun isi materi aljabar relational lebih berkaitan dengan tabel di dalam sebuah basis data. 64 more words
Expressions, Conditions, Operators, Comparison Operators, Character Operators, Logical Operators, Set Operators, UNION and UNION ALL, INTERSECT, Miscellaneous Operators: IN and BETWEEN.
Fast between SingleOrDefault and FirstOrDefault, LINQ provider, advantages of using LINQ on DataSet, difference between Select and SelectMany in LINQ, difference among Any, All and Contains, difference between into and let keyword in LINQ, Union, Intersect and Except, extension of the file, when LINQ to SQL is used, data context class, deferred execution and immediate execution. 18 more words
Some databases, such as PostgreSQL and Teradata, natively support “ALL” keyword with SET operators MINUS (EXCEPT) and INTERSECT. As of current version, Oracle does not support these features; however, a little trick can help emulating the missing functionality. 261 more words
A combinatoric Le Monde mathematical puzzle that resembles many earlier ones:
216 more words
Given a pool of 30 interns allocated to three person night-shifts, is it possible to see 31 consecutive nights such that (a) all the shifts differ and (b) there are no pair of shifts with a single common intern?