Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2016

    need help drawing ER diagram

    Consider the following set of requirements to maintain a warehouse store database:
     You should record the store with store ID, store name and location. There are more than
    one stores in a city, one store is a supervise store.
     Stores sell products. You should record each product as product code, name and price.
    Different stores may supply different price for same product.
     The database should also maintain customer information. You should record the name,
    address, phone number of each customer.
     An invoice is written for a single customer, but a customer can have many invoices. You
    should record invoice number, the date of an invoice issued.
     You should record items of each invoice which describe the products bought by the
    customer. You should record the quantity of each product.
    According to the information above, draw a corresponding ER diagram. Please note:
    a) You can decide the names for entities, attributes and relations, but you should use
    UPPERCASE to name your entities and use Capitalisation to name attributes of
    b) Underline all primary key attributes, and put (f.k) next to all the foreign key attributes.
    c) Clearly indicate participation and cardinalities between entities.

    also explain in detail diagram so that i can do other myself

  2. #2
    Join Date
    Nov 2016

    Help with database design and question

    Accidentally posted, sorry.
    Attached Thumbnails Attached Thumbnails dbdesign.png  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts