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).
|
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.
• 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