Questions tagged [database-diagram]
62 questions
0
votes
0 answers
EER diagram - How to represent supervisor can perform all tasks of other roles
I am drawing an EER diagram to represent the following relation. The employee can be either supervisor, clerk, assistant or HR. But supervisor can perform all tasks of other roles. Am not sure whether, i need to connect owner to all relations of…
ringul
- 47
- 7
0
votes
1 answer
Data Modeling Microsoft Office
Ok, let me start off by stating I have search google and just about every resource I can think of, but it is possible I am not asking the question correctly. If not, please feel free to correct that question.
What I am trying to do is create a beast…
Chad Holland
- 1
- 2
0
votes
1 answer
I am unable to use the SQL Server database diagram functionality
I am unable to access the SQL Server database diagramming functionality. I get an error:
A member of db_owner must use the database diagramming functionality
When I contacted my service provider they said that they did not grant me the db_owner…
Sujoy
- 1,051
- 13
- 26
0
votes
0 answers
SQL Database Diagram - SQL Server 2014?
I typically make a Visio database model diagram, doing a reverse engineer feature. My issue now is that I have Visio 2010, but I need a model for a database on a 2014 server. It seems the Visio driver in 2010 is not compatible for SQL Server 2014…
missscripty
- 529
- 2
- 11
- 30
0
votes
1 answer
How to see all existing elements of a model in MySqlWorkbench?
I work with MysqlWorkbench 6.3.10 and imported a view kum_view_all_nuts-3-regions from a database (source) to a model using the synchronization wizard.
Database => Synchronize model...
I would expect the imported view to be shown in the Catalog…
Stefan
- 10,010
- 7
- 61
- 117
0
votes
1 answer
Is there a way to visually display a database view in a database diagram?
Similar to this question, is there a way to visually display a database view in a database diagram?
katzbatz
- 332
- 2
- 16
0
votes
2 answers
Database Diagram Designer - Howto jump to a specific table?
i am using Microsoft SQL server Management Studio 2012 to create a database diagram for my whole database (more than 200 tables).
Is it possible to find / jump to a specific table in diagram?
I need a tip.
Thanks.
Pischke
- 13
- 5
0
votes
2 answers
Database Architecture for logging
This is something that has bothered me for a long time and i still have been unable to find an answer.
I have a huge system with alot of different features. What is common for this system is of course that my users can
create, update, read &…
Marc Rasmussen
- 19,771
- 79
- 203
- 364
0
votes
1 answer
Database design - need guidance
I'm probably doing this wrong, but here it goes.
I'm trying to build something like very basic CRM. I know there are plenty of them, but I want something to learn actually. I have tried to find ready made examples for this particular scenario, but…
pera
- 1
- 1
0
votes
1 answer
How can I make class diagram from the database diagram?
![Database diagram of my online shopping store][1]
brands
Column
brand_id
brand_title
table cart
Column
cart_id
p_id
ip_add
customer_id
qty
categories
Column …
Jawwad Rafiq
- 327
- 3
- 20
0
votes
1 answer
I don't have database diagram in SQL Server 2012 , how can I get it turned on?
I don't have the database diagrams in my SQL Server 2012.
How can I turn it on, so that I will be able to extract a diagram of my database?
Hajar
- 1
- 1
0
votes
3 answers
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 architecture(Tables and their constraints) to a new database so I can…
IEnjoyEatingVegetables
- 968
- 3
- 11
- 30
0
votes
1 answer
classes database diagram
I would kindly ask for some help in creating classes that are based on Database diagrams.
I am writing my code in C#. And my main doubt is how to create references from one class to another so that it matches my Database diagrams.
For example, in my…
Whizzil
- 1,264
- 6
- 22
- 39
0
votes
2 answers
SQL Server 2008 Unspecified error (MS Visual Database Tools)
I am a newbie using SQL Server 2008, and I am facing an error message when I try to make database diagram by right clicking on the database in SQL Server Management Studio:
Unspecified error
(MS Visual Database Tools)
Program Location:
at…
SilentVoice
- 11
- 1
- 2
- 5
-1
votes
1 answer
Two primary keys? (Telegram chat_id)
I’m designing a database with ERD for a Telegram Bot and I want to store the Users. Every user gets an id (primary key, int) and the chat id form Telegram (int).
The Telegram Bot API says this about the chat id:
"Unique identifier for the target…
Steffen Bauer
- 145
- 1
- 10