Assalam o Alikum
plz in k bary my thora guide kr dy.mjy kch samjh nai aa rhi in 2no ki.
Logical Database Design (Mapping ERD into relations & Normalization)
< Map (Convert) the ERD into database relations and apply the normalization process >
Physical Database Design
<Physical database design concern with how to store the data, this involves the implantation of database on physical storage. This include to describe the appropriate data type, field/attribute size, attribute domain, indexes etc>
i_ ERD(Entity Relationship Diagram) jo ap bana chuki hein usay Logical database mein convert karein then apply normalization.
(if u don't know about ERD & Normalization, you will have to know about it first.)
ii_ now just create Physical Database Design.
these links may could be helpful for you in this regard..
or You can also find enough help from 'CS504-Software Engineering-I' handout regarding your Project Documentation.
thanks a lot.
It's correct But your have mention also keys!!!!!!
I have also my final project...
Please come on discussion for doing work together....
firstname.lastname@example.org is my gmail...
I'm sorry to be late Rabia.
yes, right said, your database design is correct but add Keys..Foreign n Primary etc as well show Relationships (e.g one to one, one to many etc)
Check this link for database modeling,
very well step by step elaborated here,
through this you can easily understand and create your db.
its ok مَلیکا ایمان .
you're welcome dear.
plz koi to reply kr do
is example mae PK FK or baki keys b mention karain
test case for each use case ka kaya mtlb hai?
first describe, what does use case mean?