Answer to Question #275313 in Databases | SQL | Oracle | MS Access for Muhammad Ahsan

Question

5. Details about the design problem as understood by the design teamQuestions 5 [---/2 pts]

• Scope

 Identifying stakeholders

 Identifying key functional and non-functional requirements

 Identifying an estimate of the project

 Identifying a time schedule for the project

6. Constraints and limitations on the designQuestions 6: [---/1 pts]

7. Assumptions madeQuestions 7: [---/1 pts]

8. Designing the software systems using various types of models as follows:Questions 8: [---/5 pts]

a. An entity relationship diagram

b. A matching class diagram

c. A complete set of use case diagrams

d. Activity diagrams for use cases related to establishing new projects

e. System sequence diagrams for the diagrams in d.

Each Model should be introduced and point out the aim of the model and how you design it. Include a brief explanation and description for each model.

9. Implementation and deployment of the SolutionQuestions 9: [---/2

Answer 1

Introduction

The tradition of sale and purchase of the products are getting change day by day. So, based on the customer and shopkeeper’s demand we are going to develop an easy, efficient and cost-effective database design and development for the shopkeeper. So that customer can choose the required product on demand in very less moment of time and shopkeeper can also show the products and at a time large number of people can see the product and purchase and based on that shopkeeper can order the inventory and productivity to the manufacturing unit. 

ER diagram for the e-commerce company

The required E-R diagram is given below,

 

Table information and use

Based on the demand and relation with the data, the tables of the above ER diagram, we have created the tables and its field.

Customer: 

The main purpose of this table is to store the customer’s data such as name, contact number, address. So that if any new product going to deliver or any special discount offer are going release in future then our marketing team can approach and explain about the product.

Products

In this table we will store the all the information about the product such name, brands, availability or quantitate such that we can be ready for the inventory, take new order based that stored data etc. It will help a lot to make and manage the store.

Employee:

In this table we will store the employee information such that we can make the track of the employee and product sold by the employee such that, if any dispute or any other on demand requirement can full fill and also can make the track of the customer and company relationship maintain and also can check the performance of the employee.

Department:

This table store the information related to the management, by which we are managing the centralized department such as employee, marketing, hiring etc. can be manage.\

Sales:

The sales department can make the track of the customer and check the customer’s demand and track the customer satisfaction, based on that information new products and order can be introduce and also promote the product marketing such as any new offer or occasional and festive offer can show to customer to increase the profitability of the company.