We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [database-diagrams]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
89 views

Modeling a db that has products: What are the good practices/solutions? How to treat grammar variations in the words?

The problem is: A Company belongs to a sector. A Company produces products. A Sector contains products. A Product belongs to sectors. Three entities: Company, Sector and Product. And it's a ternary ...
2
votes
2answers
894 views

What are the bad design points in the following (simple) Entity-Relationship Diagram?

The objective is to design an Entity-Relationship Diagram for a company that has addresses, telephones, emails and representants. Here's the list of the constraints: a company has one or more ...
2
votes
1answer
3k views

Database Normalization: A Case Of The NULLs [duplicate]

I'm trying to learn about proper database management and am having a hard time with designing a database that doesn't rely on NULLs. If you think I'm crazy for embarking on this, it is because of SQL ...
2
votes
1answer
156 views

Database Design Techniques, Notations and Terminology

I'm taking a Database course and I'm a bit confused with the different types of graphical representations terminology of a database design. Are Data Model, Crows Foot Notation, Crows Foot Model, ERD &...
1
vote
0answers
575 views

MySQL Workbench Forward Engineer from only the current diagram

I want to create a test database from a huge schema in MySQL, but when I try to do Forward Engineer from a Diagram with about 6 tables, it try to create all the tables, views and routines groups that ...
3
votes
1answer
873 views

SQL Server 2008 Script Changes from Database Diagram

I have a database diagram which I have made several changes to using SSMS, however instead of committing the changes I want to generate a SQL script to apply them instead. Is there a simple way to do ...
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 ...
4
votes
2answers
230 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?
2
votes
1answer
3k views

ER relation with unique key

I've a problem about my ER diagram. Assume that I want to draw a diagram with student, member and team. Here is my specs: A student does not have to be a member of any team. A student could be a ...
0
votes
0answers
326 views

Need advice on this EER Diagram

This db will work with a CakePhp app and need advice about design. Is it good idea to put orders on center or should I put clients on center? Clients has orders and an order record can only have one ...
3
votes
3answers
4k views

How can I get a list of tables contained in a database diagram?

I need to get a list of the tables contained in a diagram in SQL Server. How can I do it using an SQL script? I don't need a list of tables in the database, but the list of tables contained in a ...
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 ...
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 ...
7
votes
4answers
2k views

Is it critical for a database to have a relationship table/diagram or not?

Got a question and wanted to get the best practices or thoughts on this. I have an application that was developed with a SQL Server back end (site is Entity framework, vb.net, asp.net). The original ...