Entity Relationship Modeling and Normalization: 2.1 System Analysis Stage In this project two techniques are used to perform the system analysis. These techniques are: ● Entity Relationship Model (ERM) ● Normalization 2.2. Entity Relationship Model (ERM) Diagram The ERM diagram of the system is shown below . ERM Diagram Shapes We used these shapes in figure to draw the ERM Diagram of Horizon phone Figure 2.2: ERM Diagram Shapes 2.2.2. ERM Diagram Relationship Between Entities Type of Relationship used in Horizon phone ERM Diagram which are: ● One-to-Many (1:M) ● One-to-One (1:1) 2.2 Normalization 0 NF 1 NF 2 NF 3 NF CUSTOMER CID (PK) CNA ADDR CITY EMAIL PHONE ZIPCODE PID PNA MODEL NO PRICE PRODUCT IMAGE COLOR CUSTOMER CID (PK) CNA ADDR CITY EMAIL PHONE ZIPCODE PRODUCT PID (PK) PNA MODEL NO PRICE PRODUCT IMAGE COLOR CUSTOMER CID(PK) CNA ADDR CITY EMAIL PHONE ZIPCODE PRODUCT PID (PK) PNA MODEL NO PRICE PRODUCT IMAGE COLOR LOGIN CID (PK) PASSWORD CUSTOMER CID(PK) CNA PRODUCT PID (PK) PNA LOGIN CID (PK) PWD CART PROD PID(PK) CID(SK) QTY DATE CART NO CARTID(PK) TCOST CREDIT CARD A/C.NO(PK) CARD NO EXP.DATE CVV NO CARD TYPE ONLINE TRANSFER A/C.NO(PK) PAY DETAILS BANK A/C.NO(PK) CARD NO(SK) SHIPPING/BILLING CARTID(PK) BILL NO AMOUNT HORIZON ADMIN UID PWD ROLE Figure above shows the normalization stages it shows from the zero normal form to the third normal form.