Understanding SQL: A Comprehensive Guide to Mastering SQL with Martin Gruber

Relational Database Fundamentals: Concepts of tables, rows, columns, and how data links together.

About Martin Gruber

Understanding SQL: A Comprehensive Guide

Check the Solutions: Many editions of the PDF include an answer key for the chapter exercises, allowing you to self-correct your logic.

Data model (typical logical tables)

• documents: document_id, filename, title, author, creation_date, page_count, raw_text
• pages: page_id, document_id, page_num, width, height
• blocks: block_id, page_id, bbox (x,y,w,h), block_type (text, image, table), style_hash
• lines: line_id, block_id, text, y_top, y_bottom, font, font_size
• tokens: token_id, line_id, text, x_start, x_end, font, font_size, token_type
• tables: table_id, page_id, bbox, detected_rows, detected_cols
• table_cells: cell_id, table_id, row_index, col_index, text, bbox
• annotations/links: ann_id, page_id, type, contents, target
• form_fields: field_id, page_id, name, value, field_type