Click here to Skip to main content
15,167,467 members
Home / Discussions / Database
   

Database

 
GeneralRe: Error when passing multiple values Pin
Jassim Rahma13-Aug-16 12:12
MemberJassim Rahma13-Aug-16 12:12 
GeneralRe: Error when passing multiple values Pin
Victor Nijegorodov13-Aug-16 12:15
MemberVictor Nijegorodov13-Aug-16 12:15 
GeneralRe: Error when passing multiple values Pin
Jassim Rahma13-Aug-16 12:21
MemberJassim Rahma13-Aug-16 12:21 
GeneralRe: Error when passing multiple values Pin
Mycroft Holmes13-Aug-16 15:04
professionalMycroft Holmes13-Aug-16 15:04 
GeneralRe: Error when passing multiple values Pin
Jassim Rahma15-Aug-16 9:16
MemberJassim Rahma15-Aug-16 9:16 
GeneralRe: Error when passing multiple values Pin
Mycroft Holmes15-Aug-16 14:02
professionalMycroft Holmes15-Aug-16 14:02 
QuestionHow do Coders Get Database Experts? For a project Pin
TheOnlyRealTodd8-Aug-16 21:58
professionalTheOnlyRealTodd8-Aug-16 21:58 
AnswerRe: How do Coders Get Database Experts? For a project Pin
Mycroft Holmes9-Aug-16 14:04
professionalMycroft Holmes9-Aug-16 14:04 
Do NOT get a book on database administration, yet. Get a book on database DEVELOPER, admin and dev are very different roles. There is also as site with sample database, ah found it[^], pick one close to your industry and try and understand why the design was used. He is pretty good and faithful to the rules of DB design.

After you have got a feel for DB design feel free to ask silly, or not so silly question here.

Your first 3 questions are answered by foreign keys
You should create 1 table per CLASS of inventory (if an items attributes are so different to an existing class then create a new class).

Your application should NEVER create a new database except for backup (and this should be an admin job not application).

If your scale is going to so huge (as in multiple of terabytes) that storage is an issue then you could split the data into different databases but I have never had to do that.
Never underestimate the power of human stupidity
RAH

AnswerRe: How do Coders Get Database Experts? For a project Pin
Nathan Minier10-Aug-16 2:21
professionalNathan Minier10-Aug-16 2:21 
AnswerRe: How do Coders Get Database Experts? For a project Pin
jschell12-Aug-16 12:15
Memberjschell12-Aug-16 12:15 
QuestionHow to pass varchar as WHERE field IN param Pin
Jassim Rahma5-Aug-16 6:14
MemberJassim Rahma5-Aug-16 6:14 
AnswerRe: How to pass varchar as WHERE field IN param Pin
Mycroft Holmes5-Aug-16 14:04
professionalMycroft Holmes5-Aug-16 14:04 
AnswerRe: How to pass varchar as WHERE field IN param Pin
David Mujica9-Aug-16 7:20
MemberDavid Mujica9-Aug-16 7:20 
QuestionIs this SQL query about getting information from all forum users' unread PMs? Pin
Member 1266244831-Jul-16 2:41
MemberMember 1266244831-Jul-16 2:41 
AnswerRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Eddy Vluggen31-Jul-16 3:20
professionalEddy Vluggen31-Jul-16 3:20 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Member 126624481-Aug-16 3:04
MemberMember 126624481-Aug-16 3:04 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Eddy Vluggen1-Aug-16 8:35
professionalEddy Vluggen1-Aug-16 8:35 
AnswerRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
User 1106097931-Jul-16 3:23
MemberUser 1106097931-Jul-16 3:23 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Member 126624481-Aug-16 3:01
MemberMember 126624481-Aug-16 3:01 
QuestionRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
User 110609791-Aug-16 3:07
MemberUser 110609791-Aug-16 3:07 
AnswerRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Member 126624485-Aug-16 2:04
MemberMember 126624485-Aug-16 2:04 
AnswerRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Richard Deeming1-Aug-16 3:21
mveRichard Deeming1-Aug-16 3:21 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Eddy Vluggen1-Aug-16 11:55
professionalEddy Vluggen1-Aug-16 11:55 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Member 126624485-Aug-16 2:21
MemberMember 126624485-Aug-16 2:21 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Richard Deeming5-Aug-16 2:56
mveRichard Deeming5-Aug-16 2:56 

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.