{"id":255,"date":"2015-12-19T22:08:13","date_gmt":"2015-12-20T03:08:13","guid":{"rendered":"http:\/\/access-diva.com\/blog\/?p=255"},"modified":"2015-12-18T22:10:04","modified_gmt":"2015-12-19T03:10:04","slug":"data-models","status":"publish","type":"post","link":"https:\/\/access-diva.com\/blog\/?p=255","title":{"rendered":"Data Models"},"content":{"rendered":"

Probably the hardest part of designing a database is constructing normalized tables.\u00a0 Get them wrong and everything else is down hill…\u00a0you can’t get the Forms to do what you want and the Reports just don’t work.\u00a0 Let’s see if any of these can make your job easier…<\/p>\n

Clubs (or Associations)<\/a><\/p>\n

Complaints<\/a><\/p>\n

DVD’s<\/a><\/p>\n

Grocery List Maker<\/a><\/p>\n

Hotel Bookings<\/a><\/p>\n

Inspections<\/a><\/p>\n

Jobs (or Works Orders)<\/a><\/p>\n

Parking Lot<\/a><\/p>\n

Products (Shoes or Clothing)<\/a><\/p>\n

Property Management<\/a><\/p>\n

Publications<\/a><\/p>\n

Purchase Orders with Inventory<\/a><\/p>\n

Real Estate<\/a><\/p>\n

Recipes<\/a><\/p>\n

Recipes with Grocery List Maker<\/a><\/p>\n

Restaurant Reservations<\/a><\/p>\n

Tasks<\/a><\/p>\n

Training with Attendance<\/a><\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

Probably the hardest part of designing a database is constructing normalized tables. Get them wrong and everything else is down hill… you can’t get the Forms to do what you want and the Reports just don’t work. Let’s see if any of these can make your job easier…<\/p>\n

Clubs (or Associations)<\/p>\n

Complaints<\/p>\n

DVD’s<\/p>\n

Grocery List […]<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,50,49],"tags":[87,84,54],"class_list":["post-255","post","type-post","status-publish","format-standard","hentry","category-access-tips","category-data-models","category-database-design","tag-data-models","tag-database-design","tag-table-design","odd"],"_links":{"self":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/255","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=255"}],"version-history":[{"count":5,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/255\/revisions"}],"predecessor-version":[{"id":261,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/255\/revisions\/261"}],"wp:attachment":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=255"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=255"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}