Click here to Skip to main content
12,241,564 members (60,250 online)
   

Database

 
AnswerRe: Oracle SQL Developer Pin
David Mujica11-Jul-12 3:39
memberDavid Mujica11-Jul-12 3:39 
GeneralRe: Oracle SQL Developer Pin
vanikanc11-Jul-12 4:01
membervanikanc11-Jul-12 4:01 
GeneralRe: Oracle SQL Developer Pin
David Mujica11-Jul-12 4:09
memberDavid Mujica11-Jul-12 4:09 
GeneralIntroduce integerity in the database Pin
sharp_k9-Jul-12 5:08
membersharp_k9-Jul-12 5:08 
GeneralRe: Introduce integerity in the database Pin
Wayne Gaylard9-Jul-12 5:24
mentorWayne Gaylard9-Jul-12 5:24 
GeneralRe: Introduce integerity in the database Pin
sharp_k9-Jul-12 5:47
membersharp_k9-Jul-12 5:47 
GeneralRe: Introduce integerity in the database Pin
jschell9-Jul-12 13:26
memberjschell9-Jul-12 13:26 
AnswerRe: Introduce integerity in the database Pin
Jörgen Andersson9-Jul-12 20:52
memberJörgen Andersson9-Jul-12 20:52 
Like others have said, you need to normalize your database.

When a customer is renewed you don't get a new customer and should therefore not get a new entry in the customer table, but rather a new entry in the subscription table or customer history table or whatever table makes most sense to your system.

As we don't know much about you database we can only give you generalized advice. Mine would be to read this[^] article.
It describes in an easy to understand way how to, and why, you normalize your database.
Light moves faster than sound. That is why some people appear bright, until you hear them speak.
List of common misconceptions

GeneralRe: Introduce integerity in the database Pin
mark merrens9-Jul-12 6:17
membermark merrens9-Jul-12 6:17 
QuestionRe: Introduce integerity in the database Pin
Eddy Vluggen9-Jul-12 13:52
memberEddy Vluggen9-Jul-12 13:52 
AnswerRe: Introduce integerity in the database Pin
mark merrens10-Jul-12 13:05
membermark merrens10-Jul-12 13:05 
GeneralRe: Introduce integerity in the database Pin
PIEBALDconsult9-Jul-12 11:54
memberPIEBALDconsult9-Jul-12 11:54 
AnswerRe: Introduce integerity in the database Pin
Eddy Vluggen9-Jul-12 13:51
memberEddy Vluggen9-Jul-12 13:51 
Questionwhy (Object reference not set to an instance of an object)?! Pin
jrahma8-Jul-12 22:48
memberjrahma8-Jul-12 22:48 
AnswerRe: why (Object reference not set to an instance of an object)?! Pin
Simon_Whale9-Jul-12 5:24
memberSimon_Whale9-Jul-12 5:24 
AnswerRe: why (Object reference not set to an instance of an object)?! Pin
Luc Pattyn9-Jul-12 14:06
mvpLuc Pattyn9-Jul-12 14:06 
Questionupdate table structures from another server Pin
jrahma8-Jul-12 21:37
memberjrahma8-Jul-12 21:37 
AnswerRe: update table structures from another server Pin
Wayne Gaylard8-Jul-12 22:27
mentorWayne Gaylard8-Jul-12 22:27 
Questiontransfer mysql proceedures Pin
jrahma8-Jul-12 21:35
memberjrahma8-Jul-12 21:35 
QuestionError can not attach a database with the same name? Pin
Member 24584675-Jul-12 19:18
memberMember 24584675-Jul-12 19:18 
AnswerRe: Error can not attach a database with the same name? Pin
Midnight Ahri5-Jul-12 23:21
memberMidnight Ahri5-Jul-12 23:21 
GeneralRe: Error can not attach a database with the same name? Pin
Member 24584678-Jul-12 19:32
memberMember 24584678-Jul-12 19:32 
AnswerRe: Error can not attach a database with the same name? Pin
Mycroft Holmes6-Jul-12 0:37
memberMycroft Holmes6-Jul-12 0:37 
QuestionCopy stored procedures to another database why not? Pin
Member 24584675-Jul-12 18:34
memberMember 24584675-Jul-12 18:34 
AnswerRe: Copy stored procedures to another database why not? Pin
Mycroft Holmes5-Jul-12 18:52
memberMycroft Holmes5-Jul-12 18:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.160426.1 | Last Updated 29 Apr 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid