Hey ranchcharm,

No, I sort of let it go a while back and focused on other things. I kept thinking about it though, on and off. I have a feeling I could possibly apply a stack model used to store...

jwaldron82:

It is incorrect to assume that the choice of a database system "requires" a scripting language. In fact, in many cases a scripting language will support many database systems. For...

Moxdillin, I disagree that mySQL plays a major role in application functionality. Here's my philosophy on the subject.

As the application designer, you have to decide first what your application...

I suggest you start a new thread for that since I never used either Dreamweaver, IIS or ASP. I'm of the AMP (Apache, MySQL, PHP) school of thought and do all the scripting myself in a programming...

One thing I learned about databases is that you should never spare the number of tables. Fewer tables might appear less complex but often don't represent reality as it is.

Overall, it's looking...

Ok, it's a good first draft. Few pointers:

- In an ERD, we usually don't bother with PKs and FKs, that's something that comes later in the data model diagram. ERDs only define entities and their...

The way I designed it so far, the users actually don't need to know the structure of the database. I present them with a web form that contains select boxes for tables, fields, operators and even...

There's certainly merit to the idea as it solves reason #2 in my previous post. It makes it somewhat harder however when wanting to edit the query, I would have to:

a) parse the WHERE clause
b)...

First of all, entities are supposed to be real-life objects or concepts. In my opinion, a student status cannot be considered an entity but rather an attribute of a student. In other words, a status...

Correct.

I feel we're going a little off topic here but if you really must know, the data is medical and I already have a controlled ad-hoc environment with everything you suggest.

The purpose...

ERDs are always a tad difficult when you haven't done that many. I'd be glad to help but first could you please give more details on what a "Project Allocation System" is? What does the system do?...

No, since the expressions translate to SQL statements (the WHERE clause to be more specific), I'm sticking to the usual AND and OR operators for the moment.



Yes, in the current model there is...

Fair enough, here's a little more information.

I'm writing a data mining application where the database has about a hundred tables sharing close to a thousand fields among them. The application...

Here's a few questions in an attempt to clarify your problem:

1) Can a given User also be a Client and a Service Provider at certain times?
2) Inversely, are Service providers and Clients always...

Good luck!

Hmm, that's a simple question that requires a long answer. Here's a few pointers.

1) First, HTML alone does not allow linking a website to a database. You need another language in between that...

Further on the StudentSubjects table...

You have a one-to-many relationship between StudentSubject and ExamResults. Is that a true representation of life, in other words can one student, for one...

I'll help, what's your issue?

Hi all,

(this is a repost from here (http://www.daniweb.com/forums/thread112412.html))

I'm working on a relational data model in which I'd like to store boolean expressions. I'm a little rusty...