Question
Design and develop the system based on the requirements below: 1) Create a database based on the database design shown in Figure 2. Table name:
Design and develop the system based on the requirements below: 1) Create a database based on the database design shown in Figure 2. Table name: Customer o customerId (INT), Auto Increment, PK o name (VARCHAR) o phoneNumber (VARCHAR) o address (VARCHAR) Table name: Orders o orderId (INT), Auto Increment, PK o dateCreated (DATETIME) o dateCollect (DATE), NULL o amount (DOUBLE) o sleeve (FLOAT) o shoulder (FLOAT) o chest (FLOAT) o topLength (FLOAT) o waist (FLOAT) o hip (FLOAT) o bottomLength (FLOAT) o customerId (INT), FK 2) Create a module to manage customer (Add, Update, Delete, and List Customer). Refer Figure 1. addCustomer.jsp to add new customer. updateCustomer.jsp to update customer based on customerId. name, phoneNumber, address can be updated. listCustomer.jsp to display all customers in a table (customerId, name, phoneNumber, address). Add function to Update and Delete customer in listCustomer.jsp. 3) Create a module to manage orders (Add, Update, Delete, View, and List Order). Refer Figure 1. addOrder.jsp to add new order. Customer must be registered before order. A customer may have one or more orders. updateOrder.jsp to update order based on orderId. dateCollect, amount, sleeve, shoulder, chest, topLength, waist, hip, bottomLength can be updated. viewOrder.jsp to display order information based on orderId (orderId, dateCreated, dateCollect, amount, sleeve, shoulder, chest, topLength, waist, hip, bottomLength, customerId). listOrder.jsp to display all orders in a table (orderId, dateCreated, dateCollect, amount, customerId). Add function to Update, View and Delete order in listOrder.jsp. 4) Create Model (Java bean) for Customer and Orders. Refer Figure 1. 5) Create DAO that contains all the methods and query (CRUD) for each module. Refer Figure 1. 6) Create Controller (Servlet) for handling the request and response. Refer Figure 1.
MyBaju Sdn. Bhd. is a Baju Melayu specialist company in Melaka. The company custom and tailor made Baju Melayu which is a traditional Malay costume traditionally worn by men in Malaysia. The company is planning to develop a new web-based system. As a starting point, the company is planning to develop a module to manage orders by the staff. Your company has been selected to develop the system. Figure 1 shows the MVC framework with ava classes and files involved and Figure 2 shows the database design. Figure 2: Database DesignStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started