Relational vs Document Databases | Dataford Interview Questions

What is RDBMS, and explain the types of joins in SQL

Asked in the Technical stage. Provide a concise explanation of RDBMS and the common SQL join types, then write a PostgreSQL query using the Newgen OmniDocs sample tables.

Output

One row per document, including documents without an assigned owner
Columns: document_id, document_title, owner_name, and assignment_status
Sort by document_id ascending, with unassigned documents included

Schema

omnidocs_documents

Column	Type	Description
document_idPK	INT	Unique document identifier
document_title	VARCHAR(150)	Document title
owner_id	INT	Optional reference to the document owner

omnidocs_users

Column	Type	Description
owner_idPK	INT	Unique owner identifier
owner_name	VARCHAR(100)	Owner display name

Your question is Relational vs Document Databases. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem