Click here to Skip to main content
14,743,192 members
Home » Discussions » Database
   

Database

 
GeneralRe: structure question 2 Pin
Richard Deeming19-Jul-19 2:27
mveRichard Deeming19-Jul-19 2:27 
PraiseRe: structure question 2 Pin
Joan M19-Jul-19 2:31
professionalJoan M19-Jul-19 2:31 
QuestionBest practices for database tables. Pin
RLD7114-Jul-19 13:37
professionalRLD7114-Jul-19 13:37 
AnswerRe: Best practices for database tables. Pin
CHill6018-Jul-19 0:17
mveCHill6018-Jul-19 0:17 
AnswerRe: Best practices for database tables. Pin
Mycroft Holmes18-Jul-19 12:57
professionalMycroft Holmes18-Jul-19 12:57 
GeneralRe: Best practices for database tables. Pin
RLD7121-Jul-19 4:37
professionalRLD7121-Jul-19 4:37 
Questionstructure question Pin
Joan M11-Jul-19 2:30
professionalJoan M11-Jul-19 2:30 
AnswerRe: structure question Pin
Eddy Vluggen11-Jul-19 3:01
professionalEddy Vluggen11-Jul-19 3:01 
Joan M wrote:
Have I done something terrible?
No, it's not VB6 nor JavaScript.

Joan M wrote:
Do you think this is a good structure?
Decent Smile | :)

Just a few questions;

Joan M wrote:
(N Tasks_In_Table will have 1 task)
I don't see that table's structure?

Joan M wrote:
Price per hour : number
Are you going to lookup a price and enter it manually for every task? How about a table with base-tasks and pricing to choose from? Perhaps with an additional column for discounts or extra?

Also, you use autonumbers for your keys; That means you can enter a customer twice, without problems. I'd prefer a unique constraint on the autonumber, and a PK on the customers name. It's a nice way to ensure that there's a single unique identifyable customer for each project. It'd also mean that a project would require a unique constraint on its autonumber for quick reference, but also a decent PK; the combination of the username and the projectname.

--edit
Free tip; if you're unsure about a structure, populate your example with mock-data and try some queries Smile | :)
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

GeneralRe: structure question Pin
CHill6018-Jul-19 2:30
mveCHill6018-Jul-19 2:30 
GeneralRe: structure question Pin
Eddy Vluggen18-Jul-19 23:53
professionalEddy Vluggen18-Jul-19 23:53 
QuestionQuery numbering in groups in access database ? Pin
Member 24584675-Jul-19 0:50
MemberMember 24584675-Jul-19 0:50 
SuggestionRe: Query numbering in groups in access database ? Pin
CHill6010-Jul-19 8:51
mveCHill6010-Jul-19 8:51 
GeneralRe: Query numbering in groups in access database ? Pin
Member 245846710-Jul-19 18:57
MemberMember 245846710-Jul-19 18:57 
GeneralRe: Query numbering in groups in access database ? Pin
CHill6010-Jul-19 22:38
mveCHill6010-Jul-19 22:38 
QuestionHow To Fix SQL Database Error 824 ? Pin
Member 24584673-Jul-19 23:10
MemberMember 24584673-Jul-19 23:10 
AnswerRe: How To Fix SQL Database Error 824 ? Pin
Richard MacCutchan4-Jul-19 0:44
mveRichard MacCutchan4-Jul-19 0:44 
AnswerRe: How To Fix SQL Database Error 824 ? Pin
Eddy Vluggen4-Jul-19 3:49
professionalEddy Vluggen4-Jul-19 3:49 
GeneralRe: How To Fix SQL Database Error 824 ? Pin
Member 24584674-Jul-19 18:40
MemberMember 24584674-Jul-19 18:40 
GeneralRe: How To Fix SQL Database Error 824 ? Pin
Victor Nijegorodov4-Jul-19 21:20
MemberVictor Nijegorodov4-Jul-19 21:20 
GeneralRe: How To Fix SQL Database Error 824 ? Pin
Member 24584675-Jul-19 0:49
MemberMember 24584675-Jul-19 0:49 
GeneralRe: How To Fix SQL Database Error 824 ? Pin
Victor Nijegorodov5-Jul-19 0:52
MemberVictor Nijegorodov5-Jul-19 0:52 
GeneralRe: How To Fix SQL Database Error 824 ? Pin
Richard MacCutchan5-Jul-19 2:47
mveRichard MacCutchan5-Jul-19 2:47 
GeneralRe: How To Fix SQL Database Error 824 ? Pin
Eddy Vluggen5-Jul-19 2:04
professionalEddy Vluggen5-Jul-19 2:04 
GeneralRe: How To Fix SQL Database Error 824 ? Pin
Member 245846718-Jul-19 19:21
MemberMember 245846718-Jul-19 19:21 
QuestionRe: How To Fix SQL Database Error 824 ? Pin
Eddy Vluggen18-Jul-19 23:54
professionalEddy Vluggen18-Jul-19 23:54 

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.