I am trying to define db dependency for a web based application, and was thinking that perhaps the hibernate mappings used in the application might be importable into some sort of tool to produce a visual ERD diagram. Has anyone tried something like this? ...
I have two tables parent and child. If I make a foreign key on child that points to the primary key of parent, and then make an entity diagram, the relationship is shown correctly. If I make the foreign key point to a different column, the relationship is not shown. I have tried adding indexes to the column, but it does not have an ef...
Background MySQL Workbench can produce appealing and high-quality ERDs such as: Research What PostgreSQL ERD tools are available that meet the requirements? The following are unsuitable: dbVisualizer - Yellow squares. AquaFold - Yellow squares. SQL Developer - Coloured squares. Dia - Coloured squares. SQL Power Architect - Black a...
One of the databases that I'm working on has some quirky behavior that I want to account for in the entity-relationship diagram. One of the behaviors is that there is a 'booking' table and a 'invoice' table. When a 'booking' is invoiced, then the record is inserted into the 'invoice' table and then deleted from the 'booking' table. Ho...
We have a system built by Parallels, which is relying on a huge (800+) tables to maintain everything. I need to learn this system, in order to be able to write queries to retrieve data for report generation on various needs. I am obviously, having difficulties isolating which tables are currently relevant for the task at hand, so I tho...
I am looking for a tool which would generate entity relationship diagram based on simple ascii syntax. Syntax could be something like: thing1 <-> thing2 thing3 <->> thing4 thing5 <<-> thing2 thing1 <<->> thing5 Where: <-> is one to one <->> is one to many <<->> is many to many Or anything similar. There should be this kind of tool...
Suppose that we have the following partial ER diagram: Notice that the attachments table will subsequently be used for the messages', submissions', assignments', and lectures' attachments. The problem is with the 3 one-to-one relationships between attachments and messages, submissions, and assignments. According to CakePHP's conventi...
Design a database to store details about U.S. Presidents and their terms in office. Also, record details of their date and place of birth, gender, and political party affiliation. You are required to record the sequence of presidents so that the predecessor and successor of any president can be identified. Remember Grover Cleveland se...
A dairy farmer, who is also a part-time cartoonist, has several herds of cows. He has assigned each cow to a particular herd. In each herd, the farmer has one cow that is his favorite - often that cow is featured in a cartoon. A few malcontents in each herd, mainly those who feel they should have appeared in the cartoon, disagree with t...
Hello Hopefully someone may be able to quickly advise the best way for me to model my ERD (I'm using IDEF1X & ERWin not Chen Notation) although it doesn't really matter. Basically I have Three Entities Organisation Person Trustee Business rules state that a Trustee can be either a person or organisation. My question is, would i...
Hello. Please can someone clarify something which I should really know by now? If I have Three Entitys Organisation, Director and Company secretary and each have the attribute primary address. If I were modelling a conceptual ERD should I have the attribute ‘primary address’ separately in each entity or should I model a fourth enti...
Can you guys show me how to get this ERD in 5th normal form? We did a class assignment yesterday where we had a real client come in and explain to us his need my group came up with this model I am trying to take it a step further and see if I can get it to 5th normal form so that I can understand it better as next week we will be doing a...
Can you tell me if this is done right or if I need to improve some of them I have a hard time understanding the query's when there is an associative entity. List all donors SELECT* from Donor; List the first and last names of all donors SELECT dfname, dlname FROM donor List the phone numbers of donors number 106 and 125 SEL...
Can you see anything that might have been left out for a simple bug tracking system? Here's an updated version with new changes ...
Hello. I realise that the answer to these types of questions are often "it depends" but still I wondering what the general consensus might be. I am dealing with multiple entities such as Company Charity Auditor Stocktaker etc etc... Which all have contact information such as e-mail, telephone and address. The two design metho...
I am desining a database and got stuck with this issue: My case is to design an ERD to keep track of the cars and their movements from location to location. The users utilize a form which contains three fields: The first one is used to enter the car#. The second field is used to enter the location the car came from (From_Location) and...
hi, i want to see a diagram (erd) of a database system which has been designed for cms. would you lpease show me a complete on? tanks ...
I was wondering if there was such thing as 'belongs to' relationship, and what was its function, or if it was just the opposite to 'has one'? The question arised when building an ORM, and wanted to find a way to determine when a entity instance should be automatically deleted, eg: User 'has many' Thread Thread 'has many' Comment Thre...
SA I want and ERD Generator that understands the relations between Rails Models. I found Railroad but did not work with 2.3.2 I found also http://rails-erd.rubyforge.org/ but it is for Rails 3 Any idea? ...
I am working on an rfp for a company. They want to keep things high level. They asked me to describe domain model and how it can be extended to support their unique data points. What is the best way to answer it. I have a domain model diagram but I don't want to go in detail with all data fields. I found out that people reviewing it wi...