Health Data Clinic - Book 9: Capstone: Clinic Database

Blank page to working clinic database, in one build. This is where the design skills are put to use together. You take the Riverbend brief, read the requirements out of it, and draw the conceptual model. You normalize that design, settle the final schema, and then write the SQL: CREATE statements for the core tables, for the linking tables that resolve many-to-many relationships, and for the lookup tables that keep coded values consistent. Then you load the data. With the database running you write the queries a clinic actually asks for, a daily schedule, a medication list, a report of completed visits, a gap finder that surfaces what is missing, and a summary report for management. The last chapter puts integrity to the test, showing the constraints refusing a row they should refuse. You finish holding a database you built yourself, not a description of one.

Twenty-six A4 pages, in full color. Written in short sentences and plain English, for readers whose first language is not English and clearer for everyone else because of it.

Every query in this book was run against a live database before the page was printed, so the result you read is the result you get. Instant PDF download. By M.R. Sterling.