Question : Thats the ERD. I’m studying for an upcoming test and having trouble getting my head around converting this […]
Tag: dependencies
Question concerning minimal/cannonical cover
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
Question : There is a question in my book that asks the following: Suppose we have relation R ( A […]
Functional dependencies (hopefully simple question) [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Get list of functions used in a view
Question : Say I have a Function like this: create function house_analysis(ingeo geometry) returns table(count_all numeric, count_important numeric) as $$ […]
Relations, dependencies and normal form
Question : I have some issues in understanding about relations and dependencies. I will show two examples and what I […]
Trick question about FD’s? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Decompose table into third normal form
Question : Tables X and Y are given as below : X (A, B, D, E, F, G, H, J) […]
Attempting to identify minimal functional dependencies in a Compact Disc details scenario
Question : I believe this relation/table is in first normal form (1NF): Collection (cd_id, title, label, artist, type, country, song_id, […]
How to safely replace the old table with its cleaned copy?
Question : I have created a table_cleaned like table and inserted unique values from table into table_cleaned. Now I want […]
- 1
- 2