1<!DOCTYPE html> 2<html lang="en-GB" dir="ltr"> 3 <head> 4 <meta name="viewport" content="width=device-width, initial-scale=1.0"> 5 <meta http-equiv="X-UA-Compatible" content="IE=edge" /> 6 7 8 <meta charset="utf-8" /> 9 <base href="https://fidelcaptain.com/sixstep/casestudies.html" /> 10 <meta name="keywords" content="IT, information, technology, education, consultant, database, web, internet, development, design, application, solutions, business, fidel, captain, guyana" /> 11 <meta name="rights" content="© 2025 Fidel A. Captain. All rights reserved." /> 12 <meta name="author" content="Fidel Captain" /> 13 <meta name="description" content="Fidel A. Captain, IT Consultant and Educator" /> 14 <meta name="generator" content="Joomla! - Open Source Content Management" /> 15 <title>Fidel A. Captain - Case Studies</title> 16 <link href="/favicon.ico" rel="shortcut icon" type="image/vnd.microsoft.icon" /> 17 <link href="/plugins/system/microformatsvotes/assets/css/microformatsvotes.css" rel="stylesheet" media="screen" /> 18 <link href="/plugins/system/rokbox/assets/styles/rokbox.css" rel="stylesheet" /> 19 <link href="/media/gantry5/assets/css/font-awesome.min.css" rel="stylesheet" /> 20 <link href="/media/gantry5/engines/nucleus/css-compiled/nucleus.css" rel="stylesheet" /> 21 <link href="/templates/rt_gemini/custom/css-compiled/gemini_20.css" rel="stylesheet" /> 22 <link href="/media/gantry5/assets/css/bootstrap-gantry.css" rel="stylesheet" /> 23 <link href="/media/gantry5/engines/nucleus/css-compiled/joomla.css" rel="stylesheet" /> 24 <link href="/media/jui/css/icomoon.css" rel="stylesheet" /> 25 <link href="/templates/rt_gemini/custom/css-compiled/gemini-joomla_20.css" rel="stylesheet" /> 26 <link href="/templates/rt_gemini/custom/css-compiled/custom_20.css" rel="stylesheet" /> 27 <link href="/templates/rt_gemini/css/animate.css" rel="stylesheet" /> 28 <link href="/templates/rt_gemini/custom/custom.css" rel="stylesheet" /> 29
29<script type="application/json" class="joomla-script-options new">{"csrf.token":"60de4c89eacc0ee82588f33b822b87aa","system.paths":{"root":"","base":""}}</script>
29 30
30<script src="/media/jui/js/jquery.min.js?a3031b1f6bfc9ac7b00840412b0aa5a7"></script>
30 31
31<script src="/media/jui/js/jquery-noconflict.js?a3031b1f6bfc9ac7b00840412b0aa5a7"></script>
31 32
32<script src="/media/jui/js/jquery-migrate.min.js?a3031b1f6bfc9ac7b00840412b0aa5a7"></script>
32 33
33<script src="/media/system/js/caption.js?a3031b1f6bfc9ac7b00840412b0aa5a7"></script>
33 34
34<script src="/media/system/js/mootools-core.js?a3031b1f6bfc9ac7b00840412b0aa5a7"></script>
34 35
35<script src="/media/system/js/core.js?a3031b1f6bfc9ac7b00840412b0aa5a7"></script>
35 36
36<script src="/plugins/system/microformatsvotes/assets/js/plugin.js"></script>
36 37
37<script src="/media/system/js/mootools-more.js?a3031b1f6bfc9ac7b00840412b0aa5a7"></script>
37 38
38<script src="/plugins/system/rokbox/assets/js/rokbox.js"></script>
38 39
39<script src="/modules/mod_rokajaxsearch/js/rokajaxsearch.js"></script>
39 40
40<script src="/media/jui/js/jquery.ui.core.min.js?a3031b1f6bfc9ac7b00840412b0aa5a7"></script>
40 41
41<script src="/media/jui/js/bootstrap.min.js?a3031b1f6bfc9ac7b00840412b0aa5a7"></script>
41 42
42<script> 43jQuery(window).on('load', function() { 44 new JCaption('img.caption'); 45 });�var SITE_ROOT = "https://fidelcaptain.com/";�if (typeof RokBoxSettings == 'undefined') RokBoxSettings = {pc: '100'};�window.addEvent((window.webkit) ? 'load' : 'domready', function() { 46 window.rokajaxsearch = new RokAjaxSearch({ 47 'results': 'Results', 48 'close': '', 49 'websearch': 0, 50 'blogsearch': 0, 51 'imagesearch': 0, 52 'videosearch': 0, 53 'imagesize': 'MEDIUM', 54 'safesearch': 'MODERATE', 55 'search': 'Search...', 56 'readmore': 'Read more...', 57 'noresults': 'No results', 58 'advsearch': 'Advanced search', 59 'page': 'Page', 60 'page_of': 'of', 61 'searchlink': 'https://fidelcaptain.com/index.php?option=com_search&view=search&tmpl=component', 62 'advsearchlink': 'https://fidelcaptain.com/index.php?option=com_search&view=search', 63 'uribase': 'https://fidelcaptain.com/', 64 'limit': '10', 65 'perpage': '3', 66 'ordering': 'popular', 67 'phrase': 'any', 68 'hidedivs': '', 69 'includelink': 1, 70 'viewall': 'View all results', 71 'estimated': 'estimated', 72 'showestimated': 1, 73 'showpagination': 1, 74 'showcategory': 0, 75 'showreadmore': 0, 76 'showdescription': 1 77 }); 78 });
vendor: 347 bytes, lines 78-81
78� (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ 79 (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), 80 m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) 81 })(window,document,'script','//www.google-analytics.com/analytics.js','ga'); ga('create', '
81UA-1072665-1
vendor: 54 bytes, lines 81-84
81', 'auto'); 82 ga('send', 'pageview'); 83 84
84</script>
84 85 86 <!--[if (gte IE 8)&(lte IE 9)]> 87
87<script type="text/javascript" src="/media/gantry5/assets/js/html5shiv-printshiv.min.js"></script>
87 88 <link rel="stylesheet" href="/media/gantry5/engines/nucleus/css/nucleus-ie9.css" type="text/css"/> 89
89<script type="text/javascript" src="/media/gantry5/assets/js/matchmedia.polyfill.js"></script>
89 90 <![endif]--> 91 </head> 92 93 <body class="gantry site com_content view-article no-layout no-task dir-ltr itemid-126 outline-20 g-offcanvas-left g-default g-style-preset4"> 94 95 96 97 <div id="g-offcanvas" data-g-offcanvas-swipe="0" data-g-offcanvas-css3="1"> 98 <div class="g-grid"> 99 100 <div class="g-block size-100"> 101 <div id="mobile-menu-6905-particle" class="g-content g-particle"> <div id="g-mobilemenu-container" data-g-menu-breakpoint="48rem"></div> 102 </div> 103 </div> 104 </div> 105 </div> 106 <div id="g-page-surround"> 107 <div class="g-offcanvas-hide g-offcanvas-toggle" data-offcanvas-toggle aria-controls="g-offcanvas" aria-expanded="false"><i class="fa fa-fw fa-bars"></i></div> 108 109 110 111 112 113 <section id="g-container-overlay" class="g-wrapper"> 114 <div class="g-grid"> 115 116 <div class="g-block size-57"> 117 <aside id="g-sideoverlay"> 118 <div class="g-grid"> 119 120 <div class="g-block size-100"> 121 <div id="accordionmenu-8277-particle" class="g-content g-particle"> <div class=""> 122 <div class="g-accordionmenu"> 123 <h2 class="g-title">Browse</h2> <nav class="nav" role="navigation"> 124 <ul class="nav__list"> 125 <li> 126 <input id="group-1" type="checkbox" hidden /> 127 <label for="group-1"><span class="indicator"></span> Six-Step Database Design</label> 128 <ul class="group-list"> 129 <li><a target="_self" href="/sixstep.html">The Book</a></li> 130 <li><a target="_self" href="/sixstep/videolectures.html">Video Lectures</a></li> 131 <li><a target="_self" href="/sixstep/casestudies.html">Case Studies</a></li> 132 <li><a target="_self" href="/sixstep/onlinecourses.html">Online Courses</a></li> 133 </ul> 134 </li> 135 <li> 136 <input id="group-2" type="checkbox" hidden /> 137 <label for="group-2"><span class="indicator"></span> Educator</label> 138 <ul class="group-list"> 139 <li><a target="_self" href="/educator.html#papers">Papers and Essays</a></li> 140 <li><a target="_self" href="/educator.html#handouts">Student Handouts</a></li> 141 <li><a target="_self" href="/educator.html#lectures">College Lectures (videos)</a></li> 142 </ul> 143 </li> 144 </ul> 145 </nav> 146 </div> 147</div> 148 </div> 149 </div> 150 </div> 151 152 </aside> 153 </div> 154 155 156 <div class="g-block size-43"> 157 <main id="g-mainoverlay"> 158 <div class="g-grid"> 159 160 <div class="g-block size-100 my-nopadding-bottom my-nomargin-bottom"> 161 <div id="custom-9290-particle" class="g-content g-particle"> <h2 class="g-title">Contact</h2> 162<p class="g-demo-contact"> 163<span class="fa fa-envelope-o fw" > </span>[email protected]<br /><span class="fa fa-whatsapp fw" > </span> 164+1 284 542 4404. 165</p> 166<p><a href="#" onclick="window.open('https://www.sitelock.com/verify.php?site=fidelcaptain.com','SiteLock','width=600,height=600,left=160,top=170');" ><img class="img-responsive" alt="SiteLock" title="SiteLock" src="//shield.sitelock.com/shield/fidelcaptain.com" /></a></p> 167 </div> 168 </div> 169 </div> 170 <div class="g-grid"> 171 172 <div class="g-block size-100 my-nopadding-top my-nomargin-top"> 173 <div id="social-5073-particle" class="g-content g-particle"> <h2 class="g-title">Follow</h2> <div class="g-social my-nopadding-top my-nomargin-top"> 174 <a target="_blank" href="https://twitter.com/fidelacaptain" title="" aria-label="">
175 <span class="fa fa-twitter-square fa-fw"></span> <span class="g-social-text"></span> </a> 176 <a target="_blank" href="https://www.linkedin.com/in/fidelcaptain/" title="" aria-label=""> 177 <span class="fa fa-linkedin-square fa-fw"></span> <span class="g-social-text"></span> </a> 178 <a target="_blank" href="https://www.facebook.com/SixStepRelationalDatabaseDesign/" title="" aria-label=""> 179 <span class="fa fa-facebook-square fa-fw"></span> <span class="g-social-text"></span> </a> 180 <a target="_blank" href="https://www.youtube.com/user/fidelcaptain/videos" title="" aria-label=""> 181 <span class="fa fa-youtube-square fa-fw"></span> <span class="g-social-text"></span> </a> 182 </div> 183 </div> 184 </div> 185 </div> 186 187 </main> 188 </div> 189 </div> 190 191 </section> 192 193 194 <section id="g-top"> 195 <div class="g-grid"> 196 197 <div class="g-block size-100"> 198 <div class="g-system-messages"> 199 200 201 </div> 202 </div> 203 </div> 204 205 </section> 206 207 <section id="g-navigation"> 208 <div class="g-grid"> 209 210 <div class="g-block size-20"> 211 <div id="logo-3998-particle" class="g-content g-particle"> <a href="/" target="_self" title="" rel="home" class="g-logo"> 212 <img src="/templates/rt_gemini/custom/images/logo1.png" alt="" /> 213 </a> 214 </div> 215 </div> 216 217 218 <div class="g-block size-75 align-right"> 219 <div id="menu-5913-particle" class="g-content g-particle"> <nav class="g-main-nav" role="navigation" data-g-hover-expand="true"> 220 <ul class="g-toplevel"> 221 222 <li class="g-menu-item g-menu-item-type-component g-menu-item-120 g-standard "> 223 <a class="g-menu-item-container" href="/"> 224 <span class="g-menu-item-content"> 225 <span class="g-menu-item-title">Home</span> 226 227 </span> 228 </a> 229 </li> 230 231 232 <li class="g-menu-item g-menu-item-type-component g-menu-item-121 g-parent active g-standard g-menu-item-link-parent "> 233 <a class="g-menu-item-container" href="/sixstep.html"> 234 <span class="g-menu-item-content"> 235 <span class="g-menu-item-title">Six-Step Database Design</span> 236 237 </span> 238 <span class="g-menu-parent-indicator" data-g-menuparent=""></span> </a> 239 <ul class="g-dropdown g-inactive g-fade g-dropdown-right"> 240 <li class="g-dropdown-column"> 241 <div class="g-grid"> 242 <div class="g-block size-100"> 243 <ul class="g-sublevel"> 244 <li class="g-level-1 g-go-back"> 245 <a class="g-menu-item-container" href="#" data-g-menuparent=""><span>Back</span></a> 246 </li> 247 248 <li class="g-menu-item g-menu-item-type-component g-menu-item-124 "> 249 <a class="g-menu-item-container" href="/sixstep/onlinecourses.html"> 250 <sp
250an class="g-menu-item-content"> 251 <span class="g-menu-item-title">Online Courses</span> 252 253 </span> 254 </a> 255 </li> 256 257 258 <li class="g-menu-item g-menu-item-type-component g-menu-item-126 g-parent active g-menu-item-link-parent "> 259 <a class="g-menu-item-container" href="/sixstep/casestudies.html"> 260 <span class="g-menu-item-content"> 261 <span class="g-menu-item-title">Case Studies</span> 262 263 </span> 264 <span class="g-menu-parent-indicator" data-g-menuparent=""></span> </a> 265 <ul class="g-dropdown g-inactive g-fade g-dropdown-right"> 266 <li class="g-dropdown-column"> 267 <div class="g-grid"> 268 <div class="g-block size-100"> 269 <ul class="g-sublevel"> 270 <li class="g-level-2 g-go-back"> 271 <a class="g-menu-item-container" href="#" data-g-menuparent=""><span>Back</span></a> 272 </li> 273 274 <li class="g-menu-item g-menu-item-type-component g-menu-item-127 "> 275 <a class="g-menu-item-container" href="/sixstep/casestudies/casestudy1.html"> 276 <span class="g-menu-item-content"> 277 <span class="g-menu-item-title">Case Study 1</span> 278 279 </span> 280 </a> 281 </li> 282 283 284 <li class="g-menu-item g-menu-item-type-component g-menu-item-128 "> 285 <a class="g-menu-item-container" href="/sixstep/casestudies/casestudy2.html"> 286 <span class="g-menu-item-content"> 287 <span class="g-menu-item-title">Case Study 2</span> 288 289 </span> 290 </a> 291 </li> 292 293 294 <li class="g-menu-item g-menu-item-type-component g-menu-item-129 "> 295 <a class="g-menu-item-container" href="/sixstep/casestudies/casestudy3.html"> 296 <span class="g-menu-item-content"> 297 <span class="g-menu-item-title">Case Study 3</span> 298 299 </span> 300 </a> 301 </li> 302 303 304 </ul> 305 </div> 306 </div> 307 308 </li> 309 </ul> 310 </li> 311 312 313 </ul> 314 </div> 315 </div> 316 317 </li> 318 </ul> 319 </li> 320 321 322 <li class="g-menu-item g-menu-item-type-component g-menu-item-122 g-standard "> 323 <a class="g-menu-item-container" href="/consulting.html"> 324 <span class="g-menu-item-content"> 325 <span class="g-menu-item-title">Consulting</span> 326 327 </span> 328 </a> 329 </li> 330 331 332 <li class="g-menu-item g-menu-item-type-component g-menu-item-123 g-parent g-standard g-menu-item-link-parent "> 333 <a class="g-menu-item-container" href="/educator.html"> 334 <sp
334an class="g-menu-item-content"> 335 <span class="g-menu-item-title">Educator</span> 336 337 </span> 338 <span class="g-menu-parent-indicator" data-g-menuparent=""></span> </a> 339 <ul class="g-dropdown g-inactive g-fade g-dropdown-right"> 340 <li class="g-dropdown-column"> 341 <div class="g-grid"> 342 <div class="g-block size-100"> 343 <ul class="g-sublevel"> 344 <li class="g-level-1 g-go-back"> 345 <a class="g-menu-item-container" href="#" data-g-menuparent=""><span>Back</span></a> 346 </li> 347 348 <li class="g-menu-item g-menu-item-type-heading g-menu-item-155 g-parent "> 349 <div class="g-menu-item-container" data-g-menuparent=""> <span class="g-nav-header g-menu-item-content"> <span class="g-menu-item-title">Papers and Essays</span> 350 </span> 351 <span class="g-menu-parent-indicator"></span> </div> <ul class="g-dropdown g-inactive g-fade g-dropdown-right"> 352 <li class="g-dropdown-column"> 353 <div class="g-grid"> 354 <div class="g-block size-100"> 355 <ul class="g-sublevel"> 356 <li class="g-level-2 g-go-back"> 357 <a class="g-menu-item-container" href="#" data-g-menuparent=""><span>Back</span></a> 358 </li> 359 360 <li class="g-menu-item g-menu-item-type-component g-menu-item-160 "> 361 <a class="g-menu-item-container" href="/educator/papersandessays/postsecedupolicydevguyana.html"> 362 <span class="g-menu-item-content"> 363 <span class="g-menu-item-title">Post-secondary education policy as a tool for the economic and social development of Guyana</span> 364 365 </span> 366 </a> 367 </li> 368 369 370 <li class="g-menu-item g-menu-item-type-component g-menu-item-161 "> 371 <a class="g-menu-item-container" href="/educator/papersandessays/higheredaccreditationus.html"> 372 <span class="g-menu-item-content"> 373 <span class="g-menu-item-title">Higher Education Accreditation (in the United States)</span> 374 375 </span> 376 </a> 377 </li> 378 379 380 <li class="g-menu-item g-menu-item-type-component g-menu-item-162 "> 381 <a class="g-menu-item-container" href="/educator/papersandessays/gogpostsecedupolicy.html"> 382 <span class="g-menu-item-content"> 383 <span class="g-menu-item-title">Government of Guyanaâs policy on post-secondary education as a tool for national economic and social development</span> 384 385 </span> 386 </a> 387 </li> 388 389 390 <li class="g-menu-item g-menu-item-type-component g-menu-item-163 "> 391 <a class="g-menu-item-container" href="/educator/papersandessays/postsecedurecommendations.html"> 392 <sp
392an class="g-menu-item-content"> 393 <span class="g-menu-item-title">Recommendations for 21st century post-secondary education in Guyana and other developing countries</span> 394 395 </span> 396 </a> 397 </li> 398 399 400 <li class="g-menu-item g-menu-item-type-component g-menu-item-164 "> 401 <a class="g-menu-item-container" href="/educator/papersandessays/guyanacommunitycollege.html"> 402 <span class="g-menu-item-content"> 403 <span class="g-menu-item-title">Guyana needs a community college in its education system</span> 404 405 </span> 406 </a> 407 </li> 408 409 410 <li class="g-menu-item g-menu-item-type-component g-menu-item-165 "> 411 <a class="g-menu-item-container" href="/educator/papersandessays/culturalpreservationthroughipr.html"> 412 <span class="g-menu-item-content"> 413 <span class="g-menu-item-title">Cultural Preservation Through Intellectual Property Protection</span> 414 415 </span> 416 </a> 417 </li> 418 419 420 <li class="g-menu-item g-menu-item-type-component g-menu-item-166 "> 421 <a class="g-menu-item-container" href="/educator/papersandessays/ipr.html"> 422 <span class="g-menu-item-content"> 423 <span class="g-menu-item-title">Intellectual Property: What it is and why it needs to be protected in developing nations in the new millennium</span> 424 425 </span> 426 </a> 427 </li> 428 429 430 </ul> 431 </div> 432 </div> 433 434 </li> 435 </ul> 436 </li> 437 438 439 <li class="g-menu-item g-menu-item-type-heading g-menu-item-156 g-parent "> 440 <div class="g-menu-item-container" data-g-menuparent=""> <span class="g-nav-header g-menu-item-content"> <span class="g-menu-item-title">Student Handouts</span> 441 </span> 442 <span class="g-menu-parent-indicator"></span> </div> <ul class="g-dropdown g-inactive g-fade g-dropdown-right"> 443 <li class="g-dropdown-column"> 444 <div class="g-grid"> 445 <div class="g-block size-100"> 446 <ul class="g-sublevel"> 447 <li class="g-level-2 g-go-back"> 448 <a class="g-menu-item-container" href="#" data-g-menuparent=""><span>Back</span></a> 449 </li> 450 451 <li class="g-menu-item g-menu-item-type-component g-menu-item-168 "> 452 <a class="g-menu-item-container" href="/educator/studenthandouts/websitedesign.html"> 453 <span class="g-menu-item-content"> 454 <span class="g-menu-item-title">Website Design</span> 455 456 </span> 457 </a> 458 </li> 459 460 461 <li class="g-menu-item g-menu-item-type-component g-menu-item-169 "> 462 <a class="g-menu-item-container" href="/educator/studenthandouts/webpagedesign.html"> 463 <sp
463an class="g-menu-item-content"> 464 <span class="g-menu-item-title">Webpage Design</span> 465 466 </span> 467 </a> 468 </li> 469 470 471 <li class="g-menu-item g-menu-item-type-component g-menu-item-171 "> 472 <a class="g-menu-item-container" href="/educator/studenthandouts/componentsofadbms.html"> 473 <span class="g-menu-item-content"> 474 <span class="g-menu-item-title">Components of a DBMS</span> 475 476 </span> 477 </a> 478 </li> 479 480 481 <li class="g-menu-item g-menu-item-type-component g-menu-item-170 "> 482 <a class="g-menu-item-container" href="/educator/studenthandouts/databasesndbmss.html"> 483 <span class="g-menu-item-content"> 484 <span class="g-menu-item-title">Databases and DBMSs</span> 485 486 </span> 487 </a> 488 </li> 489 490 491 <li class="g-menu-item g-menu-item-type-component g-menu-item-174 "> 492 <a class="g-menu-item-container" href="/educator/studenthandouts/computernetworks.html"> 493 <span class="g-menu-item-content"> 494 <span class="g-menu-item-title">Computer Networks</span> 495 496 </span> 497 </a> 498 </li> 499 500 501 <li class="g-menu-item g-menu-item-type-component g-menu-item-167 "> 502 <a class="g-menu-item-container" href="/educator/studenthandouts/subnetting.html"> 503 <span class="g-menu-item-content"> 504 <span class="g-menu-item-title">Subnetting</span> 505 506 </span> 507 </a> 508 </li> 509 510 511 <li class="g-menu-item g-menu-item-type-component g-menu-item-173 "> 512 <a class="g-menu-item-container" href="/educator/studenthandouts/osimodel.html"> 513 <span class="g-menu-item-content"> 514 <span class="g-menu-item-title">The OSI Model</span> 515 516 </span> 517 </a> 518 </li> 519 520 521 <li class="g-menu-item g-menu-item-type-component g-menu-item-172 "> 522 <a class="g-menu-item-container" href="/educator/studenthandouts/tcpipsuite.html"> 523 <span class="g-menu-item-content"> 524 <span class="g-menu-item-title">The TCP/IP Protocol Suite</span> 525 526 </span> 527 </a> 528 </li> 529 530 531 </ul> 532 </div> 533 </div> 534 535 </li> 536 </ul> 537 </li> 538 539 540 <li class="g-menu-item g-menu-item-type-url g-menu-item-175 "> 541 <a class="g-menu-item-container" href="/educator.html#lectures"> 542 <sp
542an class="g-menu-item-content"> 543 <span class="g-menu-item-title">College Lectures (videos)</span> 544 545 </span> 546 </a> 547 </li> 548 549 550 </ul> 551 </div> 552 </div> 553 554 </li> 555 </ul> 556 </li> 557 558 559 <li class="g-menu-item g-menu-item-type-component g-menu-item-159 g-standard "> 560 <a class="g-menu-item-container" href="/background.html"> 561 <span class="g-menu-item-content"> 562 <span class="g-menu-item-title">Background</span> 563 564 </span> 565 </a> 566 </li> 567 568 569 <li class="g-menu-item g-menu-item-type-component g-menu-item-119 g-standard "> 570 <a class="g-menu-item-container" href="/feedback.html"> 571 <span class="g-menu-item-content"> 572 <span class="g-menu-item-title">Feedback</span> 573 574 </span> 575 </a> 576 </li> 577 578 579 </ul> 580</nav> 581 </div> 582 </div> 583 584 585 <div class="g-block size-5 align-right nopaddingright"> 586 <div id="overlaytoggle-5711-particle" class="g-content g-particle"> <div class=""> 587 <div class="g-overlaytoggle"> 588 <a id="trigger-overlay" class="nav_slide_button nav-toggle" href="#" onclick="return false"> 589 <span class="g-overlaytoggle-bar-wrapper"><span class="g-overlaytoggle-bar"></span></span> 590 </a> 591 </div> 592</div> 593 </div> 594 </div> 595 </div> 596 <div class="g-grid"> 597 598 <div class="g-block size-84"> 599 <div class="spacer"></div> 600 </div> 601 602 603 <div class="g-block size-16 nomarginall nopaddingall"> 604 <div class="g-content"> 605 <div class="platform-content"><div class="moduletable "> 606 <form name="rokajaxsearch" id="rokajaxsearch" class="light" action="https://fidelcaptain.com/" method="get"> 607<div class="rokajaxsearch "> 608 <div class="roksearch-wrapper"> 609 <input id="roksearch_search_str" name="searchword" type="text" class="inputbox roksearch_search_str" placeholder="Search..." /> 610 </div> 611 <input type="hidden" name="searchphrase" value="any"/> 612 <input type="hidden" name="limit" value="20" /> 613 <input type="hidden" name="ordering" value="popular" /> 614 <input type="hidden" name="view" value="search" /> 615 <input type="hidden" name="option" value="com_search" /> 616 617 618 <div id="roksearch_results"></div> 619</div> 620<div id="rokajaxsearch_tmp" style="visibility:hidden;display:none;"></div> 621</form> 622 </div></div> 623 624 </div> 625 </div> 626 </div> 627 628 </section> 629 630 <section id="g-slideshow"> 631 <div class="g-grid"> 632 633 <div class="g-block size-100 center"> 634 <div id="simplecontent-9784-particle" class="g-content g-particle"> <div class=""> 635 <div class="g-simplecontent"> 636 637 638 <div class="g-simplecontent-item g-simplecontent-layout-standard"> 639 640 641 642 643 <div class="g-simplecontent-item-content-title"><strong>Case </strong> Studies</div> 644 645 <div class="g-simplecontent-item-leading-content"><div style="text-align: justify;">Three case studies are used to guide the reader through the six steps outlined in the <em>Six-Step Relational Database Design™</em> book, each increasing in complexity. Each case study begins with a real world scenario and takes the user through the E-R and R-M diagrams, ending with executable SQL commands to implement the derived designs.</div> </div> 646 </div> 647 648 </div> 649 </div> 650 </div> 651 </div> 652 </div> 653 654 </section> 655 656 657 658 659 <section id="g-container-main" class="g-wrapper"> 660 <div class="g-grid"> 661 662 <div class="g-block size-100"> 663 <main id="g-mainbar"> 664 <div class="g-grid"> 665 666 <div class="g-block size-100"> 667 <div class="g-content"> 668 <div class="platform-content row-fluid"><div class="span12"><div class="item-page" itemscope itemtype="https://schema.org/Article"> 669 <meta itemprop="inLanguage" content="en-GB" /> 670 671 672 <div class="page-header"> 673 <h2 itemprop="headline"> 674 Case Studies in Six-Step Relational Database Design </h2><div style="clear:both;margin:7px 0"> 675 <div class="hreview-aggregate plgmfv-inline-rating" id="com_content.article-8" itemprop="aggregateRating" itemscope itemtype="http://schema.org/AggregateRating"><span class="rating"> 676 <div class="plgmfv-inline-rating-stars" id="mfv"> 677 <ul class="plgmfv-star-rating"> 678 <li id="mfv-current-rating" style="width:86.6%;"> </li> 679 <li><a title="1 star out of 5" class="plgmfv-toggler one-star worst" itemprop="worstRating">1</a></li> 680 <li><a title="2 stars out of 5" class="plgmfv-toggler two-stars">2</a></li> 681 <li><a title="3 stars out of 5" class="plgmfv-toggler three-stars">3</a></li> 682 <li><a title="4 stars out of 5" class="plgmfv-toggler four-stars">4</a></li> 683 <li><a title="5 stars out of 5" class="plgmfv-toggler five-stars best" itemprop="bestRating">5</a></li> 684 </ul>
685 </div><div class="plgmfv-box">(<span class="votes" itemprop="ratingCount">33</span> votes, average <span class="average" itemprop="ratingValue">4.33</span> out of 5)</div></span></div></div> 686 </div> 687 688 689 690 691 692 <div itemprop="articleBody"> 693 <p> </p> 694 695<h4>Case Study 1</h4> 696<p style="text-align: justify;">This is the first of three case studies that are used to guide the reader through the six steps outlined in <a href="http://fidelcaptain.com/sixstep.html" target="_self" title="Six-Step Relational Database Design"><em>Six-Step Relational Database Design™</em></a>. The most important outputs of the six step database design process are outlined here, but the details of each of the steps and intermediary outputs are described in the book.</p> 697 698<div style="float: left; margin: 15px;"> 699<table class="table table-hover table-bordered"> 700<thead> 701<tr class="info"><th>Quick links for Case Study 1</th></tr> 702</thead> 703<tbody> 704<tr class="info"> 705<td><span class="fa fa-bookmark-o">Â </span>Â <a href="/sixstep/casestudies/casestudy1.html" title="Case Study 1">Case Study 1</a><br /><br /> <span class="fa fa-bookmark-o">Â </span>Â <a href="/sixstep/casestudies/casestudy1.html#entities" title="List of entities and their corresponding attributes">List of entities and their corresponding attributes</a><br /><br /> <span class="fa fa-bookmark-o">Â </span>Â <a href="/sixstep/casestudies/casestudy1.html#erd" title="Entity-Relationship diagrams">Entity-Relationship diagrams</a><br /><br /> <span class="fa fa-bookmark-o">Â </span>Â <a href="/sixstep/casestudies/casestudy1.html#rmd" title="Relational-Model diagram">Relational-Model diagram</a><br /><br /> <span class="fa fa-bookmark-o">Â </span>Â <a href="/sixstep/casestudies/casestudy1.html#sql" title="SQL commands">SQL commands</a></td> 706</tr> 707</tbody> 708</table> 709</div> 710 711<h5 style="clear: both;" >Scenario for Case Study 1</h5> 712<div style="text-align: justify; margin-left: 15px; margin-right: 15px; background: #eee; border: 1px solid #999; padding: 10px;"> 713<p>A corporate office intends to implement a digital front desk solution to assist receptionists in managing key administrative functions for senior management staff (e.g. executives, department heads). The application for the new system will streamline the management of appointments, meeting rooms, visitors, and administrative tasks. <br /><br />The application must be capable of:</p> 714<ul> 715 <li>Tracking all appointments scheduled for senior management staff.</li> 716 <li>Managing meeting rooms assigned to these appointments and preventing scheduling conflicts.</li> 717 <li>Recording details of visitors attending appointments, including check-in/check-out times (visitor log).</li> 718 <li>Managing administrative tasks associated with senior staff and linking them to relevant appointments and visitors, where applicable.</li> 719</ul> 720<p>Additionally, the system must be password-protected and support role-based access control, ensuring that users (e.g. receptionists, assistants, senior staff) can only access features appropriate to their roles. User login activity must also be recorded. <br /><br />To promote transparency and accountability, the application should include basic auditing features, such as tracking who created or modified records and when. Extensive logging of database changes is not required. <br /><br />Your job is to design a database that will serve as the back end of this application.</p> 721</div> 722 723<h4>Case Study 2</h4> 724<p style="text-align: justify;">This is the second of three case studies that are used to guide the reader through the six steps outlined in the <a href="http://fidelcaptain.com/sixstep.html" target="_self" title="Six-Step Relational Database Design"><em>Six-Step Relational Database Design™</em></a> book. The most important outputs of the six step database design process are outlined here, but the details of each of the steps and intermediary outputs are described in the book.</p> 725 726<div style="float: left; margin: 15px;"> 727<table class="table table-hover table-bordered"> 728<thead> 729<tr class="info"><th>Quick links for Case Study 2</th></tr> 730</thead> 731<tbody> 732<tr class="info"> 733<td><span class="fa fa-bookmark-o">Â </span>Â <a href="/sixstep/casestudies/casestudy2.html" title="Case Study 2">Case Study 2</a><br /><br /> <span class="fa fa-bookmark-o">Â </span>Â <a href="/sixstep/casestudies/casestudy2.html#entities" title="List of entities and their corresponding attributes">List of entities and their corresponding attributes</a><br /><br /> <span class="fa fa-bookmark-o">Â </span>Â <a href="/sixstep/casestudies/casestudy2.html#erd" title="Entity-Relationship diagrams">Entity-Relationship diagrams</a><br /><br /> <span class="fa fa-bookmark-o">Â </span>Â <a href="/sixstep/casestudies/casestudy2.html#rmd" title="Relational-Model diagram">Relational-Model diagram</a><br /><br /> <span class="fa fa-bookmark-o">Â </span>Â <a href="/sixstep/casestudies/casestudy2.html#sql" title="SQL commands">SQL commands</a></td> 734</tr> 735</tbody> 736</table> 737</div> 738 739<h5 style="clear: both;" >Scenario for Case Study 2</h5> 740<div style="text-align: justify; margin-left: 15px; margin-right: 15px; background: #eee; border: 1px solid #999; padding: 10px;"> 741<p>A mid-sized restaurant plans to implement a digital system to streamline and manage its daily operations. The application will support key functions such as customer reservations, table management, menu offerings, order processing, and billing. <br /><br />The application must be capable of:</p> 742<ul> 743 <li>Managing customer reservations, including the customer, reservation times, and table assignments.</li> 744 <li>Tracking table availability and status, indicating whether tables are free, reserved, or currently in use.</li> 745 <li>Maintaining a digital menu, listing all available items along with their descriptions, prices, and availability status.</li> 746 <li>Recording and tracking customer orders, including quantities, menu items selected, and special instructions (e.g. allergies, dietary restrictions such as strict vegetarian).</li> 747 <li>Generating itemized bills, with support for splitting by order, and including applicable service charges, taxes, and the total amount due.</li> 748</ul> 749<p>Additionally, the system must be password-protected and support role-based access control, ensuring that users (e.g. host/h
749ostess, customers, waiters, kitchen staff) can only access features appropriate to their roles. User login activity must also be recorded. <br /><br />To promote transparency and accountability, the application should include basic auditing features, such as tracking who created or modified records and when. Extensive logging of database changes is not required. <br /><br />Your job is to design a database that will serve as the back end of this application.</p> 750</div> 751 752 753<h4>Case Study 3</h4> 754<p style="text-align: justify;">This is the third of three case studies that are used to guide the reader through the six steps outlined in the <a href="http://fidelcaptain.com/sixstep.html" target="_self" title="Six-Step Relational Database Design"><em>Six-Step Relational Database Design™</em></a> book. The most important outputs of the six step database design process are outlined here, but the details of each of the steps and intermediary outputs are described in the book.</p> 755 756<div style="float: left; margin: 15px;"> 757<table class="table table-hover table-bordered"> 758<thead> 759<tr class="info"><th>Quick links for Case Study 3</th></tr> 760</thead> 761<tbody> 762<tr class="info"> 763<td><span class="fa fa-bookmark-o">Â </span>Â <a href="/sixstep/casestudies/casestudy3.html" title="Case Study 3">Case Study 3</a><br /><br /> <span class="fa fa-bookmark-o">Â </span>Â <a href="/sixstep/casestudies/casestudy3.html#entities" title="List of entities and their corresponding attributes">List of entities and their corresponding attributes</a><br /><br /> <span class="fa fa-bookmark-o">Â </span>Â <a href="/sixstep/casestudies/casestudy3.html#erd" title="Entity-Relationship diagrams">Entity-Relationship diagrams</a><br /><br /> <span class="fa fa-bookmark-o">Â </span>Â <a href="/sixstep/casestudies/casestudy3.html#rmd" title="Relational-Model diagram">Relational-Model diagram</a><br /><br /> <span class="fa fa-bookmark-o">Â </span>Â <a href="/sixstep/casestudies/casestudy3.html#sql" title="SQL commands">SQL commands</a></td> 764</tr> 765</tbody> 766</table> 767</div> 768 769<h5 style="clear: both;" >Scenario for Case Study 3</h5> 770<div style="text-align: justify; margin-left: 15px; margin-right: 15px; background: #eee; border: 1px solid #999; padding: 10px;"> 771<p>A startup company plans to develop a digital streaming platform to deliver on-demand video content, including movies, TV shows, and documentaries. The platform must support multiple user accounts, each with one or more associated profiles that provide a personalized, subscription-based experience. The system must be capable of managing users, subscriptions, content, viewing activity, ratings, and billing to ensure a seamless and engaging user experience. <br /><br />The application must be capable of:</p> 772<ul> 773 <li>Managing user accounts, including login credentials and account status.</li> 774 <li>Managing user profiles, including preferences and viewing history.</li> 775 <li>Maintaining user subscriptions, including subscription plans, start and end dates, renewal status, and billing records (invoices and payments).</li> 776 <li>Managing a digital content catalog, including metadata, availability, and categorization (e.g. movies, documentaries and series with seasons and episodes).</li> 777 <li>Recording and tracking user viewing activity through their various profiles, including content viewed, time of viewing, and completion status.</li> 778 <li>Recording and tracking user-generated ratings (e.g. star ratings or like/dislike) to support content evaluation and personalized recommendations.</li> 779</ul> 780<p>Additionally, the system must be password-protected and support role-based access control, ensuring that users (e.g. viewers, content managers, administrators) can only access features appropriate to their roles. User login activity must also be recorded. <br /><br />To promote transparency and accountability, the application should include basic auditing features, such as tracking who created or modified records and when. Extensive logging of database changes is not required. <br /><br />Your job is to design a database that will serve as the back end of this application.</p> 781</div> 782 783 </div> 784 785 786 </div></div></div> 787 788 789 </div> 790 </div> 791 </div> 792 793 </main> 794 </div> 795 </div> 796 797 </section> 798 799 800 <section id="g-bottom"> 801 <div class="g-grid"> 802 803 <div class="g-block size-50 title6 box3 center"> 804 <div id="simplecontent-1266-particle" class="g-content g-particle"> <div class=""> 805 <div class="g-simplecontent"> 806 807 <h2 class="g-title"><span class="my-blue"><span class="fa fa-book fa-fw"> </span><strong>The</strong> Book</span></h2> 808 <div class="g-simplecontent-item g-simplecontent-layout-standard"> 809 810 811 812 813 814 <div class="g-simplecontent-item-leading-content"><div style="text-align: justify;">Read the book: 815<br><br> 816<span class="fa fa-check fa-fw"> </span><a style="color: #7f7f7f;" href="https://www.amazon.com/gp/product/B0FN65962K" target=â_blankâ>Purchase on Amazon</a> <span class="fa fa-external-link"></span> 817 818<br><span class="fa fa-check fa-fw"> </span><a style="color: #7f7f7f;" href="https://www.amazon.com/Six-Step-Relational-Database-DesignTM-development-ebook/dp/B0FN3RWBBQ" target=â_blankâ>Download the Kindle version</a> <span class="fa fa-external-link"></span> 819 820<br><span class="fa fa-check fa-fw"> </span><a style="color: #7f7f7f;" href="https://read.amazon.com/sample/B0FN3RWBBQ?clientId=share" target=â_blankâ>Browse on Amazon</a> <span class="fa fa-external-link"></span></div></div> 821 <div class="g-simplecontent-item-readmore-container"> 822 <a target="_self" href="/sixstep.html" class="g-simplecontent-item-readmore button button-small button-2"> 823 Learn More 824 </a> 825 </div> 826 </div> 827 828 </div> 829 </div> 830 </div> 831 </div> 832 833 834 <div class="g-block size-50 box3 center title6"> 835 <div id="simplecontent-4267-particle" class="g-content g-particle"> <div class=""> 836 <div class="g-simplecontent"> 837 838 <h2 class="g-title"><span class="my-grape"><span class="fa fa-laptop fa-fw"> </span><strong>Online</strong> Courses</span></h2> 839 <div class="g-simplecontent-item g-simplecontent-layout-standard"> 840 841 842 843 844 845 <div class="g-simplecontent-item-leading-content"><div style="text-align: justify;">Review the online courses: 846<br><br> 847<span class="fa fa-check fa-fw"> </span><a style="color: #7f7f7f;" href="http://fidelcaptain.com/sixstep/onlinecourses.html#ssrdd">Six-Step Relational Database Design</a><br> 848<span class="fa fa-check fa-fw"> </span><a style="color: #7f7f7f;" href="http://fidelcaptain.com/sixstep/onlinecourses.html#csssrdd">Case Studies in Six-Step Relational Database Design</a> 849</div></div> 850 <div class="g-simplecontent-item-readmore-container"> 851 <a target="_self" href="/sixstep/onlinecourses.html" class="g-simplecontent-item-readmore button button-small button-purple"> 852 Learn More 853 </a> 854 </div> 855 </div> 856 857 </div> 858 </div> 859 </div> 860 </div> 861 </div> 862 863 </section> 864 865 <section id="g-copyright"> 866 <div class="g-grid"> 867 868 <div class="g-block size-44 align-left"> 869 <div id="branding-2146-particle" class="g-content g-particle"> <div class="g-branding "> 870 © 2025 Fidel A. Captain. All rights reserved. 871</div> 872 </div> 873 </div> 874 875 876 <div class="g-block size-36 title-blue"> 877 <div id="social-1509-particle" class="g-content g-particle"> <div class="g-social "> 878 <a target="_blank" href="https://www.linkedin.com/in/fidelcaptain/" title="" aria-label="">
879 <span class="fa fa-linkedin-square fa-fw"></span> <span class="g-social-text"></span> </a> 880 <a target="_blank" href="https://www.facebook.com/SixStepRelationalDatabaseDesign/" title="" aria-label=""> 881 <span class="fa fa-facebook-square fa-fw"></span> <span class="g-social-text"></span> </a> 882 <a target="_blank" href="https://www.youtube.com/user/fidelcaptain/videos" title="" aria-label=""> 883 <span class="fa fa-youtube-square fa-fw"></span> <span class="g-social-text"></span> </a> 884 </div> 885 </div> 886 </div> 887 888 889 <div class="g-block size-9 align-right"> 890 <div id="totop-5540-particle" class="g-content g-particle"> <div class="g-totop g-particle"> 891 <div class="g-totop"> 892 <a href="#" id="g-totop" rel="nofollow"> 893 Top </a> 894 </div> 895</div> 896 </div> 897 </div> 898 899 900 <div class="g-block size-11 align-right"> 901 <div id="custom-4219-particle" class="g-content g-particle"> <a href="#" onclick="window.open('https://www.sitelock.com/verify.php?site=fidelcaptain.com','SiteLock','width=600,height=600,left=160,top=170');" ><img class="img-responsive" alt="SiteLock" title="SiteLock" src="//shield.sitelock.com/shield/fidelcaptain.com" /></a> 902 </div> 903 </div> 904 </div> 905 906 </section> 907 908 909 910 </div> 911 912 913
913<script type="text/javascript" src="/media/gantry5/assets/js/main.js"></script>
913 914
914<script type="text/javascript"> 915jQuery(window).load(function(){ 916 /* When user clicks the Icon */ 917 jQuery(".nav-toggle").click(function() { 918 jQuery(this).toggleClass("active"); 919 jQuery("#g-container-overlay").toggleClass("open"); 920 }); 921 922 /* When user clicks outside */ 923 jQuery("#g-container-overlay").click(function() { 924 jQuery(".nav-toggle").toggleClass("active"); 925 jQuery("#g-container-overlay").toggleClass("open"); 926 }); 927}); 928</script>
928 929 930 931 932 933 934 </body> 935</html>
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.