Questions tagged [erd]

Entity Relationship Diagram

Filter by
Sorted by
Tagged with
1
vote
3answers
6k views

Db Design of a Room Booking System

I plan on building a web based room booking application for meeting rooms at a company. The requirements are not set in stone and are pretty much left to me, as long as these core ones are met: Users ...
3
votes
3answers
3k views

Database design for bookmark system

I am creating a bookmark system where people can save their bookmarks. Each user has its own personal page with bookmarks. A bookmark should have atleast one tag and max five. Each user can create ...
3
votes
5answers
14k views

Automatically create ER diagram from database schema

I have a database with 193 tables and I need to create an entity-relationship diagram from them. There are no formal relationships between the tables with respect to FKs. The relationships are mapped ...
0
votes
1answer
713 views

Does my ERD account for my business logic

As part of my new and upcoming project, part of the business logic involves sending each and every one of my customers (assume they number in their 1000s) multiple (possibly customized) emails. Each ...
1
vote
1answer
100 views

Data modelling concepts

Let´s say I have 3 entities. Can I have them all linked to each other "forming a circle" where each one is linked to the other trough a many to many relationship. Cheers
4
votes
2answers
231 views

Can relationships have relationships?

I have the following requirements (as part of a larger system). In the database, I need to maintain a list of parts, suppliers who sell those parts. Many suppliers can sell the same part and each ...
3
votes
1answer
14k views

Number of ISA relationship triangles in an Entity-Relationship Diagram

The following two diagrams are nearly identical. However, in one, there are two ISA triangles from the Entity "Movie" and in the other there is just one. What is the difference in meaning?
0
votes
1answer
2k views

Advantages of “middle” tables in one-to-many relationships

Entities: Lists Leads What I am trying to achieve is a scenerio where in the relationship between lists and leads the following constraint is applied: A list can have many leads, but a lead can only ...
2
votes
2answers
1k views

What do you call a relationship between two entities without a foreign key?

Let's say I have two tables that are related in that one table contains a column that is a key to the other table. In other words, it would be a 1:1 or 1:* depending on constraints. Let's call it an ...
3
votes
1answer
3k views

How to handle versions of an Entity in Database Design

I am working on a new project. The domain logic of the project is as follows: A user uploads a file (Document) and gives a title, then another user comes along and (s)he also tries to upload a file ...
3
votes
1answer
1k views

Learning to draw entity-relationship diagram for a scenario involving Offices, Employees and Projects

I am trying to learn entity-relationship diagram, following question is the objective. Information consulting firm has number of offices with employees. The employees can move offices depend on the ...
2
votes
0answers
1k views

The nature of the relationship between two tables in MySQL

Good day. I'm designing a database for a research project where we're predicting whether or not young female athletes will rupture their ACL(s) based on the nature of a test jump recorded with a ...
1
vote
3answers
4k views

Which is the redundant relationship in this ER Diagram and why?

Which is the redundant relationship in this ER Diagram and why? A few of my friends and I have been trying to figure it out but keep going in circles. where the attributes of each entity are as ...
2
votes
1answer
1k views

Multi-variance products

My current system houses different variants of Products in different tables; Productgroups Productcolors Productsizes Productmodels Products can reside under 1 Productgroup and can have multi-...
1
vote
2answers
436 views

Refactoring/normalization - but almost empty table

I normalized a legacy DB into this structure: But I'm not sure if it is correctly normalized. I don't feel very comfortable with the almost empty filters table. The requirements A group contains ...
0
votes
2answers
459 views

ERD Review Please

I am building a simple database driven web application, but from reading so many books on the subject, I know that if my database is messed up, then my application too, will most likely be messed up. ...
3
votes
2answers
1k views

Drawing an entity-relationship diagram for a movie sales business domain

I want to keep track of movies that exist in different formats (for example, DVD, Bluray, etc.). The price for each format differs from the others as well as the quantity of each format, so I came up ...
5
votes
1answer
2k views

Payment methods conceptual and logical model

I need to create a conceptual and logical (normalized) models of parking house according to the requirements below. It looks to me as a very simple concept that doesn't need all tables to have ...
2
votes
1answer
3k views

How to model entities in an entity-relationship diagram about a car service scenario?

I'm a beginner Database designer and wondering if anyone can help me understand this. Let's say we want to design a system that has, among other entities, an entity called Vehicle, and another one ...
5
votes
3answers
2k views

Are there any tools to go from ERD to DB design and vice versa? [closed]

I'm learning DB design and looking for some tools, preferably open source software, that could help go from an ERD to a DATABASE and vice versa. For the record, the database i'm using is MySQL.
6
votes
2answers
12k views

Should ERD derived attributes be included in logical tables?

I have created my entity-relationship diagram (ERD for brevity) and it has derived attributes. When it comes to database design using a relational schema, I've designed my tables and linked ...
0
votes
1answer
398 views

Users database to store access levels, can I move the non-essential information to another table?

I would like some advice on the best database structure for my system. I have different kinds of users with different access levels, and different information of course. I created a users table with ...
4
votes
1answer
2k views

Modelling Relationships in an E-R Diagram, Table or Foreign Key?

Should a relationship in an E-R diagram be created in the database as a table or a foreign key? For example: a tutor lectures a class I see it as three possibilities: there is a "lectures" table ...
8
votes
1answer
4k views

How are indexes represented in an ERD?

What do indexes look like in an Entity Relationship Diagram? I've googled it and I'm unsure what the standard look of an index is in an ERD. And I'm talking about the crowsfoot diagram that includes ...
2
votes
1answer
3k views

How do I persist recurring events?

I've been tasked with designing a system to recur events. Events may recur daily, hourly, monthly or yearly. Users should be able to schedule events "every 3rd Wednesday of the month" or "The 1st of ...
6
votes
2answers
2k views

How do I create a user invitation model?

I am developing an application which allows 'users' to create 'lists'. I have a many-to-many relationship between 'users' and 'lists' (this might not be right). Additionally 'Lists' have many 'Tasks'. ...
12
votes
1answer
6k views

How do you represent VIEWS in an ERD?

Are VIEWS (CREATE VIEW) represented in an ERD? If so, how do you represent them and specify what tables they came from?
5
votes
2answers
12k views

Tool for Reverse Engineering of PostgreSQL Database on Linux (Ubuntu) [closed]

Please suggest a tool to reverse engineer a PostgreSQL DB into an entity-relationship-diagram (ERD) or equivalent ?? Ideally, I'm looking for a simple ERD or UML class diagram in a format that is ...
2
votes
1answer
2k views

How to translate high level entity relationship into schema

According to the following articles written by Dr. Chan, we can describe high level entity relationship. (see page-10,11 of doc-A and page9 of doc-B) •doc-A) English Sentence Structure and Entity-...
4
votes
2answers
4k views

Is my ER Diagram correct? Why use relationships?

This is the first time I've made an Entity Relationship Diagram (ERD) for database that will be built on MySQL. The business domain of relevance is about equipment issues management. Prior to this, I ...
3
votes
1answer
209 views

Entity relationship many to many

Is an association class in UML the same as an Link entity in ERD?
1
vote
1answer
344 views

Guidance on simplifying the following diagram

I have a case scenario where a customer can book accommodation or flight only or both. I have modeled the accommodation part, however i am making things complex by over-thinking how stuff works in ...
2
votes
1answer
292 views

How can i model this data

A customer can make a reservation for an accommodation, the accommodation can be in a resort or elsewhere. So i would say that a resort can have different types of accommodations, ie. Chalets, ...
6
votes
8answers
59k views

How to export an ER diagram from an Oracle DB? [closed]

I am developing this application with an Oracle database. I haven't been documenting the data model, but now an auditor wants to have an entity relationship diagram of my database. There are many ...
5
votes
3answers
886 views

how do I model this in database?

I am using mysql as my backend database. Here is the use case; A HolidayPackage is configured with some default offerings. These default offerings can be up/downgraded based on the options provided. ...
0
votes
1answer
459 views

Suggest good ERD tool with UML notation [closed]

I need to design an ERD with UML notation, can anyone recommend a tool that does this.
1
vote
1answer
1k views

ERDs: How do you indicate mutually-exclusive encounters?

If you have a character_instance and character entity in an ERD for a video game, and you want to indicate that something happens when a character entity encounters a character_instance entity, how do ...
6
votes
2answers
761 views

Design: How do you decide when items are related vs when they are attributes?

I've been trying to figure this out for a while. Let's say you have a person, for example. An attribute of a person is his or her social security number, right? But a person also has a social ...
4
votes
1answer
2k views

ERD via Chen's notation: How do I organize multiple 'last done' entries?

I'm having an issue creating a little practice ERD. I'm trying to do some more difficult stuff, and I'm not sure what the standard way to organize it is. Basically, I don't know which of these is ...
10
votes
5answers
16k views

Importance of ER Diagrams

I am a student and I am developing several projects as a part of my academia. While developing the database for one of the projects, we came across a situation where we thought about whether ERD is ...
3
votes
1answer
1k views

Exporting from SQL Server 2005 for import into ER Studio 9.0

I am new to ER Studio and need to create an ERD for a remote system. That system can only be accessed by LogMeIn remote control and by FTP. The remote system is running SQL Server 2005. The local ...
1
vote
1answer
316 views

ERD directly producing 5NF relational schema - is this desirable?

I am given a case study of Event Management to develop an entity-relationship diagram (ERD), and based on it check if the resulting relational schema meets the different normal forms. Now, I have ...
5
votes
4answers
3k views

How can I generate an Entity-Relationship Diagram and SQL DDL statements from natural language text?

I am using LaTeX or another text-macro tool/library. How can I (1) use natural language text to describe relationships, then (2) generate an Entity-Relationship Diagram and (3) generate SQL DDL to ...
0
votes
1answer
1k views

Entity-Relationship Diagram for a scenario involving Books, Authors and Countries

Certainly a noobish question, but I'll ask it anyway. Perhaps someone else will be thankful. ^^ I am getting warmed up with MySQL and I try to understand the concepts of creating well structured ...
8
votes
2answers
20k views

Is it OK to have an entity in an ER diagram without a relationship?

I'm creating an ER diagram for a class assignment and I was wondering if it would be possible to create an entity that had no direct relationship to any other entity, and simply use foreign keys to ...
9
votes
1answer
27k views

How can I import the contents of an Oracle database into Visio to create an Entity Relationship Diagram?

I have an Oracle database, and I would like to create an ERD in Visio 2007 Pro. I have so far looked at DBMS_METADATA.GET_DDL commands to generate DDL. I know that I can import an Access DB into ...
13
votes
2answers
2k views

How to structure a model to properly and efficiently represent tree-like data on relational databases?

Based on Traversing tree-like data in a relational database using SQL question, I would like to know how the way regularly used to describe tree-like data on relational databases considering physical ...
30
votes
10answers
884 views

What is an effective way of labeling columns in a database?

I used to label columns in my databases like this: user_id user_name user_password_hash To avoid conflicts when joining two tables, but then I learnt some more on how to alias tables, and I stopped ...