Tagged Questions
1
vote
1answer
34 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 ...
1
vote
2answers
218 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
0answers
49 views
Designing ERD1 and ERD2 with crows foot [closed]
What would be the perfect ERD1 & ERD2 for the following case study? And what are the attributes of the entities?
Five Aside Football Independent League (FAFIL)
The Five Aside Football ...
0
votes
2answers
97 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.
...
1
vote
1answer
161 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 ...
1
vote
3answers
200 views
Software tool to visualize and print DB diagrams
I have some SQL Server databases and use SQL Server Management Studio to manage them.
However, I find that is not very friendly to create, design and print database diagrams (for existing tables).
...
1
vote
1answer
353 views
How to model entities in an entity relationship diagram?
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 ...
4
votes
2answers
294 views
Are there any tools to go from ERD to DB design and vice versa?
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.
4
votes
1answer
1k 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" ...
2
votes
2answers
159 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'. ...
3
votes
2answers
813 views
Tool for Reverse Engineering of PostgreSQL Database on Linux (Ubuntu)
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
0answers
249 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 ...
0
votes
0answers
492 views
ER to Relational Schema [closed]
I have developed an ERD diagram with UML notation in StarUML.
Now, I need to draw a relational schema but due to lack of features in StarUML i must use other tool.
My question is what exactly goes ...
2
votes
1answer
118 views
1
vote
1answer
150 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
142 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, ...
1
vote
0answers
181 views
Entity relationship diagram
What is the difference between ERD 1 and ERD 2?
From what I understand is that ERD 2 has the many to many relationships resolved with a link entity whereas ERD 1 only shows the relationship... is ...
3
votes
5answers
8k views
How to export an ER diagram from an Oracle DB?
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
439 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. ...
1
vote
1answer
162 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 ...
5
votes
2answers
180 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 ...
3
votes
1answer
873 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 ...
5
votes
5answers
2k 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 ...
5
votes
2answers
525 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 ...
20
votes
10answers
541 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 ...
