Question : imagine this scenario: I want to run a database that keeps track of all the purchases that every […]
Category: Database Design
What is a good unique identifier for customer and payment details for this tourism company?
Question : Given a tourism company, Air T&T, has customers. When a customer checks in to an AirTnT facility (i.e. […]
How to model data which requires index on all columns?
Question : I have following use case where there are bunch of IDs (GUID) which are mapped to each other. […]
Does SQL Server redistribute data after adding an additional data file?
Question : Imagine a database about 30GB in size using 3 data files on the same disk. Someone told me […]
Status fields: ALTER TYPE vs. INSERT INTO?
Question : I have a simple table with a status column: create type status as enum ( ‘approved’, ‘pending_approval’, ‘rejected’ […]
Is my shopping list database schema good enough? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Real-world scenarios for table with DENY SELECT and GRANT [INSERT/UPDATE/DELETE] [closed]
Question : Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the […]
SQL vs NoSQL: Fetching All records in DynamoDB vs SQL Database
Question : I am designing database for a project which requires frequent querying of all the records. The total number […]
Is one-to-one relationship required?
Question : I have these three tables on my database: There is a one-to-one relationship between Code and Aggregation table […]
Snooping-safe Vote tables
Question : I have a table with both user_id and vote. They are stored together so each user can only […]