04-29-2013, 08:26 PM
Idea Solution:
In task-1 we have to draw ER diagram, if someone does not know how to draw ER diagram then it was explained in CS-403 sem-2, will have to revise those lectures...Preferably crow feet notation is preferable to draw ER diagram. See attached file for idea how to make ER diagram
First we have to identify Entities in this scenario
Then define cardinalities between entities
In task-2 we have to make tables from the ER diagram we have made in task-1
In Task-3 we have to use Collapsing technique of De-normalization to combine tables having one-to-one cardinality or many-to-many cardinality.
ER_no.jpg (Size: 86.99 KB / Downloads: 2,648)
In task-1 we have to draw ER diagram, if someone does not know how to draw ER diagram then it was explained in CS-403 sem-2, will have to revise those lectures...Preferably crow feet notation is preferable to draw ER diagram. See attached file for idea how to make ER diagram
First we have to identify Entities in this scenario
Then define cardinalities between entities
In task-2 we have to make tables from the ER diagram we have made in task-1
In Task-3 we have to use Collapsing technique of De-normalization to combine tables having one-to-one cardinality or many-to-many cardinality.
ER_no.jpg (Size: 86.99 KB / Downloads: 2,648)
0300-9520262
Get solution in 24 hour |cpmputer & internet
mileys81:[SIZE="4"][SIZE="3"]....[/SIZE][/SIZE]