Join Adam Wilbert for an in-depth discussion in this video Data types and precision, part of Relational Database Fundamentals.
- View Offline
- Exercise Files
…The next two columns on your table design…worksheets deal with the data types and precision.…Here we'll determine what type of data each…attribute column needs to be able to store.…Each database management system is going to provide…a slightly different array of options here, so you'll…need to consult your DBMS's documentation to see…the specific options available and how to implement them.…But, there are several common and standard data types,…that all will support in one way or another.…The most common type of data you are likely to store is text data.…This is anything that uses alphanumeric characters or symbols.…
This includes names and departments, but also…fields such as license plates or email addresses.…In most systems, you'll have a choice between storing small strings…of characters, or large blocks of text as two distinct data types.…The specific number of characters in each category, differs from system to system.…But most also provide a variable text type, that…allows you to specify the maximum number of characters allowed.…
- What is a database management system (DBMS)?
- Moving through the database development cycle
- Preventing duplicate, inconsistent, and conflicting data entries
- Gathering requirements
- Developing relationships
- Identifying key fields
- Following a naming convention
- Developing the actual database
Skill Level Beginner
FileMaker Pro 12 Essential Trainingwith Cris Ippolite10h 28m Beginner
Financial Literacy: Reading Financial Reportswith Rudolph Rosenberg1h 25m Appropriate for all
1. Relational Database Basics
2. Preventing Data Anomalies
3. Gathering Requirements
4. Developing the Conceptual Data Model
5. Normalizing Your Data
6. Logical Design Considerations
7. Developing the Physical Database
- 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.Cancel
Take 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.