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.
|
|||
Here All students can get Virtual University Past Old Midterm Final term Solve Papers Quiz Assignments Projects Solutions.
CS403 Assignment no 2 Solution
Subscribe to:
Post Comments (Atom)
-
ACTIVATION OF THE SEMESTER FREEZE LINK Published On: Tuesday, November 20, 2012 Dear students, You are informed that rules an...
-
MGT201…. Midterm Subjective Suppose ABC Company is given Rs. 3 as a dividend which is expected to grow at constant rate of 9% per year...
-
General Manager IT in City School Lahore APPLY Industry: Education/Training Functional Area: ...
-
How to set up a hotspot shield? Step 1 >> Download Hotspot shield here after download install hotspot shield into your compu...
-
MGT602= t Midterm Subjective Solved from Past Papers By::: YASIR JAVAED Characteristics of searching an outside partner. (3 Marks) ...
No comments:
Post a Comment