The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
17 views

How to copy architecture of an existing database to a new database in SQL Server

I'm using Microsoft SQL Server 2012 (SP1) - 11.0.3153.0 (X64) Express Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) (Hypervisor) and I need to copy the database ...
1
vote
2answers
84 views

Financial database design

I am working on an application to store financial data and need to model the tables where the data for several financial statements will be stored. I came up with the following two designs but I can't ...
0
votes
0answers
31 views

identifying the functional dependencies

I have been reading up on database design and I am having some difficulty constructing functional dependency diagrams from tables. I have the following table. Each salesperson is identified by a ...
1
vote
3answers
111 views

Database design: 4 types of users but have different functionality , separate or one table?

I have 4 types of users: Admins , normal user , company , service provider Admins and normal user share some attributes (id .first name ,last name ,phone ,mail) company and service provider share ...
0
votes
1answer
34 views

How to use timestamp/rowversion data types in Visio?

I am using Visio 2010 to create a ER diagram. When I insert the column names, I can't find timestamp or rowversion data types. Is there an alternative?
0
votes
0answers
63 views

What is the best way to create a database diagram for SQL Azure without having to install SQL Server?

I have a database on SQL Azure and want to create a database diagram for that, but don't want to have to install SQL server and copy the database etc. Is there any way that I can do it that anyone ...
0
votes
0answers
13 views

Dotted line in ERM Diagram

What is the meaning of a dotted line in the ERM Diagram below, is it that there may be a relationship with room? and that teachers may teach classes in that room? I have heard information about weak ...
0
votes
2answers
2k views

How to represent foreign key in an ER diagram?

Suppose I have a 'Transactions' table which has a column 'Customer ID' (Foreign Key) and a Customer Table having 'ID' (Primary key). How do I show the relation between the two tables and showing that ...
1
vote
1answer
105 views

Create Meaningful Visualization for Large Set of Tables [closed]

I'm trying to create a meaningful, usable visualization for my company's ERP database. I've extracted a skeleton of the database so I can make changes without modifying the production environment. ...
0
votes
1answer
203 views

How to generate the E-R Diagram of Wordpress using mySQL Workbench

I am trying to generate the E-R Diagram of Wordpress using the 'Reverse Engineer' feature. There is a slight obstacle though. The diagram does not show the relationships between the entities. Is this ...
1
vote
0answers
358 views

Crow Feet notation and identifying -vs- non-identifying relationships

Is it possible to distinguish between identifying and non-identifying relationships using the Crow Feet notation? Case in point: In table Book, part of the book's Primary Key is a FK to the Author ...
0
votes
0answers
1k views

Generating an ER Diagram from SQL CREATE TABLE statements

As I can't find any ER diagram feature built in with Apex, I want to create one with the SQL statements I executed in order to set up the tables in my Apex Workbench. I found schemaSpy, which is ...
1
vote
1answer
270 views

How much the decision to use ternary or binary relationship influences the accuracy of the model with regards to a given business model?

The question title is very long, so here's a little bit of context to (try to) make it clear. I asked a question regarding ternary relationship. The question was Ternary relationship: what's the ...
2
votes
1answer
1k views

Ternary relationship: what's the difference between having single table and having multiple tables?

Consider the following ternary relationship: Suppose that all entities have only two attributes (PK and Name). Here are the tables I derived (5 tables): Sector ------------------------- ...
0
votes
1answer
160 views

Conversion of simple ERD to Table: is the solution below any good?

Consider the following ERD: Suppose that all entities only have two attributes: a PK plus a name/number. I want to convert that ERD to tables. Is it needed 4 tables (1 for each relationship ...
0
votes
1answer
1k views

MySQL Workbench EER Diagram and ENUM data type

I am creating EER model diagram using MySQL Workbench (version : 5.2.47) The version for MySQL, I am using is 5.5.35-0ubuntu0.13.10.2. I have created a schema with 'Default Collation' set to 'utf8 - ...
1
vote
1answer
68 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 ...
0
votes
1answer
76 views

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

The objective is to design a Entity-Relationship Model for a company that has addresses, telephones, e-mails and representants. Here's the list of the constraints: a company has one or more ...
1
vote
1answer
157 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 ...
0
votes
0answers
548 views

Which tool to use to generate an ER Diagram that will allow navigation between tables

DB= Mysql 5.X , OSX/Windows I have a DB with over 400 tables. I want to use a tool to reverse engineer the db to an ER diagram that will allow me to navigate between tables. So for example, when I'm ...
1
vote
0answers
74 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 ...
0
votes
0answers
24 views

how to assign multiple/single role between two entities

I have user and school table with roles as student,teacher,schooladmin and schoolheadadmin. If user is student then he/she can not have any other role in same school but if user is teacher then s/he ...
0
votes
1answer
176 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 ...
1
vote
1answer
1k views

Automatically create ER diagram from database schema

I have a database with 193 tables and I need to create an ER diagram from them. There are no formal relationships between the tables with respect to FKs. The relationships are mapped with 1-* tables. ...
3
votes
2answers
127 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 ...
2
votes
0answers
578 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
125 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
91 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 ...
1
vote
3answers
766 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 ...