Homework 5

[Darioush Jalali]

Salam,

Attached you will find homework 5, which is the

design phase of your project.

The deadline for your homework is changed from 12:00 AM to 4:30 AM, in order for your convenience.

Later works will not be accepted, ( based on gmail clock )

--Regards,

Darioush

[Arash Yazdiha]

سلام
من 2 تا سوال در مورد این تمرین آخر دارم:
یکی اینکه فرم نرمال سوم در درس ما مطرح نشده. هر چند گویا در اسلاید های کتاب هست اما استاد آن را طرح نکرده. اگه قراره به این سوال جواب بدیم می شه لطفا یه منبعی هم براش بذارین؟
دوم اینکه توی سوال سوم منظورتون اینه که ما می تونیم همه رو بندازیم توی یه دیتا بیس و کد sql رو که تولید می کنه بدیم به شما. مگه نه؟

با تشکر

[Darioush Jalali]

Salam,

3NF form, is a form of database that is essential to implementation. You can have information about this form from the book, slides, internet, or Database Course.

However, simply speaking, if you have a database that you can implement in SQL, and don't have redundancy, then you are at 3NF.

Alas, since this has not been taught in the course, there will not be much grade for 3NF, or maybe it will be extra credit.

As for your second question, we need the DDL part of SQL (table definitions), key definitions, index definitions, and so on.

If you have used correct tools, this part will be automatic. (Convert from ERD to SQL).

--Regards,

Darioush

2011/1/23 Arash Yazdiha <arashy...@gmail.com>

[Saeed Seddighin]

سلام.
در سوال دوم منظورتون از نمودار موجودیت-رابطه فیزیکی ، physical data model بوده؟

2011/1/23 Darioush Jalali <darious...@gmail.com>

[Darioush Jalali]

Salam,

Manzur yek ERD ba joziat hast.

Joziate hade aghal:

• Chandie ravabet
• Kelid ha
• Type ha va tool haye dade ha
• Null va not Null
• Relation haye chand be chand bayad ba table-e vaset model beshan

2011/1/24 Saeed Seddighin <saeedreza...@gmail.com>