Each attribute column in a table needs to get set to accept data of a particular type. Text and numeric values are stored differently, and can include different levels of precision or different numbers of characters. Additional vendor-specific data types
- The next two columns on your table design worksheets,…deal with 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 do consult your DBMSs documentation…to see the specific options available,…and how to implement them.…But there are several common and standard data types…that all DBMSs will support in one way or another.…The most common type of data that you're 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.…A 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.…
Adam Wilbert covers the basics of relational database design, regardless of whether you use Access, FileMaker, Open Office, or SQL Server. Learn how to prevent data anomalies, gather requirements to plan your design, and develop a conceptual data model—translating your ideas into components like tables, relationships, queries, and views. Plus, learn about logical design considerations that can help you construct a database that is easy to maintain.
- Identify the three rules of relations.
- Summarize the four stages of developing a relational database.
- Describe a strategy one might use to ensure a database remains flexible in terms of the questions a user can ask.
- Explain how to avoid scope creep.
- Recall the characteristics of a Lookup Table.
- Recognize situations in which denormalization would be beneficial.
- Understand the types of relationships modeled by junction tables.
- Define referential integrity.
Skill Level Beginner
1. Relational Database Basics
Relational structures3m 46s
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.