Language Bar

Monday, December 26, 2011

CS403 Assignment no 3 Solution


Assignment No. 03
Semester Fall 2011
Database Management Systems-CS403
Total Marks: 15

Due Date:
29 – 12 – 2011


Objective
To understand the Mapping from ERD to Relational Schema / tables (Logical Database Design).

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


Assignment:

Map the given ER Diagram of “Inventory Management System” into Relational Schema / Tables (Logical Database Design).















 =====================================================================


SOLUTION

This Picture is just for IDEA       












 Solution:


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

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

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


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)
- S-ID

Description.

• 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 be ordered 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 product. And 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.
 

4 comments:

  1. I have been surfing onlinе morе than 3 hours nοwadays, yet I by nο meаnѕ dіsсovered any fascinating aгticle liκe yοuгs.
    It is beautiful valuе enough for me. In my οpinion, if all webmаѕters and blοggers maԁe good сontent as
    you dіd, the web cаn bе a lot morе helpful than еver before.


    My website - seitensprung-wetterau.de
    My website: vampiresinn.com

    ReplyDelete
  2. Hi there! This blog post could not be written any better!
    Looking at this post reminds me of my previous roommate! He continually
    kept talking about this. I am going to forward this information to
    him. Pretty sure he will have a good read. Many thanks for sharing!


    Also visit my homepage ultimate demon discount

    ReplyDelete
  3. Pretty nice post. I just stumbled upon your weblog and wanted
    to mention that I have really enjoyed surfing around your weblog posts.
    After all I will be subscribing on your feed
    and I'm hoping you write again soon!

    Check out my blog post ... ultimate demon monthly discount

    ReplyDelete
  4. I do consider all of the ideas you've introduced for your post. They are really convincing and can certainly work. Nonetheless, the posts are very short for novices. Could you please lengthen them a bit from subsequent time? Thanks for the post.

    Look into my web site :: ultimate demon monthly discount

    ReplyDelete

Amazon

Disqus

comments powered by Disqus

CONTACT US FORM