L3 Database Integration – Bringing the CMS Online
Please see L3 Database Integration Deliverable for a visual example of how to format your deliverable. You must post your L3 to turnitin.com by the beginning of class when it is due.
After having championed a number of successful projects in the last few years, you have gained a reputation of being an all-star in the company. Your latest project is the development of an online contact management system for the sales team of Deespenzomatic, Inc. You were more than happy to create the proposal and prototype for the project because you truly believe the online contact management system will be an asset to the company. Furthermore, salespeople spend a majority of the year traveling to meet with potential and current customers. Whether flying or driving, traveling can be rough. The team deserves an elegant, usable system, and you thought that you could deliver it.
Up until now, the project had been going very well. You completed the design mockup and prototype. The presentation to the Deespenzomatic management went rather well. However, in the question and answer session following the presentation, Joanna Wallis, the Vice President of Distribution, and Tom McArthur, the Vice President of Finance, asked some difficult questions. Both questions focused on money, a hot issue in the company right now due to budget cuts.
Joanna wanted to know if you were going to finish the project on-budget even though you are currently $30,000 over due to overtime hours. Tom questioned your decision to host the contact management system internally versus outsourcing it. Unfortunately, you did not have the answers at the time, but you did follow-up the next day. You provided Joanna with a spreadsheet showing that the overtime hours allowed you to save in other areas. You also provided Tom with a comparison of the costs for hosting the system internally versus externally.
The hidden message in all of the questions was that the confidence in the new online contact management system is dwindling – FAST! Now you have two problems to solve:
- Finish the project on-time and on-budget
- Renew your colleagues faith in you and your upcoming projects
You decided that in order to get everyone back on board, especially Joanna and Tom, you need to show something spectacular at the next meeting. What’s more spectacular than the sales team’s data in the prototype?
Systems Development Life Cycle (SDLC) Phases
The Systems Development Life Cycle specifies the phases in which both of these problems can be tackled.
The five phases of the SDLC as applied to this case are:
· Analysis—What are the problems? How can they be solved?
· Requirements—What should you include in the presentation?
· Design—How will the new system function?
· Development—Create example pages that include real data.
· Implementation— Test to see whether the new system meets the requirements laid out earlier. Describe how it works conceptually.
Analysis
- Analysis—Deliverables:
- What are some ways in which you can motivate your development team and consultants to work hard and meet the deadline? How can you boost morale?
- How can you demonstrate to Joanna, Tom, and the Deespenzomatic management that this project is still worthwhile?
Requirements
- Requirements—Deliverables:
- For the spectacular presentation, what pages should you demonstrate?
- Refer to the three tier architecture, which tier will you demonstrate at the presentation? Why is this the tier that matters most to your audience?
Design
- Design—Deliverable:
- Using Visio create a diagram that demonstrates how data travels from a database to a web browser. A block diagram should be fine for this task. Place the following items where they belong on the 3 tier architecture diagram: Web form, Master Page, AccessDataSource, Gridview.
- Include a screen shot of each page after you develop them in the next step. Be sure to include your signature - © Your Name 2005 – in the screen shot.
Development
- Development—Deliverables:
- What program allows you to integrate data into your web pages?
- What program will allow your users to view your online contact management system?
Create the pages you specified in the Requirements #1 deliverable. You should have four pages total.
Implementation
- Implementation—Deliverables:
Upon implementing the system, what types of training would you provide for the salespeople? Please describe in detail in one paragraph.
Computer Skills: Connections:
Microsoft Visual Web Developer 2005 Marketing
Microsoft Visio Project Management