One additional perspective that you need to take is to understand how the organization will treat historical data. Often, this requires a different data item that stores the historical value separate from the current value.
- [Instructor] Through the interview process,…we learned what data items were relevant…to the current business needs.…One additional perspective that we need to take…is to understand how the organization…will treat historical data.…Often this will require a separate data item…to store the historical values…separate from the current value.…Here's two examples of what this means…for the Two Trees Olive Oil Company.…The first deals with storing prices.…Typically we would keep track…of the current price of a product…in the record for each product.…But when a customer purchases a product,…we might also want to keep track of the purchase price…at the time of the transaction.…
We can do this by copying the current price…into the line items table.…Now if our pricing changes in the product's table,…it won't affect the total price on our old invoices.…Solving the problem created a new data item…that we need to add to our growing list.…In this case, I've called it purchase price…and we'll put in the line items table.…The second example deals with the problem…
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.