From the course: Relational Databases Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Attribute data types
From the course: Relational Databases Essential Training
Attribute data types
- [Instructor] When designing a relational database table, in addition to the name of each column you'll need to define the kind of information each column will store. This is the columns or the attributes data type. We've already seen that in a relational database table each column will store a single piece of information. Here we have a simple table that stores information about a couple of employees. If you read down each column you'll notice that all of the values are of the same type. The first column is all text, the second are all dates, then currency values, and finally numbers. The structure of a table is what Edgar Codd called a two-dimensional column homogeneous array. That's a mathematically precise way of saying that each column only stores a single type of data. Because of this the relational database management system can use this fact in a number of useful ways. First when the data types are known ahead of time…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.