James
I recommend that you look at the Student Examms Data Model I told you about before.
From your description of your problem it is not clear what your table sloo like, except that you seem to say you have three identical tables.
This is hard to…
Hi Anna
You can download my Apartment Rentals Database at number 16 on this page :-
http://www.databaseanswers.org/database_downloads.htm
It will be very helpful for you in thinking about how to adapt and extend the Database to meet your requireme…
Oh, you mentioned test procedures. Just another fitness test.
A question? How frequently have you seen the authors of the code running the test procedures?
Thanks for the welcome;)
Yeah, that style of code is everywhere, particularly older code with a larger pool of developers who have not interacted directly with each other.
Your thought that it is like that (difficult to understand, disordered - sp…
Hi Brian
Your idea would work OK. To confirm it, try thinking the the process of adding data.
Here is a different approach, based on the idea of tracking grants for accumulating development skills :-
http://www.databaseanswers.org/data_models/trac…
Hi Ian,
Welcome to the Community ;)
Your comments are a scary insight into the way some software gets written.
I have a nasty feeling that what you describe happens more often than it should.
Certainly when I look at some code in the UK Government I…
Thanks for that Barry. Funny to think of 30 year old academic/experimental code still banging around in some of the commercial packages. Surely there's no single individual with a full understanding of the base code for, say, MS SQL Server? How many…
Here's a very readable history of SQL, which started in IBM Research but was first brought to the market by Oracle :-
Here's a very readable history, which is a record of the twentieth anniversary reunon of some key playes :-
http://www.mcjones.org/…
Hi, Barry! Is there some freeware with the similar functioality? It's not need to be so powerful as Dezign. The point is it can draw conceptual ERD almost with the same style. By the way, how much for a dezign enterprise license after disacount? Thanks a lot.
Hi, Barry! I tried the evaluation version (although as a pity, only 30 days free). This is what I am looking for. Students use MS Word to draw conceptual ERD which is very labrious, while advanced tool like MS Visio can't achieve the same effect. So I think it's better if we have same professional tools to save some tedious drawing labor. Your information tell me that this kind of tool does exist. The drawback is that it's a commericail software, hence may be not available for every students. But I would like to recommend the University department to purchase one if it's not expensive. Many thanks again.
Hi, Barry! I am in now. May I present my enquiry: Is there any handy tool for drawing conceptual ERD, with the same style used in your Data Model?
Many thx!
:-)
Barry,
Is it possible to create a form for New Dog but that breed_code or size_code is not shown in form but with the help of combo box to choose the breed or size for dog. And the breed_code or size_code is automatically generate in to table Dogs.
Hi Barry,
I think it would be very useful to add Kennels,dogs staying in Kennels and payments .Tell me please is the payment relates to the payment of services in kennel or is it the payment for dogs if someone wants to buy a dog? Perhaps it would be good to add the Service charge and the Price of dogs If the kennel have dogs for sale . We can also add exhibitions or titule of dogs. Titles would affect the price of the dog. What do you think about it?
Hi Barry,
Thanks for getting back to me.
I have a single table with Date, Issue No, Headline, Keyword & Author for each article. I use Headline, Keyword & Author in a query that seems to work.
I hope to add a date choice to narrow the ammount information that I recieve, any Ideas.
Regards,
Brian.