Question : I am trying to solve this example, but for now I can’t. Can somebody show me, step by […]
Tag: database-theory
Right Full Outer Join Query
Question : I came across 1 query which is Select * from R Natural Outer Join S Where R=(A,B) has […]
how is synchronization maintained between different write and read database
Question : One of my friends was asked this question in interview. Given two different databases one on which only […]
Analyzing a query plan for a query with TWO predicates, but index only has ONE
Question : Note: This is from an introductory database systems course at my university so I’m not entirely sure if […]
Database with insert data every 2 minutes
Question : I have a site to develop into PHP and mysql where I take, with a cron, every two […]
Planning simple CMS: How much relation?
Question : I’m currently in the process of designing the database for a rather minimalistic Content Management System I’m working […]
Approach for a 2,000 table migration
Question : What might be the best approach when converting or migrating a database containing over 2,000 tables? Where would […]
Probable circular dependency, but query still runs
Question : I built this ER diagram in MySQL Workbench and it will run and generate the database. My concern […]
Does ‘Cities’ deserve a separate table?
Question : I have the following Customers table: customer_id – int company_name – nvarchar street – nvarchar city – nvarchar […]
Minimal 3NF normalization issues
Question : I’m trying to learn how to normalize to 3NF but the example that my teacher gave us doesn’t […]