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.
 

No comments:

Post a Comment