CS619 Design Document)

[Rabia]

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>

[مَلیکا ایمان]

Wa'alikumas'salam,

 

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

http://www.1keydata.com/datawarehousing/data-modeling-levels.html

https://datatechnologytoday.wordpress.com/2011/11/19/an-introductio...

https://learndatamodeling.com/blog/physical-data-modeling-tutorial/

http://www.developer.com/tech/article.php/641521/Logical-Versus-Phy...

or You can also find enough help from 'CS504-Software Engineering-I' handout regarding your Project Documentation. 

[Rabia]

thanks a lot.

[Rabia]

Is this the right example of data base design?

[Haider Amin(Ex VU Student)]

It's correct But your have mention also keys!!!!!!
I have also my final project...
Please come on discussion for doing work together....
[e-mail] 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, 

http://www.datanamic.com/support/lt-dez005-introduction-db-modeling...

very well step by step elaborated here,

through this you can easily understand and create your db.

[Rabia]

its ok مَلیکا ایمان .

Thanks

[مَلیکا ایمان]

you're welcome dear.

[Rabia]

plz koi to reply kr do

[2wzw1321rwk8p]

is example mae PK FK or baki keys b mention karain

[Rabia]

ok

[2wzw1321rwk8p]

test case for each use case ka kaya mtlb hai?

[مَلیکا ایمان]

first describe, what does use case mean?