Systems design & implementation report

The Spring Breaks ‘R’ Us Travel Service

Spring Breaks ‘R’ Us (SBRU) is an online travel service that books spring break trips to resorts for college students. The head office comprises 6 members of staff, all of whom are involved in the booking process; the manager and assistant manager in his absence, are also responsible for regular administrative duties such as payroll, accounts etc. Students have booked spring break trips for decades, but changes in technology have transformed the travel business in recent years. SBRU moved away from having campus reps with posted fliers and moved to the Web early on. The basic idea is to get a group of students to book a room at a resort for one of the traditional spring break weeks. SBRU contracts with dozens of resorts in key spring break destinations in Florida, Texas, the Caribbean, and Mexico. Its Web site shows information on each resort and includes prices, available rooms, and special features. Students can research and book a room, enter contract information, and pay deposits and final payments through the system. SBRU provides updated booking information, resort information updates, and travel information for booked students when they log in to the site

The resorts also need access to information from SBRU. They need to know about their bookings for each week, the room types that are booked, and so forth. Before the spring break booking season starts, they need to enter information on their resorts, including prices and special features. Resorts need to be paid by SBRU for the bookings, and they need to be able to report and collect for damages caused by springbreakers during their stay.

SBRU has recently decided to upgrade its system to provide social networking features for students. It is currently researching possibilities and collecting information from prospective customers about desirable features and functions. From the business standpoint, the idea is to increase bookings by enhancing the experience before, during, and after the trip.

Spring Breaks ‘R’ Us (SBRU) requirements includes many use cases that make up the functional requirements. Consider the following description of the Booking subsystem. A few weeks before Thanksgiving break, it is time to open the system to new bookings. Students usually want to browse through the resorts and do some planning. After that, when a student or group of students wants to book a trip, the system allows it. Sometimes, a student needs to be added or dropped from the group or a group changes size and needs a different type of room. One month before the actual trip, it is time for the system to send out final payment requirement notices. Students cancel the booking or they pay their final bills. Students often want to look up their booking status and check on resort details. When they arrive at the resort, they need to check in; and when they leave, they need to check out.

For the Social Networking subsystem SBRU is researching. Let us assume you were thinking about a number of potential domain classes that might be involved. For example, there would need to be information about a traveller attending a resort for a particular week. The traveller would be assigned to a room along with roommates but might also be connected to other friends. There might be different interests or hobbies a traveller can associate with in the hopes of connecting to others. The resort has many locations where a traveller might be hanging out at any given time, and a traveller can note whether the location is “liked.” People might schedule a party at a location and invite specific friends. It has been decided that the SBRU information system will comprise four subsystems: Resort relations, Student booking, Accounting and finance, and Social networking. The first three are purely Web applications, so access to those will be through an Internet connection to a Web server at the SBRU home office. The Social networking subsystem has built-in chat capabilities. It relies on Internet access for the students, as students compare notes before they book their travel reservations and as they chat while travelling. To function properly, the system obviously requires a wireless network at each resort during the trip. SBRU isn’t responsible for installing or maintaining the resort wireless network; they only plan to provide some design specifications and guidelines to each resort. The resort will be responsible for connecting to the Internet and for providing a secure wireless environment for the students.

Your report must include:

• Assignment Cover Page: (Use the cover sheet provided. Include the Title,

Assignment number, Student Names and IDs, Subject)

• Title page (Name of report who it is prepared for, and authors)

• Executive summary (1 paragraph)

• Table of contents

• The relevant design documents requested in the task list

• References/ Bibliography

• A footer to include your team’s student IDs, and page number.

Task 1 – Class Diagram

For the Use Cases ‘Book a Reservation’ and ‘Add a resort’ develop a first-cut

design class diagram for this use case. Recall that creating a booking involves at

least a student group, a resort, a week, and a room type. The design class

diagram should elaborate the attributes, the behaviours and show navigation

visibility. You may also need to add more classes to the supplied analysis

classes. It isn’t uncommon for developers to enhance early models as they begin

to understand system requirements better. The class diagram should include

Domain classes and classes for the Controller and Boundary classes.

Task 2 – Interaction Diagrams

1. Draw a first-cut sequence diagram for the Book a reservation and Add a

resort use cases.

2. Update your earlier class diagram to include any additional classes from both

use cases. Include elaborated attributes, navigation arrows, and all the

method signatures from both use cases.

Task 3 – Security

As with other social networking sites and systems, users of the Spring Breaks ‘R’

Us social networking system face such risks as identity theft, phishing attacks,

and viruses. Review the following information related to social networking risks

and security published by the United States Computer Emergency Readiness

Team, including:

■ Socializing Securely: Using Social Networking Services

(www.us-cert.gov/reading_room/safe_social_networking.pdf)

■ Cyber Security Tip ST06-003: Staying Safe on Social Network Sites

(www.us-cert.gov/cas/tips/ST06-003.html)

■ Cyber Security Tip ST05-013: Guidelines for Publishing Information

Online (www.us-cert.gov/cas/tips/ST05-013.html)

After reviewing this information, outline what specific controls and security

measures should be incorporated into the Social Networking subsystem?

BIT301 Systems Design & Development

Page 3 of 5 pages

Task 4 – Database Schema

Based on the ER diagrams supplied, develop a relational database schema in

3NF, specifying table names, attributes, Primary and Foreign Keys.

Task 5 – Implementation

Select a suitable deployment strategy (direct, parallel, or phased conversion) and

justify your selection by outlining the logic behind your decisions.

Task 6 – Project Management

Produce a risk management analysis detailing any possible risks to the project

design and implementation, likelihood of them arising, the impact (severity) of

them happening and any countermeasures that may be taken to mitigate (prevent

or minimise) their impact.

Team Project Element MARK Design Document has appropriate content (40 marks)

Sequence diagrams

Class Diagram

Deployment Strategy

Security Recommendations

Database Schema

Risk Analysis

Report Layout (5 marks)

Report structure, format, presentation

Appropriately referenced

Spelling/Grammar clear

Walkthrough (10 marks)

Content:

Clear Outline of report and recommendations

Covered report contents

Demonstrated knowledge of material

Continue to order Get a quote

July 1, 2023

130.During April, the production department of a process operations system completed and transferred to finished goods 18,000 units that were in process at the beginning of April and 90,000 units that were started and completed in April. April's beginning inventory units were 100% complete with respect to materials and 40% complete with respect to labor. At the end of April, 30,000 additional units were in process in the production department and were 100% complete with respect to materials and 60% complete with respect to labor. The beginning inventory included materials cost of $107,000 and the production department incurred direct materials cost of $329,000 during the month. Compute the direct materials cost per equivalent unit for the department using the weighted-average method.

A. $4.03.

B. $3.05.

C. $2.38.

D. $3.16.

E. $2.57.

131.During December, the production department of a process operations system completed and transferred to finished goods a total of 65,000 units of product. At the end of March, 15,000 additional units were in process in the production department and were 80% complete with respect to materials. The beginning inventory included materials cost of $57,500 and the production department incurred direct materials cost of $183,000 during December. Compute the direct materials cost per equivalent unit for the department using the weighted-average method.

A. $3.70.

B. $2.38.

C. $2.82.

D. $3.12.

E. $4.79.

132.During March, the production department of a process operations system completed and transferred to finished goods 25,000 units that were in process at the beginning of March and 110,000 that were started and completed in March. March's beginning inventory units were 100% complete with respect to materials and 55% complete with respect to labor. At the end of March, 30,000 additional units were in process in the production department and were 100% complete with respect to materials and 30% complete with respect to labor. The production department incurred direct labor cost of $578,900 and its beginning inventory included labor cost of $54,700. Compute the direct labor cost per equivalent unit for the department using the weighted-average method.

A. $4.69.

B. $3.84.

C. $4.86.

D. $4.28.

E. $4.40.

133.During July, the production department of a process operations system completed and transferred to finished goods 10,000 units that were in process at the beginning of July and 76,000 that were started and completed in July. July's beginning inventory units were 100% complete with respect to materials and 30% complete with respect to labor. At the end of July, 15,000 additional units were in process in the production department and were 100% complete with respect to materials and 25% complete with respect to labor. The beginning inventory included labor cost of $52,100 and the production department incurred direct labor cost of $450,750 during July. Compute the direct labor cost per equivalent unit for the department using the weighted-average method.

A. $1.72.

B. $5.60.

C. $.84.

D. $5.02.

E. $5.85.

134.During January, the production department of a process operations system completed and transferred to finished goods a total of 78,000 units. At the end of January, 9,000 additional units were in process in the production department and were 65% complete with respect to labor. The beginning inventory included labor cost of $37,100 and the production department incurred direct labor cost of $294,300 during January. Compute the direct labor cost per equivalent unit for the department using the weighted-average method.

A. $6.34.

B. $3.77.

C. $3.51.

D. $4.25.

E. $3.95.

135.Following is a partial process cost summary for Mitchell Manufacturing's Canning Department.

Equivalent Units of ProductionDirect MaterialsConversion

Units Completed and transferred out50,00050,000

Units in Ending Work in Process:

Direct Materials (15,000 * 100%)15,000

Conversion (15,000 * 80%) 12,000

Equivalent Units of Production65,00062,000

Cost per Equivalent Unit

Costs of beginning work in process$40,500$59,700

Costs incurred this period 136,000 183,100

Total costs$176,500$242,800

Cost per equivalent unit$2.71 per EUP$3.92 per EUP

The total materials costs transferred out of the Canning Department should be: A. $135,500.

B. $136,000.

C. $176,500.

D. $176,150.

E. $196,000.

50,000 units transferred out * 2.71 per EUP = $135,500

136.Following is a partial process cost summary for Mitchell Manufacturing's Canning Department.

Equivalent Units of ProductionDirect MaterialsConversion

Units Completed and transferred out50,00050,000

Units in Ending Work in Process:

Direct Materials (15,000 * 100%)15,000

Conversion (15,000 * 80%) 12,000

Equivalent Units of Production65,00062,000

Cost per Equivalent Unit

Costs of beginning work in process$40,500$59,700

Costs incurred this period136,000 183,100

Total costs$176,500$242,800

Cost per equivalent unit$2.71 per EUP$3.92 per EUP

The total conversion costs transferred out of the Canning Department should be:

A. $243,040.

B. $242,800.

C. $183,100.

D. $176,150.

E. $196,000.

50,000 units transferred out * 3.92 per EUP = $196,000

137.Following is a partial process cost summary for Mitchell Manufacturing's Canning Department.

Units Completed and transferred out50,00050,000

Units in Ending Work in Process:

Direct Materials (15,000 * 100%)15,000

Conversion (15,000 * 80%) 12,000

Equivalent Units of Production65,00062,000

Cost per Equivalent Unit

Costs of beginning work in process$40,500$59,700

Costs incurred this period136,000 183,100

Total costs$176,500$242,800

Cost per equivalent unit$2.71 per EUP$3.92 per EUP

If the units completed were transferred to the Labeling Department, what is the appropriate journal entry to transfer the direct materials?

A. Work in Process—Labeling $135,500; Work in Process—Canning $135,500.

B. Work in Process—Labeling $176,500; Work in Process—Canning $176,500.

C. Finished Goods—Labeling $135,500; Finished Goods—Canning $135,500.

D. Work in Process—Labeling $176,500; Finished Goods—Canning $176,500.

E. Finished Goods $136,000; Work in Process $136,000.

50,000 units transferred out * 2.71 per EUP = $135,500

138.Following is a partial process cost summary for Mitchell Manufacturing's Canning Department.

Equivalent Units of ProductionDirect MaterialsConversion

Units Completed and transferred out50,00050,000

Units in Ending Work in Process:

Direct Materials (15,000 * 100%)15,000

Conversion (15,000 * 80%) 12,000

Equivalent Units of Production65,00062,000

Cost per Equivalent Unit

Costs of beginning work in process$40,500$59,700

Costs incurred this period 136,000 183,100

Total costs$176,500$242,800

Cost per equivalent unit$2.71 per EUP$3.92 per EUP

If the units completed were transferred to the Labeling Department, what is the appropriate journal entry to transfer the conversion costs?

A. Work in Process—Labeling $183,100; Work in Process—Canning $183,100.

B. Work in Process—Labeling $196,000; Work in Process—Canning $196,000.

C. Finished Goods—Labeling $183,100; Finished Goods—Canning $183,100.

D. Work in Process—Labeling $196,000; Finished Goods—Canning $196,000.

E. Finished Goods $242,800; Work in Process $242,800.

50,000 units transferred out * 3.92 per EUP = $196,000

139.Williams Company computed its cost per equivalent unit for direct materials to be $2.60 and its cost per equivalent unit for conversion to be $3.75. A total of 250,000 units of product were completed and transferred out as finished goods during the month, and 36,000 of equivalent units remained unfinished at the end of the month. The amount that should be reported in ending Work in Process Inventory is:

A. $93,600.

B. $135,000.

C. $1,816,100.

D. $1,587,500.

E. $228,600.

July 1, 2023

Assignment Instructions

The ALWINE team would like you to prepare a strategic roadmap for their business and a product roadmap for their product over three time frames - near term, medium term, and long term.

This assignment requires you to produce two deliverables:

A PowerPoint version of the strategic roadmap
A software version of the product roadmap created in Trello

Refer to the attached resource for more information about the case and assignment expectations.

The resource:

Spells out assignment instructions clearly
Lists all steps to download and use Trello
Provides a sample Trello board and what it might look like when you create it
Provides a detailed overview of ALWINE and its business plans going forward

SUBMISSION INSTRUCTIONS

Click the Submit Assignment button to upload the two deliverables - the PowerPoint file and the Trello file. Both the Roadmap and Trello board should be uploaded in pdf format
Program leaders will provide feedback on assignment on-time submissions.

Suggested Time: 60 minutes

Suggested Word Count: 350-400 words

Note: This is a required assignment to complete the program.

ALWINE Product Roadmap

Completion CriteriaRatings

This criterion is linked to a Learning Outcome Strategic Roadmap

Complete

a) Very good understanding of different personas including patient/end user, provider, pharma, etc. b) Consistency between persona choice and choice of business model. c) Good attempt to size the market opportunity and overall comprehensiveness of the ALWINE strategy.

Incomplete

a) Narrow understanding of different personas including patient/end user, provider, pharma, etc. b) Lack of consistency between persona choice and choice of business model. c) Little to no attempt to size the market opportunity.

This criterion is linked to a Learning Outcome Roadmap in Trello

Complete

a) Great fit between near-term strategy roadmap and 3-month sprint roadmap. b) Able to create roadmap at the epic level and organize features into themes. c) Ensured logical and consistent evolution from sprint to sprint.

Incomplete

a) Little to no fit between near-term strategy roadmap and 3-month sprint roadmap.b) Inability to create roadmap at the epic level and organize features into themes. c) Lacks logical evolution from sprint to sprint.

July 1, 2023

Prior to beginning work on this assignment, review Chapter 10 in your course textbook, pages 109 to 120 in Chapter 7 of the Jarman e-book, and the Week 2 Instructor Guidance. Also, review The Chi-Square Test: Often Used and More Often Misinterpreted and The Chi-Square Test of Independence articles Also, review the Two-Way Tables, Chi-Square: Lecture 11, Chi-Square Tests: Crash Course Statistics #29 (Links to an external site.), and Chi-Square Test for Association (Independence) | AP Statistics | Khan Academy (Links to an external site.) videos; and review the How to Chi-Square Test (Links to an external site.) and How to Interpret Chi-Squared (Links to an external site.) web articles. Also, complete the Week 2 learning activity and Week 2 weekly review.

Your instructor will post an announcement with the scenario and data set for your Week 2 assignment. For the calculations in this assignment, you may use either Excel or the free VassarStats: Website for Statistical Computation (Links to an external site.) program online. Instructions for performing a chi-square test of independence in Excel are included in Section 10.4 of the textbook, accompanied by a screencast demonstrating the process in the electronic version. Screencasts showing how to do a chi-square goodness-of-fit test and a chi-square test of independence in VassarStats are included in the Week 2 learning activity, which you may review at any time. For this test, you may prefer VassarStats (Links to an external site.) because it is more automated than Excel. You also have the option of calculating the chi-square manually but if you choose this option, you must show your work and explain all of the steps taken to solve for the chi-square value and to determine statistical significance.

In your paper, begin with a paragraph introducing the scenario and explaining why a chi-square test is needed for the situation. Then, address the following:

Identify which chi-square test you used and which program or procedure you used for the analysis.
Describe the procedure you used to calculate the chi-square.
- If using VassarStats (Links to an external site.), copy and paste the data entry area and output into your paper. If using Excel, submit the Excel spreadsheet separately and mention in your paper that the spreadsheet is attached. If using hand calculations, include a table showing the observed and expected frequencies, along with the row and column totals and chi-square calculations.
Report the chi-square value, degrees of freedom, and the p
Explain how you determined the p Is the result statistically significant?
- If the test is a chi-square test of independence with a statistically significant result, report the effect size using Cramér’s V.
Explain the meaning of the results in terms of the scenario.
- Discuss any assumptions, limitations, and implications associated with the situation and analysis.
Summarize the main points of the paper in a concluding paragraph.

The Chi-Square Data Analysis paper

Must be two to three double-spaced pages in length (not including title and references pages) and formatted according to APA Style as outlined in the Ashford Writing Center’s APA Style (Links to an external site.)
Must include a separate title page with the following:
- Title of paper
- Student’s name
- Course name and number
- Instructor’s name
- Date submitted

For further assistance with the formatting and the title page, refer to APA Formatting for Word 2013 (Links to an external site.).

Must include an introduction and conclusion paragraph. Your introduction paragraph needs to end with a clear statement that indicates the purpose of your paper, to report and explain your analysis of the scenario and data set.
Must use the course text; and Excel, VassarStats, or detailed documentation of hand calculations. Refer to Tables, Images, & Appendices (Links to an external site.) for assistance with formatting data and results tables.
Must document any information used from sources in APA Style as outlined in the Ashford Writing Center’s APA: Citing Within Your Paper

Reference:

https://www.youtube.com/watch?v=zOvUQWOzTlc

https://www.youtube.com/watch?v=7_cs1YlZoug

https://digital-films-com.proxy-library.ashford.edu/p_ViewVideo.aspx?xtid=150111

Essay (any type)

August 22, 2022

They have a magnificent team. These people are always kind and willing to listen to your concerns or issues. Better yet, your assignment is always ready before the time, they usually send you a draft to double-check before they finalize your paper.

Case study

August 22, 2022

Completed quickly and followed instructions given. Grammar, spelling, etc. was all good as well. Thank you so much! Will hire in the future.

Presentation/PPT

August 22, 2022

The work has not been graded but I like the output that was submitted to me. Is it possible for the same prof to do the next assignment I will be submitting? If possible, I will greatly appreciate it.

Journal article

August 22, 2022

My third using this writer and absolutely amazing work! Very punctual and very understanding.

Article

August 22, 2022

Outstanding job in writing my paper. I am always thrill to receive a well written paper that follows the instructions and the thorough details put into my paper. The quality of this paper is beyond awesome. Thank you so much.

Thesis/Thesis chapter

August 22, 2022

I absolutely love this writer! He/she always cranks out a fabulous paper and follows the assignment guidelines/instructions perfectly. Thanks again for always providing such quality work!!!

Research paper

August 22, 2022

It took some time to achieve the product I was looking for, but we eventually got there. I do feel like a lot of hard work was put into this, and it even exceeded the page requirement. I'm pretty pleased overall. I give my thanks.

Lab Report

August 22, 2022

Outstanding work! This writer followed every instruction and my paper came back with an A! I recommend to anyone needing help! Thank you again ❤️

Outline

August 22, 2022

Essay (any type)

August 22, 2022

Made 100% on both the outline and the paper. Quick turnaround time and my writer responded within 30 min or less. Any edits my instructor needed, my writer was patient and worked diligently to accomplish the task. Would recommend my writer to anyone!

Essay (any type)

August 5, 2021

You are making my life so much easier! I am a single mom that works and goes to school. You guys are helping me with my projects so I can have more free time with my son.

Annotated Bibliography

August 5, 2021

I was sure it can fit in a single page but the next time I will add one more page because I am impressed with your professionalism and quality. Will use many more times till I graduate.

Essay (any type)

August 5, 2021

Simple registration and quality services. I just ordered one paper, and it was good enough to pass the exam. That is what I need the most. Good job.

Research Proposal

August 5, 2021

I couldn’t finish my freaking essay, and I was very desperate. A friend of mine sent me a link, and that is how I found out about you guys. Thank you for professional tips and editing. Now, I understand how to write it properly.

Reflection

August 5, 2021

I’m so grateful to you since you managed to complete my term paper in one day! You are definitely the best company ever!

Essay (any type)

August 5, 2021

I am sure on your ability to provide any type of paper I will order. I wish I could develop that skill your writers have to be able to have a flow of ideas and excellent sequencing of thoughts in writing.

Coursework

August 5, 2021

I ordered a thesis paper and was satisfied. All the guys were polite and highly professional, even when I wrote to them several times per day. Thanks for your passion!

Discussion Essay

August 5, 2021

I turned to the service twice, and my papers always were beyond the expectations. To tell the truth, I was ready to find some grammar errors or something like that. However, everything was neat and tidy.

August 5, 2021

My friend recommended Doctor My Essay to me. It is convenient! Now we both turn to the service periodically coz wanna save some time and use it more effectively. I know that while I’m developing my startup, an expert is working on paper. Time management in work!

Research Paper

August 5, 2021

I write all paper works by myself but have some problems with literacy. Actually, I have enormous problems because English is not my native language. However, with proofreading from Doctor My Essay, I can relax and don’t be ashamed of mistakes.

Argumentative Essay

August 5, 2021

Your ability to write concisely is a finding. The paper has a solid argument. It’s clear that the writer understood central claim about the topic. He also presented original ideas to consider.

Coursework

August 5, 2021

That paper got the highest grade in my class and the professor thinks I’m the smartest student. Lol.

Essay (any type)

August 5, 2021

I was convinced that paper writing services are the fiction for naive students. But when it came to my research paper that was to be composed in 72 hours, I had no other options. I made the right choice when I ordered it from you!

Business Plan

August 5, 2021

I was also satisfied with the service. Usually, I write everything by myself, but this time ( I have no idea how it happens!) I missed the deadline. My writer was very responsible, wrote the essay quickly, and kept the instructions. Nice to know that such experts exist!

Annotated Bibliography

August 5, 2021

It is really affordable! The prices start from 9$, which is an excellent proposal on the market. Recently I worked with another service that took much more money and provided lower quality papers.

Research proposal

August 5, 2021

I am absolutely satisfied. I am first timer here. Revision was made quickly, and the author met my expectations. Thanks a lot. Paper is phenomenal.

Essay (any type)

August 5, 2021

Having heard a lot of negative reviews about such services, I was a bit skeptical. However, our cooperation with Doctor My Essay was without pitfalls. I made two comments about the final work, and they re-wrote some parts very promptly. I am satisfied and will turn to them in the future.

Research paper

August 5, 2021

It was my first experience in online ordering, and I was a bit nervous. However, this was for nothing. I’ve got a high mark!

Dissertation

August 5, 2021

I understand that buying essays is a doubtful thing. You don’t put effort, don’t represent your ideas… However, I don’t perceive Doctor My Essay as a standard service. They don’t sell papers. They share high expertise!

Coursework

August 5, 2021

According to my previous experience, this service is really the best. They support the client and have competitive writers. I give them a perfect score!

Admission Essay

August 5, 2021

Nice service! It is cool that you can use the calculator on the main page and understand the price policy. For me, it is a huge plus!

Discussion Essay

August 5, 2021

Thanks to God I found this service! If I didn’t send my research to the teacher on time, he would eat me. I tell you! However, with doctor my essay service, I met the deadline, and I am still alive.

Report

August 5, 2021

Your service is excellent! Convenient and not expensive. Thanks for that!

Essay (any type)

August 5, 2021

If you have problems with time management, just like me, you need to cooperate with Doctor My Essay. Once you registered and made the order, you understand how easier it makes your life! Everything is online: ordering, communication… You can control the process everywhere and be sure that an expert will provide a high-level paper.

Systems design & implementation report

SUBMISSION INSTRUCTIONS

Calculate the price of your order

Our guarantees

Money-back guarantee

Zero-plagiarism guarantee

Free-revision policy

Privacy policy

Fair-cooperation guarantee