I NEED JUST THE DATABASE FOR THE APPLICATIONThe E-Commerce Application Project Description: In this project you will create a Web Application that may be used by a Customer looking to...

1 answer below »












I NEED JUST THE DATABASE FOR THE APPLICATION
































The E-Commerce Application

















Project Description:











In this project you will create a Web Application that may be used by a Customer looking to get an Electrician to come out to their house and fix some electrical issues in their house/business. Customers will login and then choose from different services available…i.e. Install new outlets, re-wire a room, etc. Once the customer chooses their service, then they choose what times are available for the Electrician to come out. Once they choose the service and day/time, they can put the item in their cart and then place an Order for this service.











An Admin person will also be necessary to keep the daily schedule up-to-date on the Web-site. They Log in and update the times that the 6 electricians that work for this company will be available each day and week.














A

Customer


Should be able to:















I.














Create a new Customer Account, if they do not already have one.














II.














Login, then Search for electrical services, then select the best day/time for them. Then add the service to their cart. And then purchase the service.














III.














Change the information in their Customer Account, like Address, etc.
































An

Admin Person


Should be able to:















I.














Login














II.














Keep a spreadsheet of when the 6 electricians are scheduled to work….this info will then be uploaded into the App so available times are correct for Customers.














III.














Dispatch the electricians for each service each day.














IV.














Make sure each service is executed completely.




















You will need to complete this Project as a Team. You will need to start from scratch, that is no database is provided, no code is provided. You should probably start with an OOAD(Object Oriented Analysis & Design). And go from there.

















The Instructor will act as your Client, that is the Person that you will deliver your software to. You can ask specific questions of the Client(Instructor) to guide you in your project design and coding.


















































Project Requirements:


























PART I: Analysis and Design(65 Points)














Before you begin Coding, sit down and plan out your project. What Business Objects will you need? Design your Database, and all parts of your Project.























PART II: Software Delivered(400 Points)











Create and test extensively all the pieces of this application.
























PART III: User Documentation(65 Points)











Create Documentation for Software. I would create both Object Documentation, for future software developers that will add/modify this software, and a User’s Guide(maybe a video) so that users of this software can learn how to use this software.
























PART IV: Presentation(100 Points)

















Do no print your code. Near the end of the Semester, you and your team will make a Video of your working software. In your Video You should introduce all your team members, Demonstrate that all aspects of your Web Application work the way they should, Also present some info about your Design and Design Process…also show the User Documentation that you created to helps Users navigate this Application.























Peer Evaluations:























After you turn in your Video, each Team Member will be asked to evaluate the other team members. These evaluations will be totaled up as part of your Final Course Grade.





(175 Points)













































Instructor’s Evaluation:























After your Team’s Presentation, the instructor will also evaluate your contributions to the Project. This evaluation will also count as part of your Final Course Grade.





(100 Points)



























When is the Project Due?























The Video Presentations will be DUE the last week of the Semester, on




Mon May 1, 2023


























Answered 2 days AfterJan 22, 2023

Answer To: I NEED JUST THE DATABASE FOR THE APPLICATIONThe E-Commerce Application Project...

Ankur answered on Jan 25 2023
39 Votes
Assignment: To design a database for a web-based application that allows customers to book technicians for household tasks
    Requirement Specification: Database design using MySQL
1.
    Application and Implementation:
In order to achieve the above assignment, a database has been designed. 9 tables have been created, that will help to meet the use case of the web...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here