I have a database that has 5 1:1 relationships. I have a table called SoftwareVersion. Each SoftwareVersion has 5 phases of certification. The PhaseStatus names are the same for all 5 phases. I could not enforce referential integrity with one PhaseStatus table and a Ph0Status, Ph1Status, etc, field in the SoftwareVersion table. So I built 5 join tables. Now I have 5 1:1 Relationships. Every SoftwareVersion has multiple phases that have a status, but each software version only has one Phase 0 status. Is this a good example of a legitimate 1:1 relationship or is there a better way to build this?
Related Questions in DATABASE
- How to add the dynamic new rows from my registration form in my database?
- How to store a date/time in sqlite (or something similar to a date)
- Problem with add new attribute in table with BOTO3 on python
- When an E-R attribute should be perceived as a relationship attribute or as an entity set attribute?
- SQLAlchemy: efficient relationship loading in 3-way many-to-many relationship
- Cannot connect to Postgres Database when running Quarkus Tests with Gitlab ci
- Local or remote database with react-native?
- I want to edit a specific row in database
- How to enter data in mongodb array at specific position such that if there is only 2 data in array and I want to insert at 5, then rest data is null
- Open Web Library
- database login.py and register.py error showing 404 file not found and doesn't work
- SQL71561: SqlComputedColumn: When column selected
- Liquibase as SaaS To Configure Multiple Database as Dynamic
- Updated max input vars but table still shows error
- Spring does not map set of roles
Related Questions in DATABASE-DESIGN
- SQL schema for a fill-in-the-blank exercise
- When an E-R attribute should be perceived as a relationship attribute or as an entity set attribute?
- steps to create a web app with backend and database and web
- Use data type uuid or varchar(36) for my UUID column?
- Containing Object Design
- Many-to-many relationship between objects of the same type
- When hashing an API key, should I hash the suffix / prefix as well?
- Database design, authentication and authorization in a microservices ticketing system
- Unique index on 3 columns where NULL conflicts with all other values in one column
- Can i create a table with 2 foreign keys? These 2 foreign keys are 2 primary keys of 2 different tables
- I have a basic ms access question about a relationship between 3 tables
- how can i calculate mutual friends/followers efficiently?
- Access Table ,setting in design ,column 'Catagory' as Combobox in lookup with list "Action";"War";"Drama". in vb.net DGV and Detail how to multiselct
- Table Design for Calculating Median Over User-Defined Period from Pre-Processed Data
- Use conditional constraint or normalize table?
Related Questions in RELATIONAL-DATABASE
- Creating Relationship Creates Additional Columns in MySQL Workbench
- normalize table up to BCNF?
- Handling relationships with React Query
- Entity Core Framework - what is the difference between HasColumnType and HasPrecision?
- Calculating the sum of differences between two columns in Laravel
- Django - Create a model that holds aggregated Foreign Key values
- Database design for social media app: Handling multiple post types and timeline creation performance
- SQL Database Table relation based on multiple conditions
- NextJS Prisma and MongoDB relation
- Repeat the foreign keys or use two tables related as a one-to-one
- Finding items that match multiple LIKE keywords
- How should I structure my entities and not get the circular reference problem/error?
- How does MySQL compute keys for underlying tree structure
- How to write query for a condition on join table
- `"Key "0" in object with ArrayAccess of class does not exist` error after change of computer
Related Questions in MS-ACCESS-2013
- Access dynamic query with fields that may have a random "_"
- How to open Access from the taskbar?
- VBA - How to make a sub tab control form appear in only a specific page of the main tab control form?
- VB.NET / .NET 4.8: Syntax error insert into statement ... ALSO USER ID IF LEFT OUT KEEPS TELLING ME MISSING VALUE VISUAL STUDIO 2022
- MS Access (w/ linked SQL tables) form where rows are transformed to columns for data entry
- Problem deleting all records from ms access table
- Importing MS Access reports to SSRS in Visual Studio
- Changes in MS Access Form Not Automatically Updating Linked Tables in SQL Server
- How to Add columns to a multi-table Query with SQL in MSAccess
- Unable to change field value of Object in before Update event in access
- How to debug MS Access Run-time error 2046?
- PHP and Access query
- DMax function msaccess
- Why is my Access 2013 ODBC SQL Server Data Source failing after a few minutes?
- ODBC--Call failed on RecordSet
Related Questions in DATABASE-MANAGEMENT
- Solr reindex using Python
- Dynamics 365 Finance and Operations - Delete or disable a Fixed asset location
- MongoDB $match seems to not working in aggregation
- How to Baseline an sql script so that it won't show in the pending migrations in flyway
- Strategies for reducing/shrinking size of Azure SQL Database
- RESTful api for database management
- Navicat for MySQL: Can I export each result set (multiple) from one query into individual CSV files?
- Whats the best way to sort and search for similar embeddings for facial recognition
- Undefined reference error along with exit status error when trying to call function in database management system
- C++ Database skipping inputs
- Database Management - Should I use multiple databases?
- Can I use firebase for only auth and any other SQL database to store other user data?
- Best practices for managing changelogs from different applications
- How to join each order with its price?
- How do I find files with a greater numerical value than a file based upon timestamp in the filename
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
I think you mean every SoftwareVersion has many phases, and each phase has one or more possible statuses at a time.
If so, from what I see you need only two tables. You need a PhaseStatus table of all allowable combinations of {phase,status}. Use a FK reference to that table as a constraint to make sure a SofwareVersion in any given phase has a valid status. You might also want tables that enumerate the domains of phases and statuses, in case they have other interesting properties, such as descriptions or perhaps time constraints.