I recommend checking out Microsoft’s SQL Server sample databases:
https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks
The AdventureWorks sample uses a very clear and consistent naming convention that uses schema names for the organization of database objects.
- Singular names for tables
- Singular names for columns
- Schema name for tables prefix (E.g.: SchemeName.TableName)
- Pascal casing (a.k.a. upper camel case)
Related Contents:
- What should every developer know about databases? [closed]
- Relational table naming convention [closed]
- What is the best practice in naming your “user” table?
- What’s the difference between identifying and non-identifying relationships?
- Difference between scaling horizontally and vertically for databases [closed]
- Database development mistakes made by application developers [closed]
- Can I have multiple primary keys in a single table?
- Should each and every table have a primary key?
- What are OLTP and OLAP. What is the difference between them?
- What are database normal forms and can you give examples? [closed]
- What is an ORM, how does it work, and how should I use one? [closed]
- Is there a good reason I see VARCHAR(255) used so often (as opposed to another length)?
- Is it better to use multiple databases with one schema each, or one database with multiple schemas? [closed]
- Surrogate vs. natural/business keys [closed]
- Foreign Key naming scheme
- What’s wrong with nullable columns in composite primary keys?
- NoSql vs Relational database
- What is the most efficient way to store tags in a database?
- Database: To delete or not to delete records
- Best practices for storing postal addresses in a database (RDBMS)?
- How many database indexes is too many?
- Best design for a changelog / auditing database table? [closed]
- Table Naming: Underscore vs Camelcase? namespaces? Singular vs Plural?
- What is the optimal length for an email address in a database?
- Good practices for designing monthly subscription system in database [closed]
- What is cardinality in Databases?
- Why is a database always represented with a cylinder? [closed]
- What’s the better database design: more tables or more columns?
- Does anyone know of a good library for mapping a person’s name to his or her gender? [closed]
- Best representation of an ordered list in a database?
- When should I use Datomic?
- How many columns is too many columns? [closed]
- Naming of boolean column in database table [closed]
- What databases do the World Wide Web’s biggest sites run on? [closed]
- What are the advantages of using a single database for EACH client?
- Should OLAP databases be denormalized for read performance? [closed]
- How should international geographical addresses be stored in a relational database?
- Microservices with shared database? using multiple ORM’s? [closed]
- Why should I avoid loops when designing relationships for a database?
- Is it a good idea to use an integer column for storing US ZIP codes in a database?
- Should I write table and column names ALWAYS lower case?
- What is the difference between logical data model and conceptual data model?
- Database schema design for a double entry accounting system? [closed]
- Database – Data Versioning [closed]
- Ideas on database design for capturing audit trails [closed]
- First name, middle name, last name. Why not Full Name?
- Database partitioning – Horizontal vs Vertical – Difference between Normalization and Row Splitting?
- What is a lookup table?
- Data Warehouse Considerations: When and Why? [closed]
- In terms of databases, is “Normalize for correctness, denormalize for performance” a right mantra?