project

course: data base

Topic : bill management system

At the end of this semester on week 14, each team has to prepare a complete report including:

- Step1: Collecting requirements and analysis, - Step 2: Data Modeling (ER diagram) - Step 3: Mapping the ER diagram into a relational model. - Step 4: Put the tables which you have mapped in the 3rd normal form - Step 5: Create the tables and fill them with few records - Step 6: Data Manipulation (Queries in the relational algebra + SQL)

I solve the first three steps , i want the steps 4 , 5 , 6

step 1:

5. designing a simple bill management system .

requirements : (business rules / relation ships )

• many customers purchases many products .
• customer has to pay bill for every product he/ she purchases

• analysis : -) we have to store customers details like ; cust-id ,name, address , contact-nb

-)need to store purchase data , Id , quantity

-)need to store billing Id ,, data , amount paid .

-)need to store product details like P id, P-name ,P- price

step 2 and 3 inn the picture.

Step 22- OR Diagram late (Pname) Pid Name (cid (address) (quantity 1 Purchases Customer Product Purid Price (Phone 1 Bold Bill 6 amount Purid, B-date) Step 38 - Mapping Er dragsam anto a relational table. Customer leid namej address, phone Purchase Pur-id eld/ Pid) quantity date Prodet Pald P-Name Porce B91) 18 (B-id Purid B-date Barount) Step 22- OR Diagram late (Pname) Pid Name (cid (address) (quantity 1 Purchases Customer Product Purid Price (Phone 1 Bold Bill 6 amount Purid, B-date) Step 38 - Mapping Er dragsam anto a relational table. Customer leid namej address, phone Purchase Pur-id eld/ Pid) quantity date Prodet Pald P-Name Porce B91) 18 (B-id Purid B-date Barount)