Questions tagged [database-management]
115 questions
-1
votes
1 answer
Database Normalisation based on functional dependency
What will be the decomposition for this relation in 1NF, 2NF, 3NF and BCNF
Relation -
Transfers(destination,departs,airline,gate,name,contact,pickup)
Functional Dependencies -
destination, departs, airline → gate
gate → airline
contact → name
name,…
John Pollock
- 11
- 1
-1
votes
1 answer
1:1 Relationship, Is this a good idea?
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…
1Ummyeah
- 1
-1
votes
3 answers
How do I delete duplicates in an access database with multiple one to many relationships
So I have just started a job and all of our data is on this terrible access database with no input validation or protection against changing data.
I am not that familiar with database management as of yet, though I am working on it and I need to…
1Ummyeah
- 1
-1
votes
1 answer
I cannot tell if this is an associative entity or a relationship?
The question is as follows..
"A car company has a database where each car has an identifying serial number and a manufacturing completion date. Each car is an example of a certain model. All models have an identification number, name(e.g., Camry),…
Ethan Altmayer
- 53
- 6
-2
votes
1 answer
Strategies for reducing/shrinking size of Azure SQL Database
I have a Azure SQL Database that's been operational for around 5 years, and is now approaching 300GB in size.
The bulk of the data is in a table with around 4 millions rows. One of the columns of that table is NVARCHAR(MAX) and stores raw JSON. The…
Redwing19
- 75
- 7
-2
votes
1 answer
Whats the best way to sort and search for similar embeddings for facial recognition
I'm planning on making a rather large database of faces/embeddings. I want to know whats the best way to sort my list of embeddings and I also want to know what's the best way to search my list for the most similar face. I'm using deepface for my…
Good boi
- 57
- 4
-2
votes
1 answer
How to find frequency of a value in two different columns in sql?
I have a table which shows arrival airport and departure airport of flights.
I need to find arrivals and departures of every airport
First one is the given table and second is the required table
I have tried the following
SELECT T.departure,…
starlord
- 3
- 2
-2
votes
2 answers
What is the best free (or under 200 dollar) database manager software?
I am currently using Toad, but am not very satisied.
Spencer
- 21,348
- 34
- 85
- 121
-4
votes
1 answer
Undefined reference error along with exit status error when trying to call function in database management system
So I am trying to call a function which creates an assessment class object within the newStudent function. Ideallly the aim is for the newStudent function to run and after it reaches level selection it would call the respective makeAssess functions.…
LGGawd
- 1
- 1
-5
votes
1 answer
How to join each order with its price?
I have two tables named PRICES and ORDERS.
PRICES
Product_ID
price
1
50
2
100
ORDERS
CUSTOMER_ID
Product_ID
QUANTITY
123
1
3
456
2
5
789
2
2
327
1
7
I want to join these two tables to get below expected…
nezamas
- 1
- 2