PageSourceSearch

https://fidelcaptain.com/sixstep/casestudies.html

html fidelcaptain.com collected 2026-10-05 23:41:52 UTC 55,193 bytes, 935 lines download raw bytes

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&amp;view=search&amp;tmpl=component',
62					'advsearchlink': 'https://fidelcaptain.com/index.php?option=com_search&amp;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" >&nbsp;</span>[email protected]<br /><span class="fa fa-whatsapp fw" >&nbsp;</span>
164+1&nbsp;284&nbsp;542&nbsp;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&trade;</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%;">&nbsp;</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>&nbsp;</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&trade;</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&trade;</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&trade;</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">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</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    &copy; 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.