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











             



               

No comments:

Post a Comment