I am trying to get a basic rails application running that helps capture the nutritional information of each food item from a list of food items. The nutritional information is stored per ingredient ...

I am building a dynamic customer feedback form and I have come across a bit of a problem with the structure of the database. I have included an ERD showing what I am trying to do.
The idea is that I ...

I'm a database beginner and i'm confused with regards to entity relationship. I don't know when should idea be classified as an attribute (i.e. a field) or as a table (i.e. an entity). Can you please ...

I am making an ERD in visio, but not getting "Dynamic Many-To-Many"/"Dynamic One-To-Many" arrow to join my entities.
Can anybody know, from where in visio i can get it?
I am getting straight linked ...

Teams can have 1 or more members
Members can join 1 or more teams
A member can lead 0 or more teams.
Each team has a single member leader, where that team leader must be a member of that team. (eg. ...

I am building a stock control system and have stumbled on this problem, which I cannot solve despite various hours spent googling and trying different options.
Essentially each product can be stored ...

I am working on designing an ER diagram for a football system, i stopped in the relationship between the player and team, as we know the player plays for only one team and team have many players, so ...

The focus is on the Cashier table and the Cash Accountability table. The rule is that only Cashiers have Cash Accountability and a Cashier ideally only cashes out once per day. Before I changed the ER ...

Hi I am struggling with some relationships concerning a delivery system for a small grocery store.
Here is the scenario:
A receptionist receives and order from a customer. The store staff takes the ...

If 2 tables, for example "Solo singer" and "Group singers" are inheriting from same parent table "Artists" , can we have a relationship between "Solo singer" and "Group singers"?
for example:
A solo ...

I'm doing a web application for personal purposes that will allow the users and organizations {org} to post {topics}.
Web app purpose is to allow organizations to post research request for those who ...

I have two tables connected with table with two foreign keys (like on the picture below).
http://i.stack.imgur.com/6ruPi.png
In table menu I want to have name of pizza and her price.
In table item I ...

I have a class erdbuilder and another class SQL. My erdbuilder class allows me to draw shapes and to stores them in an arraylist Connection. Then I access the arraylist Connection from the SQL class ...

I'm doing some research work on data from DBLP XML
I've Googled if there are any tools or web services that can help me making ER diagram of this huge XML data file, but unfortunately i haven't found ...

There is a question that has been asked previously that pretty much asked the same question (Generate ERD from SQLyog) but I am asking again because that question is a little dated now (especially in ...

A user who schedules planes for flights determines the type of plane to be used each day for each flight, and can change the type of plane if necessary. Normalize to 3NF and come up with a relational ...