Visual Basic and SQL database design
i have vb.net & sql  application sql database have one tabe with 37 column (there is no normalization) after runing the application more than three million of rows will enterd by users . I’m afraid  it Will give a bad performance  or have (out of memory massge) so i Made a solution (i make [strong]Queries(with vb.net  wich [...]

Answer Question   |  March 31, 2012  6:56 AM
Database design, SQL Database, VB.NET, Visual Basic, Visual Basic .NET

SQL database design
i have slary system using vb.net  and sql server there is  27 user the compute up to  700 employ salary every monthe i collecte (700 *27) number of row and adding them programaticaly to a table called salary the table salary have 40 column with one primery key  is there any proplem with this algorthim [...]

Answer Question   |  March 31, 2012  6:09 AM
Database, Database design, SQL Database, SQL Server database design and modeling

Showing or hiding fields in an Access report
I have a db created for managing employee records. I would like to build a label report that shows or hides different fields on the label depending if a field has a value. The fields are Office, home address, city, state, and zip. If the member has an office location then i would like to [...]

Answer Question   |  October 30, 2010  10:08 PM
Access Database, Access reports, Database design, Database Development, Database management

Creating Access table
How do I create an ERDiagram from this table of information? Table=CUSTOMER- Customer_ID LastName FirstName Address PhoneNumber ContactNumber Email Address and add the following tables with this information: Table names: COSIGNEE -DRIVERS- PICKUPMANIFEST-DELIVERY_TRUCK_DETAILS-DELIVERY_MANIFEST

Answer Question   |  October 18, 2010  8:04 PM
Access, Access Database, Access Database Design, Access Tables, Database design, ER diagrams, Windows 7

SQL Server 2005 database design
What is 1*,o* 1..1,1..*,0..*,1..* in databse design,i have no exact idea about this,need help. 

Answer Question   |  September 14, 2010  3:57 AM
Database design, SQL 2005, SQL 2005 Database design, SQL Database, SQL Server, SQL Server 2005

Indexing in Microsoft SQL
What is an index in Microsoft SQL? What types of indexes are available in SQL Server 2005? Do I need to know about this to create and deploy a database?

Answer Question   |  August 27, 2010  8:08 PM
Database design, SQL, SQL Database, sql indexes, SQL Server 2005, SQL Server 2005 index strategy

Creating DB of stories from documents for a website
I want to create and maintain a database for a personal library; if it works, I would like to make it available online. I know there are several already available but I’m trying to set up something specific – something for the fanfiction community. (For those not in the know, ‘fanfiction’ is simply fiction written [...]

Answer Question   |  January 13, 2012  5:55 AM
Access Database, Access Database Design, Database design, Database Development, Database issues, Web development, Web development tools

Writing procedures for two databases I designed. How do I print the screens to attach to the procedure?
Writing procedures for two databases I designed. How do I print the screens to attach to the procedure?

Answer Question   |  August 16, 2010  2:48 PM
Database design, Print screen, Stored Procedures

Databases vs. Data Structures
I am working for a website company that uses data structures heavily, as opposed to databases. Could someone help me understand the difference between these two? I am recruiting for this company, but am a non-technical person.

Answer Question   |  July 23, 2010  8:20 PM
Data Area Data Structure, Data management, Data structures, Database design, Database servers, Databases

Database structure and application outsource protocol
When an application has been outsourced, Don’t the software developer need to share the database structure with the client prior to development

Answer Question   |  July 16, 2010  5:10 PM
Application development, Database design, Database Development, Database structure, SDLC, Software Development Process

Database Design Help
Organizations make business deals with other organizations. When negotiating a specific deal, each organization is represented by one lawyer. The same organization can have deals with many other organizations and it might use different lawyers in each case. Each lawyer has a first and last name, address (Street, City, State, Zip), specialization and fee. Each [...]

Answer Question   |  June 9, 2010  6:33 AM
Database, Database design, Database optimization

Help with Database Structure
I need to create a databse that keep track of a Item # and associated with that Item# is 2 type of people. DonorID and OwnerID. Both these type of people i want listed in the same Table. So far my structure looks like so. [strong]tblItems  [/strong]                  [strong]   tblPerson[/strong]        Item#                           PersonID(want linked to DonorID & OwnerID) Description                    LastName DonorID([em]dropdownList[/em])    FirstName [...]

Answer Question   |  January 7, 2010  5:19 PM
Access 2007, Database design, Database structure

What are the points to be taken care of when designing a database on Linux?
What are the points to be taken care of when designing a database on Linux? What are the different replication methods available?

Answer Question   |  October 27, 2009  2:39 PM
Database design, Database replication, Linux databases

database
How to make an offline database that can be access through network

Answer Question   |  October 16, 2009  11:48 AM
Database administration, Database design

DB question(s) that I have never heard a direct answer for
In designing a database for use where I work, I ran smack-dab into a few old questions I have always had relating to relational databases.  I say “old” questions because I developed them a long time prior.  However, I think the answers are entirely relevant today (obviously, otherwise I wouldn’t have run into them again). [...]

Answer Question   |  September 24, 2009  10:03 PM
Database, Database design

Advantages and disadvantages of MySQL 5.0
Can someone explain me what are the advantages and disadvantages of MySQL 5.0??

Answer Question   |  December 7, 2010  1:05 PM
Database design, MySQL, MySQL 5.0

With an Access form based on 1 table, can I have info from a related table automacially appear based on linked field?
With a form based on 1 table, can I have info from a related table automacially appear based on linked field? For example, let’s say I have two tables linked by a Vendor ID number. On a form that is based on the Purchase Order table, I’d like the Vendor name to automatically appear on [...]

Answer Question   |  July 11, 2009  4:11 AM
Access 2007, Access Database, Access forms, Database design, Microsoft Access

Unique ID for existing table
I want to add a column to an existing table where its values should be unique and auto generated in a sequential order

Answer Question   |  April 21, 2009  11:15 AM
Auto increment, Database design, Database programming, SQL

How to implement a “is a”/generalization relationship in an ERD?
I’m using SQL Server 2005 Developer edition.

Answer Question   |  April 22, 2009  2:19 AM
Database design, Database Development, ERD

SQL query and Oracle database design help needed
Sorry for all the confusion with the questions.So let me clear myself,i am doing this not as assignment or homework,but something which interests me and trying to leran.Earlier as I stated that its a part of my school(** well frnakly speaking, it was my plan if i could put this as an item of the [...]

Answer Question   |  February 23, 2009  6:22 AM
Database design, Oracle development, Oracle SQL, SQL, SQL queries