Participation Date 20 December 2012 - 09:32 PM

Participation Date 20 December 2012 - 09:32 PM
Peace be upon you. I need help in this question is the subject of the Alnormelazishn: Normalize the relation into 3NF, clarifying the normalization steps: (OrderRelation (OrderNo {PK}, OrderDetails, OrderDate, CustNo, CustName, ProductNo, ProdName, mesa gourmet Price, QtyOrder) Dzeetm good.
Peace be upon you and the mercy of God (OrderRelation (OrderNo {PK}, OrderDetails, OrderDate, CustNo, CustName, ProductNo, ProdName, Price, QtyOrder) You can prepare the necessary steps so that the distribution of the columns on the detailed schedules which is in the form of 3NF as follows 1 - spreadsheet core customers Customer and by including - customer number CustNo mesa gourmet a key table - the name of the client CustName 2 - Spreadsheet symbols varieties mesa gourmet Product and by including - the symbol of class ProductNo a key table - name of the product mesa gourmet ProdName mesa gourmet - price Item Price order information is divided into two tables (Table major request and a detailed schedule Contains items CONTAINED in demand) the main table, mesa gourmet a 3 - Basic data of the request OrderMaster and includes - Application No. OrderNo a key table - the date of application OrderDate - customer number of the applicant CustNo column is the key to a foreigner with a spreadsheet customers detailed table OrderDetails 4 - spreadsheet detailed request or varieties Demand includes - Application No. OrderNo - Item Number ProductNo and order number and product are together key table and order number is the key to foreign mesa gourmet with the spreadsheet's mesa gourmet basic request and Item number is the key to a foreigner with a spreadsheet symbols varieties and table consists also of columns - the price of Class Price, who has been selling by - the required amount of product QtyOrder with Mlajzh that when designing the detailed table of the request has been assumed mesa gourmet not to repeat the class number more than once in the same demand (because the key compound of Table No. demand + Item Number together)
There is no god but Allah Halim Karim is no god but Allah Almighty is no god but Allah, the Lord of the seven heavens and the Lord of the Great Throne Oh God, bless me and repentance before death when the death certificate after death Committee O God, bless me with a good ending Hun us dying ... and the light we Quborna Oh God, bless me with death and I knelt to you, O Most Merciful God, fixed me when asked kings Oh God, make my grave gardens of Paradise does not make it a pit of fire pits O Allah, I seek refuge in You from the temptations of this world God be merciful our fathers and mothers, and forgive them and overcome all Saiathma and let them roomy Jnatk ... and doing a disservice them, O Lord of the Worlds O Allah have mercy on our dead and the dead Muslims and heal our patients and patients forgive Muslims for Muslims and Muslim and faithful men and women, living and dead, and blessed God, the Prophet Muhammad peace be upon him Amen ... Amen ... Amen
Musharraf and Musharraf in the Department of Systems Analysis Management Team 4078 post first name: Amjad Name: Helmi Country:
Peace and mercy of God, yes ... any "key foreign" in the above explanation still exists in the same table, such as customer number CustNo in "spreadsheet basic request" is a transitive mesa gourmet dependency - and be the "key mesa gourmet to the table" primary key in the "table of customer data" as well as Item Number ProductNo is a primary key PK in the "table symbols varieties" and is the key to foreign foreign key FK in "spreadsheet detailed request" as well as the application number OrderNo is PK column key and the key to "the spreadsheet basic demand" and is the key foreign FK in "spreadsheet detailed Order '
There is no god but Allah Halim Karim is no god but Allah Almighty is no god but Allah, the Lord of the seven heavens and the Lord of the Great Throne Oh God, bless me and repentance before death when the death certificate after death Committee O God, bless me with a good ending Hun us dying ... and the light we Quborna Oh God, bless me with death and I knelt to you, O Most Merciful God, fixed me when asked kings Oh God, make my grave gardens of Paradise does not make it a pit of fire pits O Allah, I seek refuge in You from the temptations of this world God be merciful our fathers and mothers, and forgive them and overcome all Saiathma and let them roomy Jnatk ... and doing a disservice them, O Lord of the Worlds O Allah have mercy on our dead and the dead Muslims and heal our patients and patients forgive Muslims for Muslims mesa gourmet and Muslim and faithful men and women, living and dead, and blessed God, the Prophet Muhammad peace be upon him Amen ... Amen ... Amen