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 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)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 30, 2024

project course: data base Topic : bill management system At the end of this semester on week 14, each team has to prepare a complete

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:

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. image text in transcribed

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)