SQL database design

75 pts.
Tags:
Database
Database design
SQL Database
SQL Server database
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 when the number of rows be more than million in salary tabe ?



Software/Hardware used:
sqlserver

Answer Wiki

Thanks. We'll let you know when a new response is added.

one table with 40 columns sounds like you have not normalized the data.

I suggest you investigate data normalization as it applies to RDBMS theory.

Will what you have work? Probably. Will it work well? Not as well as it could.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    I agree with Meandyou. There is probably a normalization issue. However, if no normalization issues exist, make sure that the appropriate indexes exist and the database server is correctly configured (memory and storage) to offer acceptable perfomance with that amount of data and its expected growth.
    69,475 pointsBadges:
    report
  • msmj86
    thanx carlosd and meandyou im in the programe designing step but i make a test by vb.net loop adding more than 1000000 rows to the salary tabe it worke but sloo
    75 pointsBadges:
    report
  • msmj86
    there is no normalization available carlosd............... plz what you mean by:- configured (memory and storage
    75 pointsBadges:
    report
  • carlosdl
    I'm not sure you understand what normalization is. As for your last question, database management systems usually have settings to properly configure the use of memory and storage according to the amount of data and the expected type and frequency of transactions, among other things. This is the DBA's job. P.s. I'm not a DBA ;-)
    69,475 pointsBadges:
    report
  • msmj86
    THANXXX CARLOSD
    75 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following