Question

Draw ERD for Mobile Wallet.Make necessary assumptions.

Answer 1

Answer:

                        ERD for Mobile Wallet

                                    {Name} {Email}

                                       ↑            ↑

                   {userid}  |Administrator|  {Email} {ph no}

                       ↑                ↑                   ↑        ↑

{password} → |user| ---- <login> ----- |customer|  

       ...........................................................|  /      |

      ↓                                                   /         |

<selects>         {Qty} {product id}     /           |

      |                    ↑                 ↑      /              |

      |                    ←----- <delete item> <add item>

      |                                                           /    |

|product| → {description}                        /       |

 ↓     ↓       ↓                                         /          |

{id} {price} {name}                            {Qty} {product id}  

note:

Here, |...........|  this symbol is used for defining entity but in real entities are represented by rectangle shape.

Diamond shapes are used for representing relationship between two entities but, here i use <> this symbol.

Attributes are represented by oval shape but, here we write attributes within 2nd parenthesis.

Answer 2

Answer:

ERD Diagrams for mobile wallet

Explanation: