Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
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 20 of 20
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, 12:54 PM
Replies: 5
Views: 9,443
Posted By frdata
The code worked perfectly. Thank you very much...

The code worked perfectly. Thank you very much for sharing it here.

I have tried to turn off the Primary Key constraint for StudentID and Access allows duplicate values in it using the code you...
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 May 13th, 2014, 01:19 AM
Replies: 5
Views: 9,443
Posted By frdata
Smile What can I say. Brilliant answer! Your...

What can I say. Brilliant answer!

Your answer is comprehensive and this proves that you're an expert in many aspects of database programming.

Quote : " I'm glad you're finding it useful! (Post...
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 May 12th, 2014, 12:46 PM
Replies: 5
Views: 9,443
Posted By frdata
Concatenated Surrogate Key replacing AutoNumber Key

Hi Rod,

The more I read your book, the more I discover precious gems hidden in it.

I'm creating a surrogate key, StudentRefNo, in Students table for new students registration. (I already have a...
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 May 11th, 2014, 11:00 AM
Replies: 11
Views: 2,885
Posted By frdata
Fantastic solution. The GradeResults...

Fantastic solution.

The GradeResults structure is what I'm looking for and it fits nicely in the model. Incredibly concise.

Your sql code on how to use it is also very helpful.

I could load...
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 May 10th, 2014, 02:00 AM
Replies: 11
Views: 2,885
Posted By frdata
Thank you for still offering to help although you...

Thank you for still offering to help although you have allocated a lot of time answering this thread.

OK Sir. Let me be clearer on the question.

I already know how to calculate total score...
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 May 9th, 2014, 02:57 PM
Replies: 11
Views: 2,885
Posted By frdata
I'm sorry you are not feeling well. And I...

I'm sorry you are not feeling well.

And I rarely find someone with such enthutiasm that you have.

Anyways, I think that you are giving a reply before my last edit.

Would you pls have a look...
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 May 9th, 2014, 01:56 PM
Replies: 11
Views: 2,885
Posted By frdata
Hello, I'm referring to figure B-16 on page...

Hello,

I'm referring to figure B-16 on page 478. CourseOfferings is listed as one of the tables.

I'm sorry that I was not specific enough. Actually this is the continuation of my previous...
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 May 9th, 2014, 03:40 AM
Replies: 11
Views: 2,885
Posted By frdata
Hello, I have searched a lot of places about...

Hello,

I have searched a lot of places about Student-grades. However I found that your design is more extensive because it includes the StudentGrades capability.

And your CourseOfferings table...
Forum: BOOK: Access 2010 VBA Programmer's Reference May 8th, 2014, 04:04 AM
Replies: 3
Views: 1,447
Posted By frdata
Thats great! I thought crosstab query can...

Thats great!

I thought crosstab query can only be used for summary purposes.

This is something useful and more importantly, easy to use.

Thanks so much
Forum: BOOK: Access 2010 VBA Programmer's Reference May 7th, 2014, 02:39 PM
Replies: 3
Views: 1,447
Posted By frdata
Flatten a Single Relational Table

Hello authors,

I could not find any vba code in the book to perform the following. Please offer some support.

I have a table StudentResults(StudentName, CourseName, Grade) containing the...
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 May 5th, 2014, 03:42 AM
Replies: 7
Views: 1,724
Posted By frdata
Hi again, To test my understanding, can I do...

Hi again,

To test my understanding, can I do the following :

First, I think StudentCourses could be removed because it is redundantly represented with CourseResults. Then, the unique key would...
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 May 4th, 2014, 02:23 PM
Replies: 7
Views: 1,724
Posted By frdata
Thanks for all the explanation. I'm trying to get...

Thanks for all the explanation. I'm trying to get slowly to Figure B-16 on page 478 which I think is a very useful design. Your explanation in the other thread about figure B-16 helped a lot and gave...
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 May 4th, 2014, 01:44 PM
Replies: 7
Views: 1,724
Posted By frdata
Thanks for the prompt reply. I guess its ok...

Thanks for the prompt reply.

I guess its ok if you look it that way.

Now, for figure A-6 on page 420, should the primary key of Courses be Courses(CourseID, InstructorID). Projects(ProjectId,...
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 May 4th, 2014, 11:30 AM
Replies: 7
Views: 1,724
Posted By frdata
Exercise 2 and 3 Chapter 5

Hi Rod,

I'm trying to understand the solution given for exercise 2 and 3 in chapter 5. In Figure A-5 on page 418, it is written 1.1 to the left of the Course entity. I think it should be 0.N....
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 April 3rd, 2014, 10:16 AM
Replies: 11
Views: 2,885
Posted By frdata
Thank you for the reply. Your explanation of the...

Thank you for the reply. Your explanation of the purpose of StudentGrades is very helpful. It gave me new insights about this problem space.

Yes, I agree with you that this design could be...
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 April 2nd, 2014, 10:58 PM
Replies: 11
Views: 2,885
Posted By frdata
Students,Courses, and Grades

Hello Rod,
I am trying to implement one of the models that you listed in Appendix B. I am using vb6 frontend and Access backend

For the moment, I have three questions based on figure B-16 page...
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 November 25th, 2011, 11:30 AM
Replies: 7
Views: 1,447
Posted By frdata
I'm very clear about everything you explained....

I'm very clear about everything you explained. Thank you.

One final question in this post :

I would like to know why do we need the CustomerID in the [Customers] table. Wouldn't it be enough to...
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 November 24th, 2011, 08:13 PM
Replies: 7
Views: 1,447
Posted By frdata
Hello again Rod, 1. How is the [Persons]...

Hello again Rod,

1. How is the [Persons] table helpful in this design? Can we not just place the fields in their respective [Employees], [Vendors] and [Customers] tables?

2. Lets say we want to...
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 November 24th, 2011, 01:09 PM
Replies: 7
Views: 1,447
Posted By frdata
Thanks for the fast reply. That 1 to many...

Thanks for the fast reply.

That 1 to many bug has been bugging me quite a while. Like you said, it crept quite early in the chapters.

Now things are more clearer. Anyway the second edition with...
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 November 24th, 2011, 10:32 AM
Replies: 7
Views: 1,447
Posted By frdata
Implementation of Figure 14.4

Hello Rod. I have read a few of your books. No doubt your approach of database design is superior from others. They are very practical. However I'm quite disappointed that you do not implement the...
Showing results 1 to 20 of 20

 


All times are GMT -4. The time now is 10:38 AM.


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