Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: dependencies

How to design two tables: A hasMany B, and one B per A has state ‘active’?

By adminPosted on January 24, 2023

Question : Figure two tables: environments and branches. Their relationship is: one environment has many branches. This is easy with […]

list of views that depend on a given table and column

By adminPosted on December 9, 2022

Question : I need a script to check if a given column in a given table is used in any […]

If A and B are candidate keys, then AB is candidate key or not ?

By adminPosted on December 8, 2022

Question : If R{abc} is a relation, f{ a->b b->a a->c b->c }, then a and b are candidate keys. […]

Apply Definition of MVD (multivalued dependency) to Example?

By adminPosted on December 8, 2022

Question : Supposedly this multivalued dependency (MVD) and this functional dependency (FD): {W} ↠ {N,D} and {W} → {N} hold […]

What permissions are needed to view dependencies?

By adminPosted on November 28, 2022

Question : My company is moving to a much more restrictive security model in the near future. As part of […]

Can you determine a functional dependency on a single attribute table?

By adminPosted on November 22, 2022

Question : If an attribute is independent is it possible for it to still have a functional dependency? For example, […]

What exactly is overlapping candidate key?

By adminPosted on October 2, 2022

Question : Can some one please explain to me in simple terms what is overlapping candidate key ? What is […]

Converted ERD into Dependency Diagram 1NF, 3NF

By adminPosted on September 17, 2022

Question : Thats the ERD. I’m studying for an upcoming test and having trouble getting my head around converting this […]

Question concerning minimal/cannonical cover

By adminPosted on July 4, 2022

Question : For the question above, I am confused with how to approach simplifying the left hand side of BDCE->A. […]

Find the functional dependencies that hold in a relation

By adminPosted on June 27, 2022

Question : There is a question in my book that asks the following: Suppose we have relation R ( A […]

  • 1
  • 2
  • 3

Recent Posts

  • What’s the benefit of CROSS JOIN vs INNER JOIN in recursive CTE queries?
  • Mongoexport halts when it reaches 101 records
  • A Script to insert dummy Data in all tables of DB [duplicate]
  • Will query continue to run even after network times-out
  • Need some support on MySQL Query
  • The sort column must be the last column used in the index – MongoDB Indexing Advice
  • Understanding Backup Types
  • SQL Server sp_configure options?
  • DBA Permissions on LOCAL SERVER containing SQL SERVER [closed]
  • Update table using values from another table in SQL Server
  • Getting 0KB of size file while backup mysql database using mysql dump [closed]
  • Local Backup from Amazon RDS PostgreSQL database
  • Who is using my worker threads? SQL Server 2014 – HADR
  • Data Domain Boost viewing backups
  • One table for all persons
  • Database for building a realtime analytics system
  • Threads_cached 0 while thread_cache_size > 0
  • Why is performance non-linear if I do many UPDATEs in a single transaction
  • Mysql innoDB write operations are extremely slow
  • mysql_query expected [closed]

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding