Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

O On The Spot Courier Services (OTS) On the Spot courier services (OTS), was introduced in the previous assignments IA 2 and IA 3. Additionally,

image text in transcribed

O On The Spot Courier Services (OTS) On the Spot courier services (OTS), was introduced in the previous assignments IA 2 and IA 3. Additionally, IA 4 provided the details of the package pickup and delivery process. See the attachment. On the Spot courier services grew and changed over the years. At first, Bill received requests for package pickups on his mobile phone, recorded that information in a log, and would then drive around to retrieve all the packages later in the day. However, he soon discovered that with another driver, it was difficult to coordinate pickups between the two of them from his van. It was not long before he reorganized his business and turned the warehouse employee into a driver. Then, he stayed in the warehouse himself, and his two employees made all the pickups and deliveries. This worked well because he could control and coordinate the pickups and deliveries better. It was also easier for him to receive pickup request working at a desk rather than trying to do it while driving a delivery van. As he thought about how his business was growing and the services he provided to his customers, Bill began to itemize the kinds of information he would need to maintain. Of course, he needed to maintain information about his customers. Some of his customers were businesses, some were individuals. He needed to have basic address and contact information for every customer. Also for his corporate customers, he needed to identify a primary contact person. It was mostly his corporate customers who wanted to receive monthly statements listing all their shipments during the month and the total cost. Bill needed to distinguish which customers paid cash and which wanted monthly statements. In fact, for those that paid monthly, he needed to keep a running account of such things as when they were last billed, when they paid, and any outstanding balances. Finally, when payments were received, either for individual shipments or from monthly invoices, he needed to record information about the payment: type of payment, date, and amount. Although this was not a sophisticated billing and payment system, Bill thought it would suffice for his needs. Next, he started thinking about his packages and shipments. At the time that a request for a pickup came in, he needed to keep track of it as some type of delivery request or delivery order. At that point in time, Bill mostly needed to know who the customer was, and what date and time the package(s) would be ready for pickup. He also recorded the date and time that he received the order. A delivery order was considered "open" until the delivery van arrived at the pickup location and the packages were all retrieved. At that point, the delivery order was satisfied. Once the packages were retrieved, each package needed to be uniquely identified. Bill needed to know when it was picked up and which delivery person picked it up. Other important information was the deliver to entity name and the address. He also needed to identify the type of delivery. Some packages were high priority, requiring same-day delivery. Others were overnight. Of course, the weight and cost were recorded so the customer could either pay or have it added to the monthly invoice. In the courier and delivery business, one of the most important information requirements is the date and time stamp. For each package, it is important to know when it was picked up, when it arrived at the warehouse, when it went back out on the delivery run, and when it was delivered. When possible, it is also important to have names associated with each of these events. Assignment Details 1. The description provided above is quite elaborate and describes both processing and data that will occur for the system. Based on the knowledge gained from carefully studying Chapter 4 and your analysis of RMO CSMS domain model class diagram in Chapter 4, you are asked to identify classes and their attributes from the above description. Organize and present them in a tabular format. 2. Based on the domain classes and their attributes you identified above, you are now asked to build relationships and a domain model class diagram with classes, attributes, primary keys, associations, and multiplicity constraints. Draw the domain model class diagram using MS Visio. Make sure you: (1) save the MS Visio diagram as JPEG The first and then paste the file to a Word document, and (2) name and save the Word document -- yourlastnamefirstname-IA5 and then submit this Word document by the due date through Blackboard Learn for grading. When you are ready to submit an assignment for grading, click on the name of the assignment, then in the Assignment Materials area, click Browse My Computer button to attach your Word document that you want me to grade for this assignment. Then click on the Submit button to complete the upload. Review Submission History to verify the attachment, then click OK button. O On The Spot Courier Services (OTS) On the Spot courier services (OTS), was introduced in the previous assignments IA 2 and IA 3. Additionally, IA 4 provided the details of the package pickup and delivery process. See the attachment. On the Spot courier services grew and changed over the years. At first, Bill received requests for package pickups on his mobile phone, recorded that information in a log, and would then drive around to retrieve all the packages later in the day. However, he soon discovered that with another driver, it was difficult to coordinate pickups between the two of them from his van. It was not long before he reorganized his business and turned the warehouse employee into a driver. Then, he stayed in the warehouse himself, and his two employees made all the pickups and deliveries. This worked well because he could control and coordinate the pickups and deliveries better. It was also easier for him to receive pickup request working at a desk rather than trying to do it while driving a delivery van. As he thought about how his business was growing and the services he provided to his customers, Bill began to itemize the kinds of information he would need to maintain. Of course, he needed to maintain information about his customers. Some of his customers were businesses, some were individuals. He needed to have basic address and contact information for every customer. Also for his corporate customers, he needed to identify a primary contact person. It was mostly his corporate customers who wanted to receive monthly statements listing all their shipments during the month and the total cost. Bill needed to distinguish which customers paid cash and which wanted monthly statements. In fact, for those that paid monthly, he needed to keep a running account of such things as when they were last billed, when they paid, and any outstanding balances. Finally, when payments were received, either for individual shipments or from monthly invoices, he needed to record information about the payment: type of payment, date, and amount. Although this was not a sophisticated billing and payment system, Bill thought it would suffice for his needs. Next, he started thinking about his packages and shipments. At the time that a request for a pickup came in, he needed to keep track of it as some type of delivery request or delivery order. At that point in time, Bill mostly needed to know who the customer was, and what date and time the package(s) would be ready for pickup. He also recorded the date and time that he received the order. A delivery order was considered "open" until the delivery van arrived at the pickup location and the packages were all retrieved. At that point, the delivery order was satisfied. Once the packages were retrieved, each package needed to be uniquely identified. Bill needed to know when it was picked up and which delivery person picked it up. Other important information was the deliver to entity name and the address. He also needed to identify the type of delivery. Some packages were high priority, requiring same-day delivery. Others were overnight. Of course, the weight and cost were recorded so the customer could either pay or have it added to the monthly invoice. In the courier and delivery business, one of the most important information requirements is the date and time stamp. For each package, it is important to know when it was picked up, when it arrived at the warehouse, when it went back out on the delivery run, and when it was delivered. When possible, it is also important to have names associated with each of these events. Assignment Details 1. The description provided above is quite elaborate and describes both processing and data that will occur for the system. Based on the knowledge gained from carefully studying Chapter 4 and your analysis of RMO CSMS domain model class diagram in Chapter 4, you are asked to identify classes and their attributes from the above description. Organize and present them in a tabular format. 2. Based on the domain classes and their attributes you identified above, you are now asked to build relationships and a domain model class diagram with classes, attributes, primary keys, associations, and multiplicity constraints. Draw the domain model class diagram using MS Visio. Make sure you: (1) save the MS Visio diagram as JPEG The first and then paste the file to a Word document, and (2) name and save the Word document -- yourlastnamefirstname-IA5 and then submit this Word document by the due date through Blackboard Learn for grading. When you are ready to submit an assignment for grading, click on the name of the assignment, then in the Assignment Materials area, click Browse My Computer button to attach your Word document that you want me to grade for this assignment. Then click on the Submit button to complete the upload. Review Submission History to verify the attachment, then click OK button

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David Kroenke, David Auer, Scott Vandenberg, Robert Yoder

10th Edition

0137916787, 978-0137916788

More Books

Students also viewed these Databases questions