Data entry tasks can be accomplished by different people with different abbreviation tendencies. Inconsistencies in the way the same value is stored can lead to the database returning incorrect information.
- [Instructor] Typographic errors and spelling mistakes…can completely wreck even the most well planned database.…These types of errors are difficult to predict…and often occur when data entry tasks are being performed…by human beings.…We simply get in a hurry and can get a little sloppy…with our typing skills.…Related to this is the common problem of…having different entry styles…among a variety of individuals.…Different people might be in charge of putting…data into the database.…Some people like one abbreviation over another,…and others will choose to spell out information completely.…
Let's take a look at an example using the products table…that we created in the last movie.…Here we have the various olive oils that are available…for sale and the manufacturers of those products.…In the manufacturer's column,…you can see that they're all produced by…the Two Trees Olive Oil company.…But, one of them was input as a numeral two…instead of the word two written out.…While this gets the information across in a way…
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.