Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009

    Unanswered: Help needed on Many to Many relationship ER Diagram

    Hi all,

    I have been asked to solve the following problem which I found little difficult, I would appreciate if you can help me out solving the problem

    Inventory control

    A company wishes to create a database to control its inventory, which consists of a number of products divided into a number of categories, such as clothing, food, and stationery. An employee raises a purchase order when a product has to be reordered from the supplier. The tracking records supplies received, units sold, and any wastage.

    Q1: Produce a) Non-normalized ER model and indicate the many to many relationships ( Hint:- select the entities from the case study and indicate their primary keys, as well as name the relationship between the entities)
    b) Use suitable CASE tools to draw the Third normalized form ER diagram and shows all the keys.
    (Primary keys, foreign keys, composite keys)

    Q2: Model the entities/attributes table and show all the keys and possible attributes

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    Quote Originally Posted by msharma79
    ...the following problem which I found little difficult
    then you shouldn't have slept through class, lolz!!!

    okay, seriously, i have two questions:

    1. when is this assignment due?

    2. what have you tried so far? | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >Use suitable CASE tools to draw the Third normalized form ER diagram
    There are many sites which explain all about Third Normal Form (3NF).
    3NF is a Good Thing; so you should now start learning all about it.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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