Skip to main content
25 questions
Newest Active Bountied Unanswered
Advice
0 votes
6 replies
112 views

I’m wondering when designing a database, is really strict normalization better or do you denormalize for performance from the beginning? It’s better because it runs faster right?
Lexiikaee's user avatar
  • 1
0 votes
3 answers
106 views

I want to normalize following table in Google Sheet: Process Tool A Tool B Process 1 Tool 1 Tool 2 Process 2 Tool 1 Process 3 Tool 2 Tool 3 into the following 1NF table: Process Tool A Tool B Process ...
Sax's user avatar
  • 11
1 vote
0 answers
49 views

I have an Excel table (export from MS MDE, to be precise) of vulnerabilities along with the machines on which they occur. One vulnerability can occur on hundreds of devices and I would like to ...
Kivas's user avatar
  • 57
0 votes
0 answers
49 views

I have a large spreadsheet and need to parse, transpose and insert the parsed values into a new row. My sample data: What I need to do is format the sheet to read as below: I tried TOCOL(A2:(...
DVader's user avatar
  • 33
0 votes
1 answer
55 views

I got a table like this Category is a multiple selection, the count simply is the number of occurrences. I want to tranform to this table . In python, i can use xplode function. But u want using ...
Luan Nguyen Thanh's user avatar
  • 15
1 vote
2 answers
841 views

Student Fruits Foo Apple,Banana Bar Orange Baz Lemon,Orange How do I quantify/analyze the column Fruits with multiple values in a single cell separated by comma? I created multiple helper columns, ...
whatdahil's user avatar
  • 57
-2 votes
1 answer
171 views

For both scenarios I'm using the same Color [lookup] table but storing the data differently. Here's the spec for the records to store: Car with Id 1 is available in 3 colors: Blue, Red, White. Car ...
PassingThru's user avatar
  • 11
0 votes
2 answers
153 views

I need to normalize (in a technical way) table1 by splitting the column "error occured at" so that it was like in table2. Is there is any DML function that will help me solve this? So that ...
user avatar
-2 votes
1 answer
283 views

Storing multiple comma-separated values in a single table field is a notoriously bad design as it impacts performance and breaks relationships. Except I don't know how to change things. I have a ...
Puddintane's user avatar
  • 5
1 vote
2 answers
107 views

I currently have a dataset that is formatted: Company Clients Date Type Amt comp1 client1, client2, client3 01/02/22 visa $1500 comp2 client1 amex $600 comp3 client3, client4, client5, client1 02/23/...
Kent Ratliff's user avatar
  • 13
-1 votes
1 answer
626 views

I have a dataset like this import pandas as pd df = pd.read_csv("music.csv") df name date singer language phase 1 Yes or No 02.01.20 Benjamin Smith en 1 2 Parabens 01.06.21 Rafael Galvao;...
user avatar
1 vote
2 answers
392 views

I have 2 columns, first name and surname. I want to split a cell that contains multiple values and then combine it with the cell on the right. I have no idea how to do this using a formula, please ...
John Ket's user avatar
  • 21
-1 votes
3 answers
601 views

Given the following relation: school =(teacherID, list of kids) I need to convert this to First Normal Form. My thought was that I have one table for teacherID then have a kids table with each kid ...
Kaitlyn Wheeler's user avatar
  • 3
89 votes
8 answers
119k views

When using SQL, like MySQL, or any relational DB, saving the data in regular columns is better for indexing and other purposes. But loading and saving JSON data is sometimes a lot more simple and ...
user avatar
0 votes
1 answer
825 views

I have a relation CAR_SALE(Car#, Date_sold, Salesperson#, Commission%, Discount_amt) Primary Key: {Car#, Salesperson#} Additional Dependencies: Date_sold -> Discount_amt ...
GenericUser01's user avatar
  • 457

15 30 50 per page
1
2