0
votes
0answers
17 views

Importance of database schemas [on hold]

I am going to start on a hobby project, It must have a Books inventory database. I am new to databases, I am working with mySql and use php. My question is How important is the database schema? I mean ...
3
votes
1answer
128 views

Optimised Schema for City-to-City Distance Table

This is my first question, forgive me if this question is simple. I'm stuck here, trying to implement the relations for the data represented below. I want to scale it vertically (new rows), instead of ...
3
votes
1answer
59 views

Why isn't there a way to label a column as “keyword”

In a typical star schema, you end up with a bunch of columns that are an ID into some lookup table, where the lookup table is pretty much just this: create table hostnames ( id primary key, ...