Null values represent a special case in relational database design where an attribute’s value is unknown or not applicable. If an attribute is an optional component of a record, then by definition, the column needs to allow null values. Alternatively, if an attribute is a required component of each record, then the column must not allow nulls.
- [Instructor] When entering records into a database, … it's not a requirement that every … attribute column is populated with data. … When a value isn't supplied, it's said to be null. … A null value represents data that's unspecified, … unknown, or not applicable. … It's important not to confuse null with zero, … or a blank space character. … Null means literally nothing at all or no data. … Let's take a look at this data table … of people and their birthdays. … Antonio's birthday is currently null. … That doesn't mean that he doesn't have a birthday. … He most certainly does. … All we can say about it is that it's currently not known, … and any information about it is missing from the database. … Null values are important when you start thinking about … whether information in a column … is required to be supplied for every record. … Maybe this data table represents customers … and you've offered to send a special coupon … to people on their birthday. … Some customers will give you that information …
Author
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
Related Courses
-
Database Foundations: Administration
with Adam Wilbert1h 14m Beginner -
Learning Relational Databases
with Adam Wilbert2h 43m Beginner
-
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
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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: Required attributes and null values