From the course: Programming Foundations: Databases
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Naming tables
- Usually, though not always, tables will be named with a plural version of whatever record type we're keeping in them. We have a table where customer data is stored. So that's the Customers table. Likewise, we have Dishes and Events. This helps us talk about the items we store in the table more easily later on. We wouldn't want to name the tables A, B, and C, or something nondescriptive like that. Whether or not you use plurals for your table, it's a best practice to name the tables starting with a capital letter. You should also avoid using special characters and spaces in table names. As we've defined fields, I've given them specific names as well. Fields should be named singularly, because for each record, there's only one piece of data in the field. So we have FirstName, LastName, Birthday, and so on. It wouldn't make sense to ask the database for one person's birthdays. This way of writing the names with each word capitalized and without spaces between them is called…
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.