When designing a relational database table, in addition to the name of each column, you need to define the kind of information each column will store. This is called the column’s, or the attribute’s, data type. Common data types include character data, numerical data, dates and times, and more specialized kinds of information.
- [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 … the RDBMS can store data more efficiently. …
Author
Adam Wilbert
Released
9/23/2019- The basics of data storage
- Choosing an entity-relationship design tool
- Using primary keys to identify records
- What to consider when naming objects
- Creating a unique constraint
- Establishing table indexes
- Relating tables with foreign keys
- One-to-many and one-to-one relationships
- Normalization
- Writing SELECT queries in SQL
Skill Level Intermediate
Duration
Views
-
Introduction
-
1. Get to Know Relational Databases
-
What the CRUD?3m 48s
-
2. Entity Relationship Diagrams
-
Choose an ER design tool5m 7s
-
Design a table3m 39s
-
3. Data Integrity and Validation
-
Data constraints1m 44s
-
Create a unique constraint5m 46s
-
Define a default value3m 58s
-
Establish table indexes4m 49s
-
Add check constraints5m 31s
-
-
4. Relationships
-
Diagram a relationship2m 42s
-
One-to-many relationships2m 10s
-
One-to-one relationships1m 10s
-
Many-to-many relationships2m 21s
-
Self joins2m 17s
-
Cascade changes2m 17s
-
5. Normalization
-
When not to normalize2m 29s
-
6. Structured Query Language
-
Data definition queries6m 22s
-
Data manipulation queries4m 52s
-
Create a database view2m 44s
-
7. Beyond the Relational Model
-
Graph databases1m 38s
-
Document databases1m 32s
-
-
Conclusion
-
Next steps59s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Attribute data types