Click here to Skip to main content
15,173,152 members
Home / Discussions / Database
   

Database

 
GeneralRe: Error when passing multiple values Pin
Richard MacCutchan13-Aug-16 9:29
mveRichard MacCutchan13-Aug-16 9:29 
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 
So here's the thing. I am a new coder and I am working on my first big project from scratch. My project is using ASP.NET MVC, Google Maps API, Entity Framework, with SQL Server.

I got a very early protype started on my local machine but I'm starting to run into database design complications. I am already new to coding, but somehow have managed to figure out MVC and get a Web API going. However, I am even less experienced than that with databases and database administration. I know how to add/remove database objects and set up tables and all that jazz; that's not a big deal. But I'm having questions such as:

*What is the best way to associate user accounts in my system with their business' information...
*I want my users to be able to add/remove products to their business' inventory table... What is the best way to set up the database to store each individual product.
*What is a good way to pair the information given to me via business owners with the data I pull from Google API.

*Should I create a new object for each inventory item or just list it in a long text string of all inventory items since no details will be needed?

*When do I have my application create an entire new database versus just add a new table in an existing database? For example, should user accounts and businesses be in two separate databases?

And more...

These questions are less coding questions and more database setup/administration questions... Questions I'd love to ask someone who has made a big modern commercial database before that handles accounts and inventory and all that. Obviously, coding questions will come up too but a lot of it is just database design.

So, my real question here is... How do most coders do this? I would iamgine a lot of coders are not DB experts... Should I buy a Database Administration book and read it? Should I consult an expert? Since this will be a data-driven application, database setup is important. Thanks!

PS: Please, don't worry about me being overwhelmed. I mean, if this is something that will seriously take 6 months of dedicated study, it may be better left for me to call up someone else... But even though I just started programming a few months back, I'm actually loving getting into all of this and it is not intimidating at all.

modified 9-Aug-16 4:51am.

AnswerRe: How do Coders Get Database Experts? For a project Pin
Mycroft Holmes9-Aug-16 14:04
professionalMycroft Holmes9-Aug-16 14:04 
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 

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.