{"id":599,"date":"2021-11-17T13:04:52","date_gmt":"2021-11-17T13:04:52","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/?page_id=599"},"modified":"2021-11-18T08:48:13","modified_gmt":"2021-11-18T08:48:13","slug":"sample-databases","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/reference\/sample-databases\/","title":{"rendered":"Sample Databases"},"content":{"rendered":"<h1>Travel Agency<\/h1>\n<table class=\"datatable\">\n<tbody>\n<tr>\n<td><strong>Customer<\/strong><\/td>\n<td><strong>Booking<\/strong><\/td>\n<td><strong>Hotel<\/strong><\/td>\n<td><strong>Resort<\/strong><\/td>\n<\/tr>\n<tr>\n<td>\n<pre><u>customerNo<\/u> PK\r\nfirstname\r\nsurname\r\naddress\r\ntown\r\npostcode<\/pre>\n<\/td>\n<td>hotelRef PK FK<br \/>\ncustomerNo PK FK<br \/>\nstartDate PK<br \/>\nnumberOfNights<br \/>\nnumberInParty<\/td>\n<td>hotelRef PK<br \/>\nhotelName<br \/>\nresortID FK<br \/>\nstarRating<br \/>\nseasonStartDate<br \/>\nmealPlan<br \/>\ncheckInTime<br \/>\npricePersonNight<\/td>\n<td>resortID PK<br \/>\nresortName<br \/>\nresortType<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h1>GoGo Gadgets:<\/h1>\n<table class=\"datatable\">\n<tbody>\n<tr>\n<td><strong>Customer<\/strong><\/td>\n<td><strong>CustOrder<\/strong><\/td>\n<td><strong>OrderItem<\/strong><\/td>\n<td><strong>Item<\/strong><\/td>\n<\/tr>\n<tr>\n<td>CustomerID PK<br \/>\nForename<br \/>\nSurname<br \/>\nAddress1<br \/>\nAddress2<br \/>\nAddress3<br \/>\nPostcode<br \/>\nCustomerEmail<\/td>\n<td>OrdernNo PK<br \/>\nCustomerID FK<br \/>\nOrderDae<br \/>\nOrderDispatched<\/td>\n<td>OrderNo PK FK<br \/>\nItemID * PK<br \/>\nQuantity<\/td>\n<td>ItemID PK<br \/>\nDescription<br \/>\nCategory<br \/>\nPrice<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Travel Agency Customer Booking Hotel Resort customerNo PK firstname surname address town postcode hotelRef PK FK customerNo PK FK startDate PK numberOfNights numberInParty hotelRef PK hotelName resortID FK starRating seasonStartDate mealPlan checkInTime pricePersonNight resortID PK resortName resortType GoGo Gadgets: Customer CustOrder OrderItem Item CustomerID PK Forename Surname Address1 Address2 Address3 Postcode CustomerEmail OrdernNo PK CustomerID FK OrderDae OrderDispatched OrderNo PK FK ItemID * PK Quantity ItemID PK Description Category Price<\/p>\n<p><a class=\"more-link\" href=\"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/reference\/sample-databases\/\">Read More<\/a><\/p>\n","protected":false},"author":7,"featured_media":0,"parent":53,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-599","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/599","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/comments?post=599"}],"version-history":[{"count":4,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/599\/revisions"}],"predecessor-version":[{"id":628,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/599\/revisions\/628"}],"up":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/53"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/media?parent=599"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}