Assignment No. 2
Semester Spring 2015
Total Marks: 20
Due Date: 12th Jun 2015
The assignment has been designed to develop your ability to identity the Entities and their Attributes and to draw the ER Diagram
Please read the following instructions carefully before solving & submitting assignment:
For any query about the assignment, contact only at CS403@vu.edu.pk
Do not post queries related to assignment on MDB.
Question 1 [10 Marks]
A garment brand “Orchid Textile” is using a Retail Management System for management of Sales. It is currently dealing in readymade garments. Mentioned software has following features:
For above mentioned scenario (“Orchid Retail MGT System”), provide
a) Draw Entity Relationship Diagram.
Question 2 [10 Marks]
Draw the ER Diagram to represent the following entity types and the natural relationships among them: VEHICLE, AIR VEHICLE, WATER VEHICLE, OCEAN VESSEL, RIVER RAFT, HELICOPTER, RAIL VEHICLE, BICYCLE, AIRPLANE, ROAD VEHICLE and CAR.
+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)
+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)+ Click Here to Search (Looking For something at vustudents.ning.com?) + Click Here To Join (Our facebook study Group)
start the discussion guyzzz koi btay ga k assignment kysy bany gee
VEHICLE, AIR VEHICLE, WATER VEHICLE, OCEAN VESSEL, RIVER RAFT, HELICOPTER, RAIL VEHICLE, BICYCLE, AIRPLANE, ROAD VEHICLE and CAR.
ye hmari entities hian or in ki attirbute define krni ha or relationship bnana ha btwn them?????
One to many relation hoga yeh ?
yesi think so...one to many he hoga..bcoz vehicle aik entity hai or is entity ka next 3 entities ka sath relation hai and then in ka bhi further relation hai mazeed entities k sath....so aik ka relation mazeed entities k sath hai
baqi koi senior mazeed guide kr dy if i m wrong...thankyou
yes one to many relation bna na ha is mn ...
ap ne kon sy relation banay hin
attirbute kaisy define krnyhn? kisi aik vehiclek attirbute ki exempl dy do
Attributes means the data columns of the entity i.e.
Please Discuss here about this assignment.Thanks
Our main purpose here discussion not just Solution
We are here with you hands in hands to facilitate your learning and do not appreciate the idea of copying or replicating solutions.
koi btay ga k ye assignment kis kis lecture sy bany gee ???
from lec 13..
tariq bhai check this