tailieunhanh - Beginning SQL Server Modeling- P7

Tham khảo tài liệu 'beginning sql server modeling- p7', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | CHAPTER 5 M - THE MODELING LANGUAGE Decimal28 A fixed point or exact number. Decimal38 A fixed point or exact number. Integer A signed integer. Integer8 A signed integer with fewer than 9 bits of precision. Integer16 A signed integer with fewer than 17 bits of precision. Integer32 A signed integer with fewer than 33 bits of precision. Integer64 A signed integer with fewer than 65 bits of precision. Scientific A floating-point or exact number. Single A 32-bit floating-point or exact number. Double A 64-bit floating-point or exact number. Unsigned An unsigned integer. Unsigned8 An unsigned integer with fewer than 9 bits of precision. Unsigned16 An unsigned integer with fewer than 17 bits of precision. Unsigned32 An unsigned integer with fewer than 33 bits of precision. Unsigned64 An unsigned integer with fewer than 65 bits of precision. Date A calendar date. DateTime A calendar date and time of day independent of time zone. DateTimeOffset A calendar date and time of day within a specific time zone. Time A time of day and time zone. Text A sequence of characters. Logical A logical flag. Binary A sequence of binary octets. Guid A globally unique identifier 121 Download from Wow eBook CHAPTER 5 M - THE MODELING LANGUAGE Byte Collection Entity A single binary octet. An unordered group of potentially duplicate values. A collection of labeled values. The Collection Type The collection type is an unordered group of potentially duplicate values. A collection can be constructed as an expression with a beginning brace a type reference an optional multiplicity described shortly and an ending brace . So the following examples are all valid collections NPR ABC CBS NBC a collection of four broadcast network names Red White Blue a collection of three color names Baseball Basketball Soccer a collection of three ball game names the collection of the two transcendental numbers n and e expressed to a 3-decimal precision Integer 8 a collection of any eight .