Ask your question Print Format Forum list Help them Statistics Search Charter Forum Webmastering

Statut : Not resolved

Database question

georgiebest678, on Sunday 18 May 2008 à 13:40:51

Hello,

Im going to try and create a member website. I will create one database with two tables. The first table will hold a email address and password. The second table will hold the info about that particular person. I am assuming that i would relate these two tables by the email address.

I can set up the code to take an email address and password and place it into a table and I can create a table that has a master detail relationship using the email address. This is my question.

Should I use the email address or should I use a number? auto increment

Also, how do i set up a database where say I give someone a space for a song, and they dont use that space, i would need to fll it with something i assume in order to coplete the row? Am i thinking right?

thanks

Configuration: Windows XP
Internet Explorer 6.0

Reply to georgiebest678 Report this message to moderators Go to last message

1This message seems useful, vote!
Ce message ne vous semble pas utile, votez !
Report this message to moderators

batmanba1, on Sunday 18 May 2008 à 14:52:28

Hello

You would only want/need one table. One good rule of thumb to determine if you need multiple tables is if there are any many-to-one relationships.

For example, if you were to allow users to enter multiple phone numbers then you would have a separate table for the phone numbers - each record having a id field pointing back to the user's id. If you were only going to allow 3 phone numbers you *could* just create three columns in the user table. But, you should always plan ahead for expansion.

For ID's you should use an auto-incrementing, unique field, typically the filed is just called id, or something similar.

For empty fields, just pass a value of NULL or an empty string "". There are a lot of subtletiels between an empty string and NULL which would take more space than this forum allows to explain.

Reply to batmanba1

Ask your question Reply

Résultats pour database question

Databases - DBMS models Databases appeared in the late 1960s, at a time when the need for a flexible information management system had arisen. There are five models of DBMS, which are distinguished based on how they represent the data contained: The hierarchical model: The... en.kioskea.net/bdd/bddtypes.php3

Databases - ODBC (Open Database Connectivity) ODBC stands for Open Database Connectivity. This is a Microsoft-defined format for communicating between Windows database clients and consumer DBMSs. The ODBC managier can be found in Windows 3.1 and 9x. In Windows 95 and 98, it is available in the... en.kioskea.net/bdd/odbc.php3

Databases - Data levels The ANSI/SPARC architecture, which dates from 1975, defines abstraction levels for a database management system: Internal (or physical) level: defines how data is stored, and how it is accessed. Conceptual level: also called the DRM (data... en.kioskea.net/bdd/bddansi.php3

Résultats pour database question

Graphical interfaces for SQLiteGraphical interfaces for SQLite SQLite is a powerful database management engine found in a relatively small C programming library; it requires no monitoring and can be used with most programming languages (C, C++, Java, Python). Unlike... en.kioskea.net/faq/sujet-629-graphical-interfaces-for-sqlite

MySQL real time monitoringMySQL real time monitoring You are administrating a MySQL database and you want to analyze in real time the operations taking place in order to have a diagnostics over probable problems, errors or to monitor server activity. PhpMyAdmin... en.kioskea.net/faq/sujet-561-mysql-real-time-monitoring

Ingres DocumentationIngres Documentation INGRES is the acronym for INteractive Graphics REtrieval System is initially a research project that started at Berkeley. It was an open source that was meant for database management and searches. It is now known to be a... en.kioskea.net/faq/sujet-494-ingres-documentation

Résultats pour database question

MySQL Help, PHP and Database help (Solved)Hello, I am building a form/blog/personal site for a small company. I was wondering if someone could help me in setting up my database. i have thought of a few options but i am not quite sure what one is the best. each user have a person page, they... en.kioskea.net/forum/affich-21728-mysql-help-php-and-database-help

How to merge an excel file to database? (Solved)Could someone please instruct me how to merge an excel file to database (MS Access/FoxPro/Oracle)? en.kioskea.net/forum/affich-19483-how-to-merge-an-excel-file-to-database

Sqlite database always lockedHello, I'm trying to create and update a sqlite (v3.5.8) database in a c++ program. I open the database using sqlite3 *db; sqlite3_open("database.db", &db); But any time I try to access the database after the call to open, sqlite returns... en.kioskea.net/forum/affich-8371-sqlite-database-always-locked

Résultats pour database question

Download Database Designer Platinum EditionDatabase Designer is a program for creating databases. It requires no programming knowledge. The application offers many tools: additions of fields, images, checks bugs correction syntactic and much more. It also allows the export of basic HTML, text... en.kioskea.net/telecharger/telecharger-1077-database-designer-platinum-edition

Download OpenOfficeOpenOffice is a free office application suite, including a word processor, spreadsheet, presentation tool, drawing package and database, compatible with all other major office suites like Microsoft Office (97-2007... en.kioskea.net/telecharger/telecharger-56-openoffice

Download DB Designer Allows you to handle your databases the most efficient way. DBDesigner 4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment. It combines a simple and clear... en.kioskea.net/telecharger/telecharger-273-db-designer

Résultats pour database question

Online database shows Britain-Australia linksDetails of millions of Britons who travelled to Australia in the late 19th and early 20th century in search of economic success were released online Wednesday as part of a social history collection. Details of millions of Britons who travelled to... en.kioskea.net/actualites/online-database-shows-britain-australia-links-10426-actualite.php3

Résultats pour database question

Databases - Introduction A database (abbreviated DB) is an entity in which data can be stored in a structured manner, with as little redundancy as possible. Different programs and different users must be able to use this data. Therefore, the concept of a database is... en.kioskea.net/bdd/bddintro.php3

Databases - Using forms In order to use databases, the user must be provided with an interface that allows him or her to view data based on certain criteria. There is a tool for this: forms. A form is an interface with components for displaying, entering, or selecting data.... en.kioskea.net/bdd/bddform.php3

Reliability - Database Replication Replication consists in ensuring data availability by synchronising copies of a data source on different servers. Replication is mainly used for database management systems that manage thousands or even millions of pieces of information whose... en.kioskea.net/surete-fonctionnement/replication-bases-donnees.php3