Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 7 of 7
Search took 0.01 seconds.
Search: Posts Made By: frdata
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 May 13th, 2014, 11:38 AM
Replies: 5
Views: 9,165
Posted By Rod Stephens
Unfortunately I haven't had time to maintain the...

Unfortunately I haven't had time to maintain the VB Helper site much. That site is probably about 2/3 VB .NET at this point. Unfortunately the VB book market isn't as strong as the C# market so I'm...
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 May 12th, 2014, 04:35 PM
Replies: 5
Views: 9,165
Posted By Rod Stephens
[:)] I'm glad you're finding it useful! (Post a...

[:)] I'm glad you're finding it useful! (Post a review when you have a chance.)



Good question. Basically you're generating the Student IDs yourself. The auto-generated StudentID is used as a...
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 May 10th, 2014, 01:49 PM
Replies: 11
Views: 2,857
Posted By Rod Stephens
Yes, you could do that. The GradeResults table...

Yes, you could do that. The GradeResults table would have fields:



CourseOfferingId (or CourseId)
MinScore
Grade


MinScore would be the minimum score you need to get the grade.
Forum: BOOK: Access 2010 VBA Programmer's Reference May 7th, 2014, 04:41 PM
Replies: 3
Views: 1,447
Posted By malcolmdixon
Hi, Do you mean SQL to query your table and...

Hi,

Do you mean SQL to query your table and provide the results in the format you show? You need to create a crosstab query.


TRANSFORM First(StudentResults.Grade) AS FirstOfGrade
SELECT...
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 May 5th, 2014, 12:05 PM
Replies: 7
Views: 1,714
Posted By Rod Stephens
They're not redundant if StudentCourses...

They're not redundant if StudentCourses represents current enrollment and CourseResults represents past courses. But you could merge them as you say. (There are some differences between current and...
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 May 4th, 2014, 02:04 PM
Replies: 7
Views: 1,714
Posted By Rod Stephens
ER diagrams are kind of like that, I think....

ER diagrams are kind of like that, I think. They're really focused on relationships.



I think they only need the CourseId and ProjectId, but it will depend to an extent on the business model....
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 April 3rd, 2014, 01:02 AM
Replies: 11
Views: 2,857
Posted By Rod Stephens
That's just an oversight. You're right,...

That's just an oversight. You're right, InstructorID should connect those tables.



Do you mean have a table with values like "Quiz1" and "Midterm" in it so you can validate the GradeItem values...
Showing results 1 to 7 of 7

 


All times are GMT -4. The time now is 09:14 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.