Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Access & PostgreSQL Question
- Where I work we have a database to track what our employees do each day. The database was originally created in MS Access but grew too large and unwieldy for Access, so we migrated it to a PostgreSQL database server and continued using Access as a front-end, due to...
- Tags: Databases, Microsoft Office, brian.mills@..., Microsoft Access, primary key, PostgreSQL
- Discussion threads 2007-11-02
- SQL Server
- For Simplicity;I have two tables in a database, say Customer table and Orders table.The customer table has two columns.i) Customer ID intPrimary keyii)Name(varchar(100))The orders table has two columns.i)Orders IDint which is a foreign key to the primary key mentioned above.ii)Sale Price intAs we know in SQL Server 2005 edition, the...
- Tags: Databases, server, ruchiram4@..., primary key, Microsoft SQL Server
- Discussion threads 2007-06-27
- Oracle join table and calculation problem
- Hi all and thanks in advance,I need to output the patient's name, patient's address, item_code, description, and total cost for a particular month in the folloing tables.Here are the tables CREATE TABLE patient( pati_Ref_no NUMBER(6) NOT NULL, ...
- Tags: alan.sarchnar@..., Oracle Corp., pati_Ref_no NUMBER, Varchar2, Primary Key, patient
- Discussion threads 2007-04-23
- Oracle join table and calculation problem
- Hi all and thanks in advance,I need to output the patient's name, patient's address, item_code, description, and total cost for a particular month in the folloing tables.Here are the tables CREATE TABLE patient( pati_Ref_no ...
- Tags: alan.sarchnar@..., Oracle Corp., pati_Ref_no NUMBER, Varchar2, Primary Key, patient
- Discussion threads 2007-04-23
- Oracle join table and calculation problem
- Hi all and thanks in advance,I need to output the patient's name, patient's address, item_code, description, and total cost for a particular month in the folloing tables.Here are the tables CREATE TABLE patient( pati_Ref_no ...
- Tags: Oracle Corp., alan.sarchnar@..., pati_Ref_no, Varchar2, Primary Key, patient
- Discussion threads 2007-04-23
- Get practical database normalization tips
- The database organization process called normalization is aseries of steps to guide you through analyzing and designing relations in yourdatabase schema; the goal is to try to reduce redundant data and inconsistentfunctional dependencies. This series of rules originally developed by Dr. E. F. Codd is comprised of what are known...
- Tags: database, normalization, Primary Key, spreadsheet, Storage, Tim Chapman
- Technical articles 2006-11-20
- Delete + Sql server
- Hello,Three tables are there A, B, C. In table A the primary key id 'AId' which is forigen key in the other two tables.I want that if I delete 1 row from table A the corresponding rows from tables B & C should be automatically deleted.Got it or not?If anybody...
- Tags: preethiraajesh@..., sql server, delete row, primary key, software, Microsoft SQL Server, server
- Discussion threads 2006-08-28
- Inserting specific values into identity columns
- If you inherit a database that was created by another developer, it may not be designed to your standards. Arthur Fuller demonstrates how you can tackle a specific problem that you might encounter in these databases: how to rebuild a table (T1), while preserving the primary key PK values in...
- Tags: T2, T1, Databases, Arthur Fuller, Network technology, primary key, identity key, accounting, SQL Server Newsletter, TechRepublic Inc., Database, Statement, Networking, Enterprise Software, Software, Data Management
- Technical articles 2005-07-11
- MS Access 2002 - Building a Primary Key
- I'm new at using MS Access. I've gone to the Fred Pryor Workshops - Beginning and Advanced, and I bought the MS Access 2002 Bible. According to the Bible, it can be done, but I'm having trouble understanding the details of how to create the Primary Key that I want.I'm...
- Tags: FamilyID, Primary Key, SerialNo, mtennant@..., software, Microsoft Corp., Microsoft Access
- Q&A 2006-05-15
- SQL constraint question
- Hello, does anyone know how to do this? I'm supposed to for an assignment and dont even know how to begin. I was hoping someone might be able to explain it. Using the following CREATE TABLE statements, add AND EXPLICITLY NAME the listed constraints specified for each table. Use the...
- Tags: bradq@..., CREATE TABLE, Null, programming, SQL, VARCHAR2
- Q&A 2005-11-08
- Access weird index
- We have an Access database that has just decided to go wacky. All of a sudden the Primary Key index is creating some odd numbers instead of autonumbering like it always has. Here is an example: "-1183110303". I deleted the records that started appearing with these strange...
- Tags: AutoNumber, ddevans888@..., Microsoft Access, Primary Key, Value at Risk
- Q&A 2005-04-25
- Implementing a relational database using MySQL
- Whenproperly implemented, a relational database can greatly enhance theavailability of data and information for an enterprise's decision makers.However, deploying a relational database on almost any scale requires athorough understanding of the fundamental concepts and rules that govern theirbehavior.Although mySQL is one of the most popular relational database applications available, thatdoes...
- Tags: database, RDBMS, Mark Kaelin, primary key, MySQL, Arthur Fuller
- Technical articles 2005-04-05
- Many to one with null table?
- Okay I've created a relationship on many to one and many to one on 3 tables. The issue i'm running into is if table 3, there isn't any data to enter or table 2 needs no data but i have data to put in table 3. I need...
- Tags: CompanyID, natasha.epperson@..., primary key, software, telephone
- Discussion threads 2005-03-21
- Oracle Tip: Solving directed graph problems with SQL, part 1
- A common advanced computer science problemcan be described under the heading of "directed graphs." A directedgraph is a finite set of nodes connected by a set of vectors oredges. For example, a node can be imagined as a "city" and eachvector as a "flight" between two cities. ...
- Tags: Scott Stephens, SQL, Oracle Corp., airports value, JFK, primary key, Sao Paulo, graph problem
- Technical articles 2004-06-23
- Oracle Tip: Understand the difference between star and snowflake schemas in OLAP
- This article originally appeared in the Oracle e-newsletter. Click here to subscribe automatically. At the core of data warehouse applicationsand OLAP online analytical processing is a specialized schemathat relaxes the rules of Third Normal Form RDBMS schemas in favorof faster analysis and processing of large amounts of data. It'simportant to...
- Tags: Data mining, Databases, Storage, OLAP, Scott Stephens, Oracle Corp., schema, foreign key, primary key, id number
- Technical articles 2004-05-27
- Constrain your SQL Server data with T-SQL
- The process of creating data constraints via the graphical interfaces provided with Microsoft SQL Server was covered in the article "TechRepublic Tutorial: Enforce data integrity with constraints and Enterprise Manager." While this approach is straightforward, it's not the only method available. The SQL Server version of SQL, T-SQL, provides ample...
- Tags: primary key, Baseline Inc., Microsoft SQL Server, server, Microsoft SQL Server Transact-SQL
- Technical articles 2004-02-20
- Database normalization starts with the keys
- Database normalization protects data integrity by removing ambiguous data relationships. Eric Roland explains the roles that primary, foreign, and composite keys play in normalization.Database normalization is a fundamental premise in database design because it removes ambiguous relationships between data, helping protect data integrity. Before diving into the first three of...
- Tags: Databases, Social Security, Figure C, Normalization, primary key, normalization, database, Database normalization
- Technical articles 2002-08-08
- Foreign key definition renders primary key irrelevant
- Any discussion on primary keys is bound to stir up a debate. Some developers insist that a primary key’s only purpose is to uniquely identify records. Others believe that as a part of the relational model, its purpose includes relating records. However, it's difficult to stir up this same kind...
- Tags: Databases, superkey, primary key, foreign key
- Technical articles 2003-01-06
- The great primary-key debate
- Which makes for a better primary key: natural data points or meaningless values? Database developers have strong opinions on this facet of primary key design. This article settles the debate once and for all.By definition, a relational database must contain normalized tables, and to be properly normalized, a table must...
- Tags: Databases, Social Security, Operational accounting, primary key, RDBMS
- Technical articles 2002-03-22
- Teach your Access users to be wary of AutoNumbered primary keys
- Too often, end users don't realize the importance of choosing the right primary keys for their Access tables. This article outlines the potential problems that can occur when using an AutoNumbered primary key.As an active Microsoft Access developer, I’ve got a good view of one side of the database development...
- Tags: Microsoft Office, Databases, ignorance, Peter Nelson, primary key, Microsoft Access, AutoNumbered
- Technical articles 2002-02-05
- << Previous
- page 1 of 1
- Next >>
