The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
0answers
53 views

How to merge rows based on how much data they have?

I am cleaning data and I formed a table something like this: file | product | color | product_id --------------------------------------------- one.csv pipe blue null ...
1
vote
0answers
48 views

Where should a default setting field be?

I am creating a database to track occurrences of incidents on buses based on an existing system. Currently the drivers can set a default bus number, which is used to pre-populate the bus number on the ...
1
vote
0answers
132 views

Closure of attributes definition clarification

A databases book I am using states [1]: The closure of {A1, A2, ..., An} under the FD's in S is the set of attributes B such that every relation that satisfies all the FD's in set S also satisfies ...
0
votes
0answers
75 views

How to design Saas application's database architecture in mysql

I have to develop a Saas application using Yii php framework and mysql. For developing this we have decided to make separate database for each customer. For this I need a effective basic database ...
0
votes
0answers
39 views

Decomposition into BCNF where an attribute appears in multiple functional dependencies

I am trying to decompose my relation: R = (A, B, C, D, E) with Functional Dependencies F = {D -> BC, E -> B, A -> B, B -> D} The problem is that D appears in two dependencies and in ...
0
votes
0answers
45 views

Examples of a database with no consistency measures that ensures consistency through schema alone

To clarify, the database can be any type RDBMS, NoSQL/BigTable. However, it must not employ any usual consistency measures such as locks, or synchronization, but the inconsistency-invincibility must ...
0
votes
0answers
95 views

In DBMS binary relationship is better than ternary

For which reasons (Features/points) binary relationship is better than ternary one in Database ER modeling? I got something by searching in website but those are not precise and meaningful!
-1
votes
0answers
21 views

Justfity the relation of Multi Value Dependecy(MVD)

let say i have this database table: This is how i justify the relation has the Multi Value Dependency (MVD) { Book } { Author } | { Edition, Year } as below. "Because the author attached to the ...