Stack Overflow
Stack Overflow

Questions tagged [database-diagram]

62 questions
1
vote
1 answer

I created a database diagram and but other user is not able to view the database diagram. What access permissions does the other user need?

I created a database diagram in SQL database but the other person in my team is unable to view it, it might be because of different access permissions to that server. What permissions does the other user need to be able to view the database…
Geetanjali Sachdeva
  • 133
  • 1
  • 5
  • 14
1
vote
3 answers

Recommend Software for Drawing a Normalization Diagram

I want to draw database diagram. I should draw normalization steps. I want to draw diagram like this and show functional dependency! -------------------------- | | | …
Vahid Kharazi
  • 5,723
  • 17
  • 60
  • 103
0
votes
1 answer

How to fix SQL Server database diagram error "Cannot execute as the database principal because the principal 'dbo' does not exist"?

When attempting to create a database diagram I get the following error: Cannot execute as the database principal because the principal "dbo" does not exist How do I fix this error?
Tyson Gibby
  • 2,590
  • 2
  • 18
  • 37
0
votes
1 answer

Entity Relation Diagram / Database Diagram (MySQL)

I have the following Entity Relation diagram (MySQL), which I made for a small project(for the university). I would like to know if the relation between PK and FK is properly made. I am aware that token should not be used in the users table. Don't…
Florea Constantin Cristian
  • 11
  • 3
0
votes
1 answer

Power BI Chord visual: link tables with same column name

Someone migrated a DB2 database to SQL Server and during the migration all PK and FK were lost. there is no way to have them back. But thanks to this query I'm now able to Reverse Engineer the database diagram based on the datatype and column name.…
Francesco Mantovani
  • 10,216
  • 13
  • 73
  • 113
0
votes
2 answers

SQL server tables not showing relation in Diagram

I have a lot of tables that share keys but in the diagram does not show a route from table to table. Most tables will show a route to but a lot of them do not although they should. I've already checked data types, and I can join these tables, so I…
Wes
  • 11
  • 2
0
votes
1 answer

ERD or MCD one-to-many diagrams

What is the difference of those two diagrams? and
jtobelem
  • 749
  • 2
  • 6
  • 23
0
votes
2 answers

Correct relations to Loans table?

Hello stackers! Ive made a library databse, i was wondering.. i am making one-to-one relation between Copies and Loans. and one-to-many relation from Users to Loans. Since a copy of a book only should be allowed to be assigned one loan at a time,…
user5265806
0
votes
2 answers

Need help understanding the correct way of making relations between many to many tables

I need to know if my relationships made between many to many tables are correct. Books_Authors = Books should be able to have multiple authors, and authors should be able to be assigned to multiple books, correct? Loans table, my tought was that…
user5265806
0
votes
0 answers

Generate diagram from Django Model with dragable elements

how is it possible to generate Django Model diagram with dragable elements. Have tried to generate diagram of Django model from .dot file created using py manage.py graph_models, I got the diagram using .dot file but its elements are static how to…
Mark Koval
  • 11
  • 1
0
votes
1 answer

Is there any way generate database-design diagram of databases using C#

Is there any way to generate database-design diagrams using C# code? I want to automate database design generation to be able to generate multiple sequence diagrams at once of different database types, e.g. SQL Server, Oracle, MySQL. My basic…
RahulGo8u
  • 148
  • 2
  • 19
0
votes
1 answer

SQL Management Studio - Database Diagram does not show every table created

So I have created a database which looks like that. CREATE TABLE Budova ( BudovaID int primary key not null, BytyPocet int not null, ); CREATE TABLE Skupina ( SkupinaID int primary key not null, NajemniciPocet int not null, BytID int not…
Tomáš Jahoda
  • 1
0
votes
0 answers

Can I display custom tags of columns in a database diagram?

I am trying to use database diagrams in Sparx EA to collect and communicate information about how we are using tables. I want to add information to columns and have this information show up in a diagram. For example, the first thing I want to do…
Mike M
  • 1,382
  • 11
  • 23
0
votes
1 answer

Azure SQL and Visio 2019 Plan 2 Database Reverse engineering wizard Fails

Screenshot of ErrorI am using Visio 2019, trying to reverse engineer a Azure SQL server. I have successfully created multiple User data sources to use in the wizard using both our DB-admin user and my admin azure directory logins. The database…
harvey_carmichael
  • 13
  • 5
0
votes
1 answer

How can i generate a databasediagram in Oracle Application Express?

I need to generate a database diagram automatically from a database script I have. I have run the sql script and it worked. Right now I need to generate a database diagram using the script I ran. I am working with Oracle Application Express web…
ashley k
  • 1
1 2
3
4 5