databaserdbmserd
Can there be a relationship on the higher level entity in a total specialization?
I have the following scenario where a Product can ONLY be a SaleProduct or a LoanProduct.
Is the relationship between Supplier and Product valid? Or should the relationship be between Supplier and SaleProduct and Supplier and LoanProduct individually?
Thanks.
Solution
First of all your diagram is not a UML one. I don't recognise this notation at all.
I'll ignore your diagram and focus on the question itself. Yes, it's perfectly valid to have a relationship on the parent (generic) class and of course it will be inherited by it's children (specialised classes). That's pretty much one of the goals of having those common elements (relationship in this case) on the parent level rather than doubled on the child level.
- How can I use composite primary keys in django?
- Download font .ttf file from web and store on iPhone
- Enable Query Logging in SQLite 3
- Snowflake COPY INTO from external S3 stage fails with “Access Denied (Status Code: 403; Error Code: AccessDenied)
- Sharing databases between projects within Intellij
- How do I create nested categories in a Database?
- Anyway to require EF Core to use two queries for related data instead of 1 or N+1?
- How can I model resource exchange processes?
- SQL_MODE and TIME_ZONE when creating DATABASE
- MySQL Match Against with Multiple Values to AGAINST
- C# check if element(s) from CSV exist in database list
- import mysql database to wamp server
- Check for changes to a SQL Server database?
- Alembic keeps deleting and recreating Foreign Keys during autogenration
- Data loading and transformation from gcs to bigquery
- QL query MS Access error "field could refer to more than one table"
- How do I escape reserved words used as identifier in Informix
- Generating a sequence number in a PostgreSQL database - concurrency & isolation levels
- Only one child record is being created when trying to create a record with one to many relationship
- How to increase the performance of a Database?
- How to match these 2 tables?
- Working with large CSV file using duckdb or arrow in R
- When creating a self-hosted application, how are database migrations done?
- What is the best data type for ISBN10 and ISBN13 in a MySQL database
- How can I perform version control of Procedures, Views, and Functions in Postgres sql
- CHECK constraint on date of birth?
- How to create a driver for a database with a opensource language?
- Does it possible to make always getting update from database without refresh
- ERROR: insert or update on table "promos" violates foreign key constraint "fk_businesses_promos"
- Storing Friends in Database for Social Network