Yahoo Web Search

Search results

1. Top results related to what is a database name

   • What is a valid PostgreSQL database name?

     Top Answer

     Answered Jun 30, 2014 · 47 votes

     The documentation you asked about is here:

     http://www.postgresql.org/docs/current/interactive/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS

     Most people just stick to lowercase letters, numeric digits, and underscores -- to avoid typing the quotes all the time.

     Check all answers on Stack Overflow

     1/5

   • Database - What is a good database design for a booking system?

     Top Answer

     Answered Feb 26, 2018 · 1 votes

     I would suggest, first of all, write all the requirements in one table. 1 row is the flat structure of all the requirements. Then start breaking it one by one. That 1 table structure should be having all the required columns. Then follow Normalization concepts of breaking 1 single table into multiple tables.

     Check all answers on Stack Overflow

     2/5

   • What is better practice when storing a users full name in the database? 1 or 2 columns?

     Top Answer

     Answered Sep 14, 2011 · 11 votes

     Only you know that, really. It depends if you're ever going to need to get those parts of the name back out separately.

     Storing first name and last name in a single column isn't a reversible operation (in "Ellie May Jones", is "May" part of the last name or the first name?)

     Also, what different cultures are you going to be dealing with? Not everyone in every culture even has two names -- see the Wikipedia article on Family names to understand the can of worms you may be opening up :)

     Generally, I'm used to systems storing given and family name separately, and this gives you more potential to manipulate that data later, but then I deal primarily with a single, fairly small geographical region where people are used to being asked for a forename and surname. Also, the systems I run need to search for people based on their family name (easier if you can index a separate column) and send letters to people starting "Dear Miss Smith...")

     You may also want to consider whether you need a "preferred" name -- my name is "Matthew", for example, but I much prefer being called "Matt". And there are plenty of people who prefer others to use one of their middle names when addressing them. Whether you need to capture a preferred name and a "real" name will depend on your requirements...

     If I were you I'd start with two columns, assuming a fairly normal, English-speaking cultural bias. It's not a lot of code/storage overhead, and you can easily convert to a single column later if you find some pressing reason.

     Other Answers

     Answered Sep 14, 2011 · 8 votes

     Sure, just be sure you can deal with the german minister of defense, last thing you want is to cause a scene with the military because your code can't deal with his full name...

     Karl Theodor Maria Nikolaus Johann Jacob Philipp Franz Joseph Sylvester Freiherr von und zu Guttenberg, and guess what? His "last name" is von und zu Guttenberg. He's not a one-off case either. De Luca is a family name, separated by a space.

     I have a grandmother, and in Hungarian custom, a last name is actually your given name. Sztaki Helen is her proper full name, except her brother might be called Sztaki Fred, her father named Sztaki Greg. A similar thing exists for my Chinese friend Dai Wai, where Dai is also his family name.

     As it turns out, names are damn confusing. Instead of researching and planning for all of these various rules just to figure out what someone's called, especially when you base it off of "first name" and "last name" (Don't call my grandmother Mrs. Helen, that's her given name not family name), step back and think about why you actually need to collect all this personal information about me.

     I'd go on and totally blow your mind by explaining that not all cultures sort names alphabetically either, or that they even don't have a roman alphabet, but lets not go there just yet.

     Do you actually need my personal information? Probably not. In some cases you will, in most... you don't. Don't ask for it.

     If you really really do need it, ask for Sur Name and Given Name(s). Store it as two columns.

     Other Answers

     Answered Sep 14, 2011 · 2 votes

     Two separate columns is almost always better.

     You can always compute the full name from two separate columns. It's much harder to split the name (given two word last names, middle names, suffixes, etc) from a single column.

     Check all answers on Stack Overflow

     3/5

   • what does 'smt' mean, why is 'smt' often used as a prefix of a database name?

     Top Answer

     Answered May 01, 2019 · 0 votes

     Haven't seen this in the industry myself, but the best guess would be Subscription Management Tool, this is what I found SMT in relation to databases:

     https://www.suse.com/documentation/smt11/book_yep/data/book_yep.html

     It's part of SUSE Linux operating system

     Check all answers on Stack Overflow

     4/5

   • What is a "database entity" and what types of DBMS items are considered entities?

     Top Answer

     Answered Aug 19, 2009 · 15 votes

     In the entity relationship world an entity is something that may exist independently and so there is often a one-to-one relationship between entities and database tables. However, this mapping is an implementation decision: For example, an ER diagram may contain three entities: Triangle, Square and Circle and these could potentially be modelled as a single table: Shape.

     Also note that some database tables may represent relationships between entities.

     Other Answers

     Answered Sep 14, 2011 · 8 votes

     Sure, just be sure you can deal with the german minister of defense, last thing you want is to cause a scene with the military because your code can't deal with his full name...

     Karl Theodor Maria Nikolaus Johann Jacob Philipp Franz Joseph Sylvester Freiherr von und zu Guttenberg, and guess what? His "last name" is von und zu Guttenberg. He's not a one-off case either. De Luca is a family name, separated by a space.

     I have a grandmother, and in Hungarian custom, a last name is actually your given name. Sztaki Helen is her proper full name, except her brother might be called Sztaki Fred, her father named Sztaki Greg. A similar thing exists for my Chinese friend Dai Wai, where Dai is also his family name.

     As it turns out, names are damn confusing. Instead of researching and planning for all of these various rules just to figure out what someone's called, especially when you base it off of "first name" and "last name" (Don't call my grandmother Mrs. Helen, that's her given name not family name), step back and think about why you actually need to collect all this personal information about me.

     I'd go on and totally blow your mind by explaining that not all cultures sort names alphabetically either, or that they even don't have a roman alphabet, but lets not go there just yet.

     Do you actually need my personal information? Probably not. In some cases you will, in most... you don't. Don't ask for it.

     If you really really do need it, ask for Sur Name and Given Name(s). Store it as two columns.

     Other Answers

     Answered Sep 14, 2011 · 2 votes

     Two separate columns is almost always better.

     You can always compute the full name from two separate columns. It's much harder to split the name (given two word last names, middle names, suffixes, etc) from a single column.

     Check all answers on Stack Overflow

     5/5

   Show moreShow less

2. stackoverflow.com › questions › 46293417What is the difference between database name and username?

   stackoverflow.com › questions › 46293417

   • Cached

   Sep 19, 2017 · The database name is the name of the database and the username is the name of the user that is connected to the database. e.g. John Smith could connect to a database called Database1. Database1 would be the database name and John Smith would be the username.

3. builtin.com › data-science › databaseWhat Is a Database? (Definition, Types, Components) | Built In

   builtin.com › data-science › database

   • Cached

   Aug 24, 2023 · A database is simply a structured and systematic way of storing information to be accessed, analyzed, transformed, updated and moved (to other databases). To begin understanding databases, consider an Excel notebook or Google sheet. Spreadsheets like these are a basic form of a table.

4. dba.stackexchange.com › questions › 83438sql server - What is my database name? - Database Administrators...

   dba.stackexchange.com › questions › 83438

   • Cached

   Nov 24, 2014 · You cannot specify a database name within the Server Name field of that window in order to connect to it. For the server name you specify either server or server\instance name. You would connect to a specific database by setting this via the Connection Properties tab:

5. www.oracle.com › database › what-is-databaseWhat Is a Database? | Oracle

   www.oracle.com › database › what-is-database

   • Cached

   Nov 24, 2020 · A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS).

6. learn.microsoft.com › en-us › sqlRename a database - SQL Server | Microsoft Learn

   learn.microsoft.com › en-us › sql

   • Cached

   This article describes how to rename a user-defined database in SQL Server, Azure SQL Database, or Azure SQL Managed Instance, by using SQL Server Management Studio (SSMS) or Transact-SQL (T-SQL). The name of the database can include any characters that follow the rules for identifiers. Note.

7. learn.microsoft.com › en-us › sqlDB_NAME (Transact-SQL) - SQL Server | Microsoft Learn

   learn.microsoft.com › en-us › sql

   • Cached

   Dec 30, 2022 · Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) This function returns the name of a specified database. Transact-SQL syntax conventions.

8. learnsql.com › blog › sql-databaseWhat Is an SQL Database? | LearnSQL.com

   learnsql.com › blog › sql-database

   • Cached

   Nov 17, 2022 · Question: What is a database? A database is a structured set of data stored on a computer. Databases should be organized to efficiently store, retrieve, and manage information. They are essential for data analysis and management and are a key part of data-driven decision-making.

9. www.geeksforgeeks.org › database-table-and-column-naming-conventionsDatabase, Table and Column Naming Conventions - GeeksforGeeks

   www.geeksforgeeks.org › database-table-and-column-naming-conventions

   • Cached

   Aug 9, 2021 · Naming conventions are a set of guideline that make strong foundations for such a consistent system. These guidelines ensure that the names of database entities are readable, easy to use in queries and do not collide with names of other defined entities or keywords. Naming Databases :

10. www.baeldung.com › sql › database-table-column-naming-conventionsDatabase, Table, and Column Naming Conventions - Baeldung

    www.baeldung.com › sql › database-table-column-naming-conventions

    • Cached

    Apr 16, 2024 · Database naming conventions are the rules for naming diverse elements within a database: tables, columns, indexes, constraints, and various other objects. Although there are various conventions in practice, we can formulate general guidelines and principles. First, we need to be consistent.

11. www.oratable.com › find-your-database-name-in-oracleHow to Find Out Your Oracle Database Name - Oratable

    www.oratable.com › find-your-database-name-in-oracle

    • Cached

    Nov 2, 2009 · Oracle gives you easy ways to find out your Oracle database name from inside a SQL*Plus session. This article demonstrates three ways, using: V$DATABASE. GLOBAL_NAME. DBMS_UTILITY.GET_PARAMETER_VALUE. Similarly, here’s how to find your Oracle database version. {4 comments… read them below or add one } 1 MegSeptember 14, 2019 at 6:57 pm.