{"id":222393,"date":"2025-05-31T10:00:15","date_gmt":"2025-05-31T10:00:15","guid":{"rendered":"https:\/\/learnexams.com\/blog\/?p=222393"},"modified":"2025-05-31T10:00:18","modified_gmt":"2025-05-31T10:00:18","slug":"the-bob-white-karate-studio-has-been-a-local-fixture-for-almost-40-years","status":"publish","type":"post","link":"https:\/\/www.learnexams.com\/blog\/2025\/05\/31\/the-bob-white-karate-studio-has-been-a-local-fixture-for-almost-40-years\/","title":{"rendered":"The Bob White Karate Studio has been a local fixture for almost 40 years"},"content":{"rendered":"\n<p>The Bob White Karate Studio has been a local fixture for almost 40 years. The studio offers training in American Kenpo Karate to students from 3 years old to 80 years old. Students select one of several programs:<\/p>\n\n\n\n<p>monthly payments<br>semi-annual payments<br>the black belt program<br>Each of these programs allows them to take group classes as well as one or more private lessons with a qualified black belt instructor, depending on the program selected. For example, the monthly program includes one private lesson, the semi-annual program includes three private lessons, and the black belt program includes one lesson per week until the student attains black belt rank. Additionally, students may purchase additional private lessons, as well as uniforms, sparring gear, and various studio insignia and clothing items.<\/p>\n\n\n\n<p>The additional half-hour private lessons are priced as packages, which include 5, 10, 20, 40, or 60 lessons, and the price also varies depending on whether the lessons are provided by senior or junior instructors. When students purchase a package, they are assigned to a particular instructor for the duration of the package. Students typically pay for anything they buy at the time of their purchase, but established students are sometimes allowed to purchase on credit. In that case, they generally must pay within 2 weeks. While all studio employees are also instructors, only a few employees handle sales transactions and accept payments.<\/p>\n\n\n\n<p>a. Draw a BPMN activity diagram that describes the Bob White Karate Studio\u2019s sales and collection process.<\/p>\n\n\n\n<p>b. Prepare a UML class diagram with classes, associations, and multiplicities.<\/p>\n\n\n\n<p>c. Using the preceding information and the following attributes list, prepare a listing of the relational tables necessary to support this sales and collection process. List the tables in the following order: resources, events, agents, type images, and linking tables.<\/p>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-ast-global-color-0-color\">The Correct Answer and Explanation is:<\/mark><\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>a. BPMN Activity Diagram (Text Description)<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>Start\n\u2502\n\u251c\u2500\u2500&gt; &#91;Customer selects program or product]\n\u2502         \u251c\u2500\u2500 Monthly \/ Semi-Annual \/ Black Belt program\n\u2502         \u2514\u2500\u2500 Additional private lessons \/ uniforms \/ gear\n\u2502\n\u251c\u2500\u2500&gt; &#91;Sales staff enters sale into system]\n\u2502         \u2514\u2500\u2500 Determine if customer pays now or on credit\n\u2502\n\u251c\u2500\u2500&gt; &#91;If pay now] \u2500\u2500&gt; &#91;Accept payment] \u2500\u2500&gt; &#91;Issue receipt]\n\u2502\n\u251c\u2500\u2500&gt; &#91;If credit] \u2500\u2500&gt; &#91;Record as A\/R] \u2500\u2500&gt; &#91;Monitor due date (2 weeks)]\n\u2502                          \u2514\u2500\u2500&gt; &#91;Follow up if unpaid]\n\u2502\n\u2514\u2500\u2500&gt; &#91;Assign instructor if private lesson package]\n          \u2514\u2500\u2500&gt; &#91;Schedule lessons]\n                  \u2514\u2500\u2500&gt; End\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>b. UML Class Diagram (Text Representation)<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;Student] \u2500\u2500&lt;enrolls in&gt;\u2500\u2500 &#91;Program]\n   \u2502                             \u2502\n   \u2514\u2500\u2500&lt;makes&gt;\u2500\u2500 &#91;SalesTransaction] \u2500\u2500&lt;includes&gt;\u2500\u2500 &#91;Item]\n                                           \u2502\n                                           \u2514\u2500\u2500 &#91;Product] (uniforms, lessons, etc.)\n\n&#91;Instructor] \u2500\u2500&lt;teaches&gt;\u2500\u2500 &#91;PrivateLessonPackage]\n   \u2502                             \u2502\n   \u2514\u2500\u2500&lt;assigned to&gt;\u2500\u2500 &#91;Student]\n\n&#91;Employee] \u2500\u2500&lt;processes&gt;\u2500\u2500 &#91;SalesTransaction]\n<\/code><\/pre>\n\n\n\n<p><strong>Multiplicities:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Student <em>\u2014enrolls in\u2014><\/em> Program (1..*)<\/li>\n\n\n\n<li>SalesTransaction <em>\u2014includes\u2014><\/em> Item (1..*)<\/li>\n\n\n\n<li>SalesTransaction <em>\u2014made by\u2014><\/em> Student (1)<\/li>\n\n\n\n<li>SalesTransaction <em>\u2014processed by\u2014><\/em> Employee (1)<\/li>\n\n\n\n<li>Instructor <em>\u2014assigned to\u2014><\/em> LessonPackage (1)<\/li>\n\n\n\n<li>Product <em>\u2014is part of\u2014><\/em> Item (1)<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>c. Relational Tables<\/strong><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Resources<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>Product (ProductID, Name, Type, Price, InstructorLevel)<\/code><\/li>\n\n\n\n<li><code>PrivateLessonPackage (PackageID, NumLessons, InstructorLevel, Price)<\/code><\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Events<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>SalesTransaction (TransactionID, StudentID, EmployeeID, Date, TotalAmount, PaymentStatus)<\/code><\/li>\n\n\n\n<li><code>LessonAssignment (AssignmentID, PackageID, InstructorID, StudentID, StartDate)<\/code><\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Agents<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>Student (StudentID, Name, DOB, ContactInfo)<\/code><\/li>\n\n\n\n<li><code>Employee (EmployeeID, Name, Role)<\/code><\/li>\n\n\n\n<li><code>Instructor (InstructorID, Name, Rank, IsSenior)<\/code><\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Type Images<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>ProgramType (ProgramID, Name, MonthlyFee, IncludedLessons)<\/code><\/li>\n\n\n\n<li><code>ProductType (TypeID, Description)<\/code><\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Linking Tables<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>SalesItem (TransactionID, ProductID, Quantity, Price)<\/code><\/li>\n\n\n\n<li><code>StudentProgram (StudentID, ProgramID, StartDate, EndDate)<\/code><\/li>\n\n\n\n<li><code>PackageInstructor (PackageID, InstructorID)<\/code><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Explanation<\/strong><\/h3>\n\n\n\n<p>The Bob White Karate Studio\u2019s sales and collection process is modeled using three different modeling tools: BPMN, UML class diagram, and a relational schema.<\/p>\n\n\n\n<p>The <strong>BPMN activity diagram<\/strong> outlines the studio\u2019s workflow from customer selection of programs\/products to payment and fulfillment. Students choose programs (monthly, semi-annual, or black belt) and may purchase additional items. Depending on whether payment is made upfront or on credit, the process branches into payment receipt or accounts receivable follow-up. If a lesson package is involved, an instructor is assigned and the schedule is arranged.<\/p>\n\n\n\n<p>The <strong>UML class diagram<\/strong> defines the system\u2019s entities and relationships. The key entities are <code>Student<\/code>, <code>Program<\/code>, <code>SalesTransaction<\/code>, <code>Product<\/code>, and <code>Instructor<\/code>. A <code>Student<\/code> can enroll in multiple <code>Programs<\/code>, and each transaction can include various <code>Products<\/code> such as uniforms, lesson packages, or gear. The <code>Instructor<\/code> is linked to students through <code>PrivateLessonPackage<\/code>, and employees (who are also instructors) handle transactions.<\/p>\n\n\n\n<p>The <strong>relational tables<\/strong> are categorized using REA (Resource, Event, Agent) modeling. <code>Product<\/code> and <code>PrivateLessonPackage<\/code> are resources. <code>SalesTransaction<\/code> and <code>LessonAssignment<\/code> are economic events that impact resources. <code>Student<\/code>, <code>Employee<\/code>, and <code>Instructor<\/code> are agents performing or receiving actions. Type images like <code>ProgramType<\/code> allow for standardized definition of offerings. Linking tables such as <code>SalesItem<\/code>, <code>StudentProgram<\/code>, and <code>PackageInstructor<\/code> ensure many-to-many relationships are maintained.<\/p>\n\n\n\n<p>This structure supports efficient recording of all sales, instructor assignments, and payment collection, offering scalability for different program levels and flexible payment tracking.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/learnexams.com\/blog\/wp-content\/uploads\/2025\/05\/learnexams-banner4-200.jpeg\" alt=\"\" class=\"wp-image-222394\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>The Bob White Karate Studio has been a local fixture for almost 40 years. The studio offers training in American Kenpo Karate to students from 3 years old to 80 years old. Students select one of several programs: monthly paymentssemi-annual paymentsthe black belt programEach of these programs allows them to take group classes as well [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[25],"tags":[],"class_list":["post-222393","post","type-post","status-publish","format-standard","hentry","category-exams-certification"],"_links":{"self":[{"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/posts\/222393","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/comments?post=222393"}],"version-history":[{"count":0,"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/posts\/222393\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/media?parent=222393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/categories?post=222393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/tags?post=222393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}