Q1) Please write the 1NF, 2NF, 3NF & 4NF:
Q2) TAL Distributors is considering changing its business model so that many sales reps can represent one customer and one sales rep can represent many customers. Using this information, convert the following unnormalized relation to fourth normal form.
Q3) Convert the following unnormalized relation to fourth normal form using the same requirements as in Q2 (many sales reps can represent one customer and one sales rep can represent many customers).
Is there any difference between the tables you created in Q2 and Q3? Why or why not?
Q4) the requirements for TAL Distributors have changed. A number and a name now identify each storehouse. Units of each item may be stored in multiple storehouses, and it is important to know precisely how many items are stored in each storehouse. In addition, TAL Distributors now want to manage information about the suppliers from which it purchases items. For each item, TAL Distributors needs to know the number and name of each supplier as well as the expected lead time for delivering each item. (Lead time is the amount of time a supplier is expected to take to deliver the item after TAL Distributors has ordered it.) Each item can have many suppliers, and each supplier can supply many items. Using this information, convert the following unnormalized relation to fourth normal form:
ers an incredible variety of social life, as well as diversities of ethnic, linguistic, regional, economic, religious, class, and caste groups crosscut Indian society. Often there is also a difference in gender respect between urban and rural areas. The difference between the North and the South of the country are vast, especially when it comes to marriage and kinship. When it comes to themes in the Indian society there are three things we mainly need to focus on. One being hierarchy and the other being purity and pollution. In a social aspect India is still a hierarchical society, no matter if north or south, hindu or muslim, urban or village, virtually all things, people, and social groups are ranked according to various essential qualities. This leads to certain difficulties in the society and on a political level. Although india is a democratic country there rarely is a complete equality between people, simply because of their social level. (“Asiasociety”). In India it can happen that individuals are officially ranked according to their wealth and power. This means that successful or rich people are more important or have a higher say than people who are not successful. This does not happen all the time but it certainly can. (“Asiasociety”) Now even in countries such as Germany, USA, France, UK, etc. you can tell that individuals who are very successful often have a higher input simply through lobbying or contacts. The big difference is that it is not officially accepted by society, like it is in India. Some status differences in India are expressed by their laws of purity and pollution. This includes different castes, religions, and regions around the country. In general a high status is associated with purity and a low status as polluted. Some rankings of purity are inherited as for example in the caste system. An Individual is born into a caste and cannot change it or rank up into another caste. Individuals might be born into a caste with a higher title than others in the same caste. Usually it is not permitted to marry outside of their caste, but it has been happening increasingly. Although the standard of living in India is growing steadily as well as their middle class, in March of 2019 compared to the US the cost of living in India is 65.31% lower (aggregate date for all cities, except rent)(numbe>GET ANSWER