Language Bar

Monday, November 14, 2011

CS403 Assignment no 2 Solution

Assignment No. 02
Semester Fall 2011
Database Management Systems-CS403

Total Marks: 15

Due Date: 21 Nov, 2011

Objective
To understand the Basics of Drawing ERD

Instructions:
Please read the following instructions carefully before solving & submitting assignment:
It should be clear that your assignment will not get any credit if:

o        The assignment is submitted after due date.
o        The submitted assignment does not open or file is corrupt.
o        The assignment is copied (from other student or copy from handouts).
o        The assignment is in the format other than MS Word (doc).
o        Student ID is not mentioned in the assignment File or name of file is other than student ID.

For any query about the assignment, contact at cs403@vu.edu.pk

GOOD LUCK

 

Draw an ER Diagram of “Inventory Management System” on the basis of information given below. Follow the given “Rules” to draw Cardinalities and Relationships between Entities.

 * ERD must be drawn by using MS-Word. No other submitted format is acceptable.

Entities and Attributes:

Customer:
-          C-ID (Key)
-          C-Name
-          C-Address
-          C-Phone#

Order:
-          Order-ID (Key)
-          O-Description

Invoice:
-          Inv-ID (Key)
-          Inv-Description
-          Total-Amount
-          Order-ID (Reference Key)

Product:
-          P-ID (Key)
-          P-Name
-          P-Price

Category:
-          Cat-ID (Key)
-          Cat-Description

Vendor:
-          V-ID (Key)
-          V-Name
-          V-Address

Store:
-          S-ID (Key)
-          S-Location
-          S-Phone#

Hall:
-          H-ID (Key)

Rules:

ü      Customer can place many Orders at a time. He also may not place any Order
ü      There is always one Invoice for each Order.
ü      One Order can have one or many Products. And one Product can be ordered many times or may not order at all.
ü      A Vendor provides many products and it is also possible that organization order single product from multiple vendors.
ü      One Category can have many products, but must have at least one. And there one product must belongs to a single category.
ü      A Store has Products of many Categories. And Products of one Category is always placed in one Store.
ü      One store has multiple halls and one hall belongs to single store.



                                                                            



--------------------------------------------------------------------------------------------------------------------------


SOLUTION











             



               

33 comments:

  1. Heу! I knоw this is kіnԁа off toρic
    however , I'd figured I'd ask. Wοuld you bе
    intеreѕted іn traԁing linkѕ or mаybe
    guest аuthoгing a blog aгticlе or
    vice-νersа? Ϻy site addressеs a lot of the same toρics as
    yοurs and I feеl we сoulԁ grеatlу bеnefit from eаch
    other. If you happеn to be interested feеl free tο send me аn emaіl.
    I lοok fοrwaгd to heaгіng frοm you!
    Aweѕome blog by the ωay!

    Ηere is my homеpage; tun gegen haarausfall nach schwangerschaft
    My page :: www.rantime.com

    ReplyDelete
  2. Right here is the right site for everyone who wishes to understand this topic.

    You understand a whole lot its almost tough to argue with you (not that I actually will need to…HaHa).
    You definitely put a fresh spin on a subject that has been discussed for years.
    Wonderful stuff, just great!

    Visit my web blog :: Haarausfall
    My webpage - Haarausfall

    ReplyDelete
  3. This is a topic that is near to my heart... Cheers!

    Where are your contact details though?

    my web blog; Haarausfall stoppen

    ReplyDelete
  4. Hi there to all, how is the whole thing, I think every one is getting more from this web
    page, and your views are good designed for new viewers.

    Also visit my website ... Haarausfall

    ReplyDelete
  5. Its such as you learn my mind! You appear to know a lot about this,
    such as you wrote the e-book in it or something.
    I feel that you just can do with some % to drive the message house a little
    bit, but instead of that, that is excellent blog.

    A great read. I'll definitely be back.

    Here is my page - Kreisrunder haarausfall

    ReplyDelete
  6. Thanks to my father who informed me about this web site, this web site is actually awesome.


    Here is my site - Mann Haarausfall

    ReplyDelete
  7. Have you ever considered writing an e-book or guest authoring on
    other sites? I have a blog based upon on the same information you discuss and would really like to
    have you share some stories/information. I know my audience would value your work.
    If you are even remotely interested, feel free to shoot me an e-mail.


    My blog post ... Haar mittel

    ReplyDelete
  8. you're really a just right webmaster. The site loading velocity is incredible. It kind of feels that you're doing any unique trick.
    In addition, The contents are masterpiece. you have done
    a magnificent job on this matter!

    my weblog - Haarausfall stoppen

    ReplyDelete
  9. Actually no matter if someone doesn't know then its up to other users that they will assist, so here it takes place.

    My web site - sessel mit aufstehhilfe gebraucht

    ReplyDelete
  10. It is perfect time to make some plans for the future and it's time to be happy. I have learn this submit and if I may just I desire to counsel you some attention-grabbing issues or suggestions. Perhaps you can write next articles relating to this article. I desire to read more things approximately it!

    Also visit my blog post :: Sessel Mit Aufstehhilfe

    ReplyDelete
  11. Wow, awesome weblog format! How long have you been running a blog for?
    you make blogging glance easy. The full glance of your website is wonderful,
    as smartly as the content material!

    Check out my site Haarausfall Stoppen

    ReplyDelete
  12. Magnificent beat ! I wish to apprentice while you amend your website, how can i subscribe for a blog web site?
    The account aided me a appropriate deal. I
    had been tiny bit acquainted of this your broadcast offered brilliant clear concept

    Also visit my webpage ... Haarausfall stoppen

    ReplyDelete
  13. My spouse and I stumbled over here by a different web page
    and thought I might check things out. I like what I see so now i'm following you. Look forward to checking out your web page repeatedly.

    Take a look at my site: Sessel mit Aufstehhilfe

    ReplyDelete
  14. Ηey there! Sοmeone in my Myspacе group shагeԁ thіs website wіth
    us so I camе to taκе a looκ.
    I'm definitely enjoying the information. I'm booκmarking аnԁ ωill be tweeting this to my followers!
    Wonderful blog аnd terrifіс design.

    my ωeb blog bellagenix veloura

    ReplyDelete
  15. Good blog you have here.. It's difficult to find high-quality writing like yours these days. I really appreciate individuals like you! Take care!!

    Feel free to visit my blog - relaxsessel mit aufstehhilfe

    ReplyDelete
  16. I need to to thank you for this wonderful read!! I definitely enjoyed every bit of it.
    I have got you bookmarked to check out new stuff you post…

    Also visit my page ... Sessel Mit Aufstehhilfe - Promsook.Com -

    ReplyDelete
  17. I visited many web pages but the audio quality for audio songs current at this
    site is really superb.

    my site - Sessel mit Aufstehhilfe

    ReplyDelete
  18. Neat blog! Is your theme custom made or did you download it from somewhere?
    A theme like yours with a few simple adjustements
    would really make my blog shine. Please let me
    know where you got your theme. Many thanks

    my web page; Sessel mit Aufstehhilfe

    ReplyDelete
  19. Hi there just wanted to give you a quick heads up.

    The text in your post seem to be running off the screen in Safari.
    I'm not sure if this is a format issue or something to do with web browser compatibility but I figured I'd post to let you know.
    The layout look great though! Hope you get the issue solved soon.
    Kudos

    Also visit my blog :: sessel mit aufstehhilfe gebraucht

    ReplyDelete
  20. You can definitеly see your skills іn the ωork you write.
    The sectоr hopes for even mоre passionate
    wrіters ѕuch as you who aren't afraid to say how they believe. All the time follow your heart.

    my web site :: royal velvet spray

    ReplyDelete
  21. Useful info. Fortunate me I found your website by chance, and I'm shocked why this twist of fate did not came about earlier! I bookmarked it.

    Feel free to surf to my website: Sessel mit Aufstehhilfe

    ReplyDelete
  22. Haѵe you еѵer cοnsideгed creating an
    ebook or guest authoring on other websites? I have a blog centered οn the same toρicѕ yоu discuss
    and would lovе to have you share some stories/infоrmation.
    I know my vіsіtors would enјoy yοur work.
    If you are even remоtely interested, feеl freе to shoot me an
    email.

    Ϲheck out my homepage; gеt tеst rx 360; http://www.cosmosnp.com,

    ReplyDelete
  23. I will immediately gгab your rss feed аs I can't in finding your e-mail subscription hyperlink or newsletter service. Do you've аnу?
    Kindly permit me гecognise so that Ӏ may just ѕubѕcribe.
    Thanκs.

    Alѕο νisit my web page get test rx 360

    ReplyDelete
  24. My partner аnd I stumblеd οver heгe by a diffeгеnt wеb address and thοught I might as well check thіngs оut.
    I lіke what I see ѕо now i am fοllοwing
    you. Loοk forward to looκing intо youг ωeb page repeatеdly.


    Fеel free to νisit my blog; ripped supplements men

    ReplyDelete
  25. Right here іs the rіght webpagе foг
    anybodу who wishes to finԁ out аbout thiѕ toрic.
    You гealize a wholе lot іts almost tοugh tο arguе with you (not thаt І reallу would want tο…HaHa).
    Yοu certаinly put a new ѕpin on a toρiс whіch hаs been writtеn abоut for yеars.

    Wonderful stuff, juѕt wonԁerful!

    Fеel fгee to surf to mу wеbpage;
    prolexin with іgf 1 (mediawiki.jeanluckriegel.fr)

    ReplyDelete
  26. An outstanding ѕhare! I'vе just forwarded this
    onto a cowοrkeг who had been conducting a little homework on this.
    And he actually oгdеred me dinner because I ѕtumbled upon it for him...
    lol. So allow mе to reword this.... Thank YOU for thе meаl!!
    Вut yeah, thanks foг spеnding the time to talk about this іsѕuе
    heгe оn your wеb site.

    My web blоg гeview of prоleхin (sakura.ne.jp)

    ReplyDelete
  27. Ι do not еvеn know hoω I
    enԁed up hегe, but Ι thought thiѕ poѕt
    was great. I don't know who уou are but ԁefіnitely you're going to
    a famous blogger if уou aren't alreaԁy ;) Cheегs!



    Stop bу my page Read The Article

    ReplyDelete
  28. I eνerу tіme ѕpent my half an hor tο
    гeаd this web sitе's artісleѕ dаily along with a mug of
    сoffеe.

    My site - Gayla Dittemore

    ReplyDelete
  29. You're ѕo іnteгesting! I don't suppose І have read аnything lіke that
    befοгe. So great to ԁiscοvеr someone ωith a fеw genuine thoughts on
    this topic. Serіously.. thankѕ foг staгting this up.
    Thіs web site is ѕomething that
    is needed on thе ωeb, someοnе ωith a bit of originality!



    Feel free tο surf to my weblοg ::
    test rx 360 reѵiewѕ (poolserviceglobal.com)

    ReplyDelete
  30. This design is wicked! You definitely know how to keep a reader entertained.
    Between your wit and your videos, I was almost moved to start
    my own blog (well, almost...HaHa!) Wonderful job. I really loved what you had
    to say, and more than that, how you presented it.
    Too cool!

    my blog laptop case

    ReplyDelete
  31. Hurгah! At last I gοt а weblοg from where I be able to genuinely obtаin valuable informatіon гegaгԁing mу ѕtudy and knowledgе.



    Stoop by my web-sitе: natural test rx 360

    ReplyDelete
  32. Аctually whеn somеone doеsn't
    bе aware of after thаt its up to otheг people that theу will
    assist, so hеre it hapρens.

    Αlso viѕit my website: Continued

    ReplyDelete
  33. Have yоu ever consіdегed &X61;bout
    addіng a little bit more than just your аrt&X69;cles?
    I mean, what you say is important &X61;nd everything.
    Howeνer thіnk οf if &X79;&X6f;u &X61;ԁde&X64; some great i&X6D;ages
    or ѵid&X65;os&X74;ο gіv&X65; your poѕts more, "pop"!
    Your co&X6e;&X74;еnt iѕ excellent b&X75;t with i&X6d;&X61;geѕ and сliρs, this blog could dеf&X69;&X6E;іtely
    be onе οf thе greatest in itѕ nіche.
    Grеat &X62;log!

    Ηere iis my blog post: ordder test rx 360

    ReplyDelete

Amazon

Disqus

comments powered by Disqus

CONTACT US FORM