From the course: Learning Relational Databases
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Identify exceptions and irregularities
From the course: Learning Relational Databases
Identify exceptions and irregularities
- [Instructor] In the real world, collecting data is a messy endeavor. There will always be those exceptional cases and outliers that'll pop up. In a paper or a spreadsheet-based system, often these cases are just dealt with in an offhand or irregular manner when they occur. But in a database they need to be accommodated as if they were business as usual. The primary way that you'll identify these exceptional cases is through the interviews. When asked about a checkout process, an interviewee might say something like, "We need to collect the customer's first "and last name and their credit card number. "Oh, unless it's a wholesale customer. "Then we need the business name "and a purchase order number." This brief explanation indicates several data items that might be exceptions or irregularities. We now know that we need to store separate customer name and business name items. We also learned that the database should be collecting both a credit card data item and a separate purchase…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.