Join Adam Wilbert for an in-depth discussion in this video Following a naming convention, part of Relational Database Fundamentals.
- View Offline
- Exercise Files
…We've now got a good plan in place for how our database needs to function.…The next step of the process is to start thinking about how…to actually implement the plan in…our relational database management system of choice.…I've created a table design worksheet that you can print…out for each of your tables identified in your data model.…To help keep track of the decisions and changes that we're going to make.…These table design work sheets will help you out when it comes time to implement…the design in the DBMS and will make…up an important component of your database blueprint.…The first step of that process is to be explicitly clear in how…we're going to name the various tables and attributes that we're about the create.…
Proper naming of your tables and fields provides…a sort of self-documenting feature of your completed system.…Such that they can aid someone that comes after…you that needs to maintain your database, or even help…you remember what it was that you were doing six…months from now when you need to add a feature.…
- 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.