entity-relationship Questions
9
Solved
I have a database in MySQL created by someone. I don't have any documentation of the database.
How can I know the relationship between the tables?
Is there any query or a procedure to generate ...
Crinoline asked 15/2, 2016 at 12:0
5
Solved
Does anyone know a way to make an ER diagram from SQLAlchemy models in python 3. I found sqlalchemy_schemadisplay, which is python 2 because of pydot and ERAlchemy which is also python 2 only.
Ambages asked 8/7, 2017 at 2:37
2
Solved
How do you make an entity relation diagram using pgAdmin v4 or DB Visualizer or any other open source tool?
PG Admin
There are lots of explainers for pgadmin III but they suggest that there should...
Mafia asked 1/2, 2017 at 6:31
6
Solved
I am trying to reverse engineering to a database file that an android application generates. It gives me a SQLite file in .db extension. I tried pass it through SQLite Browser and it gets me the ta...
Gerous asked 8/1, 2020 at 22:35
3
Solved
I was only able to find the following two differences:
The relationships in an E-R model are explicitly defined, while they are implicit in a relational model.
Relational models require an interm...
Unbodied asked 3/12, 2014 at 10:4
4
Solved
Is it a good idea to show triggers and stored procedures in an Entity Relationship Diagram? If yes, what is the notation? Information seems really scarce on this topic. Also, are there any UML diag...
Guava asked 14/4, 2013 at 12:9
7
I just recently downloaded Azure Data Studio with SQL Server Express since I'm using Linux . Is there an entity-relationship diagramming feature, kind of how SQL Server Management Studio has a data...
Hankering asked 14/11, 2018 at 4:48
4
Solved
In my application, I want to convert a one-to-many to a many-to-many without losing the data :
from:
/**
* @ORM\ManyToOne(targetEntity="\AppBundle\Entity\FoodAnalytics\Recipe", inversedBy="media...
Domingodominguez asked 23/5, 2015 at 11:11
1
Solved
I was wondering whether there is a function which lets me implement an autocomplete_field without having this variable be linked to another relation via a foreign key.
I.e. I have the models Aaa, B...
Grudging asked 21/1, 2022 at 14:17
9
I want to use Oracle SQL Developer to generate an ER diagram for my DB tables but I am new to Oracle and this tool.
What is the process for creating an ER diagram in SQL Developer?
Reganregard asked 5/7, 2011 at 9:30
5
Solved
in a relational database, can we have a table without any relation with the other tables?
Rutger asked 11/1, 2014 at 18:14
7
Solved
I have two POCO classes:
Order Class:
public class Order
{
public int Id { get; set; }
public int? QuotationId { get; set; }
public virtual Quotation Quotation { get; set; }
....
}
Quotation C...
Goat asked 5/2, 2013 at 6:21
5
Solved
A dashed line means that the relationship is strong, whereas a solid line means that the relationship is weak. On the following diagram how do we decide that the relationship between the Room and C...
Juline asked 21/5, 2013 at 16:37
3
I have a class called Item which references the next item and the previous item.
public class Item
{
private Item() { }
public Item(string itemName)
{
ItemId = Guid.NewGuid();
ItemName = it...
Dorpat asked 8/10, 2016 at 2:5
4
Solved
Here is my scenario:
I have an Article entity. Each Article has an owner (a User). A user can own many articles. The user can post an article over the API.
I want to have the user_id column for t...
Hardboiled asked 27/9, 2018 at 3:17
6
Solved
Is it using some kind of byte codes modification to the original classes?
Or, maybe Hibernate get the dirty state by compare the given object with previously persisted version?
I'm having a problem...
Clock asked 11/3, 2011 at 2:54
3
Solved
Is there a standard (non-graphical) notation for Entity Relationships?
right now I'm using my own janky notation:
User >> Photo , (1-many)
User > Profile , (1-1 hasOne)
Profile < User , (1-1 ...
Jardena asked 6/10, 2009 at 21:13
1
Solved
I am trying to setup a one-to-many relationship, I have checked various articles and tutorials online but all the examples show one table having a one to many relationship with another table.
In my...
Headrail asked 1/4, 2021 at 1:4
2
Solved
Suppose there are two entities called Employee and Campaign. One employee can work on many campaigns. And one campaign can have many employees. I already know this is a many to many relationship.
...
Karelian asked 14/7, 2016 at 5:55
1
Solved
I have a project which requires me to create a UML Class Diagram. What I have from the previous tasks in the same project is an ERD using UML notation. Also worth noting, this project is rela...
Bradney asked 30/1, 2021 at 6:40
2
Solved
I have two entities:
@Entity({ name: 'provider' })
export class ProviderEntity extends GenericEntity {
@Column()
name: string;
@Column()
description: string;
@OneToMany(() => ItemEntity,...
Disintegrate asked 6/11, 2020 at 21:51
5
Solved
I am using MySQL. There are 28 tables in my database. I've tried to use MySQL Workbench to create E-R diagram. As there are 28 tables, everything is messed up in diagram using MySQL Workbench. Is t...
Bothnia asked 26/7, 2011 at 11:15
1
Solved
I'm working on a ER diagram in starUML but can't find a Foriegn Key option in it. I've looked through various setting in the application but couldn't find it. Is they a way to insert? Also, I've se...
Door asked 12/4, 2020 at 10:51
3
Solved
Hello so I have many to many relation between Question [table name: tblquestion, id: que_id] and Agecategory [table name: tblagecategory, id: aca_id]. They have shared table named QuestionAgecatego...
Mauney asked 23/8, 2018 at 9:20
4
Solved
In my Core Data model I have two entities: List and Patient. List has an attribute called 'name'.
A List can have any number of Patients and each Patient can belong to any number of different list...
Skylar asked 24/2, 2010 at 18:45
1 Next >
© 2022 - 2024 — McMap. All rights reserved.