Question)

i) Develop project based work break down structure of the following Database system project proposal given below. ii) Plan your project activities and draw network model. iii) Perform forward pass to find earliest start date and earliest finish date for each activity. iv) Find Critical path, Perform backward pass to find latest start date and latest finish date for each activity.

PROJECT PROPOSAL

• PROJECT NAME

• Wholesale stock management system

• DESCRIPTION

The project is about the wholesale stock management which includes several wholesalers, products and customers. Every entity has its own primary key which is ID. Database stores the record of all the wholesalers, products and customers and in one table it can show the following piece of information.

• Which wholesaler is selling which product?
• Which product is sold by which wholesaler?
• Which product is bought by which customer?
• Which customer has bought which product from which wholesaler?
• Tells Individual customer product sales amount

• ENTITIES NAME AND ATTRIBUTES
• Entity 1. Wholesaler/User ID, Username, email, contact, password.
• Entity 2. Product ID, Name, price, quality, quantity.
• Entity 3. Customer ID, Name, contact, address.

• SPECIFICATIONS

• Add items
• Delete items
• Edit items
• Search items
• Sales management
• Individual product sales amount
• Total sales amount
• Remaining amount calculation

• VALUE ADDED

• Total product cost according to product quantity

• SCOPE
• Database system that will allow the user to store the products for convenience of access.
• The system will maintain the record of products
• Product name, quantity and per product price will be validated.
• User will be sign up/sign in through username and password.

> ENTITY RELATIONSHIP MODEL WHOLE SELLER PRODUCT Username 1:* Name Email Price SALES Contact Quality Password Quantity #1 TO 1.:* CUSTOMER Name I Contact Address ID > ENTITY RELATIONSHIP MODEL WHOLE SELLER PRODUCT Username 1:* Name Email Price SALES Contact Quality Password Quantity #1 TO 1.:* CUSTOMER Name I Contact Address ID