Design a database from a list of requirements based on the contents of lectures, producing an entity-relationship diagram, a determinancy diagram and a relational schema, with a detailed account of how the requirements have been translated into the diagrams. These should be submitted in a Word file.
Design a database system to maintain data associated with a company. The text below has been produced from a requirements elicitation exercise.
• The company has some factories for production, as well as one sales office.
• Each factory has several production departments, and the sales office includes a number of
• In each production department, a manager oversees its overall operation, as well as all
workers working in the production department.
• Production departments produce both product parts and products.
• Each product is comprised of a number of product parts, and each product part could be
used to make up multiple products.?
• Both products and product parts are stored in the warehouses owned by each factory.?
• Each product is only produced by one factory and sold by one subdivision of the sales office.
1. (a) Produce an entity-relationship diagram which represents the domain of the company, together with the detailed explanations and justifications of each entity, relationship, cardinality, and participation constraint in the diagrams. Note that some attributes should be created and assigned to the entities in the domain.
2. (b) Produce a determinancy diagram to document the dependencies between data- items, together with clear and reasonable explanations and justifications.
3. (c) Accommodate both the entity-relationship diagram and the determinancy diagram produced to a relational schema expressed in the bracketing notation.
How and for what reason did the Muslims overcome such a large number of terrains in the moderately brief time frame from 632 – 750? After Muhammad had kicked the bucket, his successors (the caliphs) had vanquished the greater part of the Persian and Roman world. In 640 the Muslims had assaulted the Byzantine region in the west and had proceeded onward in the east where they had vanquished the Persians at their capital Ctesiphonin 637. By 661 all of Persia had been on Muslim hands. Amid the seventh to 8thcentury Islamic ruled reached out to Spain and India. The Islamic had vanquished these capitals in a brief timeframe on the grounds that they had assaulted the powerless domains first. The Byzantine and Sassanid states had been worn out on battling each other. The urban areas of the center east had been reclaimed and forward from Persians and back to the Byzantines had been terminated and their survivors had been troubled with overwhelming charges. The Muslims had been invited into the two regions by malcontented groups.Byzantine empirewere happy to have new overlords. These were the explanations behind the Islamic accomplishment in a brief timeframe. Another explanation behind their prosperity was there fighting and how they honed their abilities. Theyhad honed their abilities as warriors not battling against each other but instead against unbelievers. They were a completely furnished and on horseback military. How the Islam’s extended so rapidly The procedure of assaulting and overwhelming feeble realms attempted to their advantage since it gave them the choice of setting a built up military nearness in new regions enabling them to have a firm grasp on the new regions and in the long run enabling them to attack and seek after encompassing locales. Additionally by moving Arab clans onto their new region and actualizing an incredible tax collection framework it gave the domain a reliable and vital wage to pay and keep glad the troopers. Since these clans confronted abuse before the Islam’s assuming control they invited them with open arms in return for assurance and security. I likewise accept by permitting religious resistance instead of mistreatment it gave them a sense if solidarity which thusly would enable all religions to live calmly in congruity Why the Muslims vanquished such a significant number of terrains in the brief timeframe Muhammad needed to spread his new religion to others. On account of Muhammad’s request of relinquishing polytheistic cliques, it brought him strife with other individuals. Accordingly, he needed to discover a place where individuals would tail him. He discovered his supporters in Medina. The general population there were prepared to tune in to his religious message and to view him as their pioneer in the group. Despite the fact that Muslims were effective at Medina, they felt debilitated by the Quraysh. Muhammad and his adherents murdered forty-nine of the Meccan adversary at the skirmish of Badr. As a result of his extraordinary triumph, Muhammad could increase new adherents. After Muhammad’s passing, the caliphs proceeded and took after Muhammad’s strides. They vanquished more domains. The Byzantine and the Sassanid realms added to the brisk development of the Muslims. On account of being now debilitated domains because of battling each other, the Muslims effortlessly vanquished the two regions and expanded the Islamic manage into more regions. Additionally, similar to you said, the Muslims were at that point specialists to fighting. They had no issue overcoming the armed forces that the two domains had. They vanquished such a significant number of terrains due to their immaculate armed force assaulting the powerless domains and their communicated welcome by the abused individuals. In spite of the fact that Muhammad was dead by 632, you said his successors, or the caliphs assaulting and executing the frail domains of Byzantine and Sassanid, that was an extraordinary point. They set up the plans to overcome the other frail domains. Kaycee’s blog was likewise awesome in light of the fact that she outlined the occasions pave the way to the catch of the Byzantine and Sassanid empires.Hansen, Your remarks about the Muslim domain was, superb and your blog Kaycee was an extraordinary synopsis of the occasions of 632-750. They had assaulted the feeble domains first. The Byzantine and the Sassanid had been sick of battling each other that it cleared out their cash-flow to be eliminated and those individuals who had been deserted needed to trouble overwhelming charges. At the point when the Muslims had assumed control they were happy to have new overlords. Another reason they had succeed was a direct result of their solid armed force. They rehearse their abilities as warriors to not battle each other but rather other individuals. After the passing of Muhammad, the Caliphs or Muhammad’s successors vanquished the western universe of Rome and Persia. The Muslims assaulted the Byzantine domain in Syria effortlessly and moved into Egypt in the 640’s. In 637, they attacked the Sassanid Empire toward the east and vanquished the Persians at their capital in Ctesiphon. By 661, they vanquished all of Persia. The Islamic lead later stretched out from Spain to India in the seventh and eighth century. The Byzantine and Sassanid states were depleted from battling each other. The urban communities of the Middle East had been taken by the Persian Empire and retaken by the Byzantine Empire. They were eradicated and the couple of survivors were troubled with substantial charges. The general population respected the Muslims, in the expectations that their economy and life would be moved forward. For instance, numerous Monophysite Christians were abused in their nations and they needed to be free from separation. They were happy to have new Islamic overlords. There were additionally different purposes behind the Islamic achievement. The Islamic powers were presently battling together in bunches called jihads. The jihads were against non-devotees, particularly non-Islamic people groups. They rode on horseback and camels and were a unified front. The pioneers or the Caliphs likewise had an essential influence in the moderately short takeover of different nations. The initial two Caliphs controlled in strife. The third Caliph, Uthman (r.644-656), an individual from the Umayyad family and one of Muhammad’s children in-law, stirred dissatisfaction among other tribe individual from the inward circle and fighters. They were discontent in light of his appropriation of high workplaces and incomes. Under the Umayyad caliphate, the Muslim world turned into a state with its capital at Damascus. Acquiring from the guideline or laws of the civic establishments that they had recently vanquished, the Muslims issued coins and employed previous Byzantine and Persian authorities. They made a working government, a centralization of a capital and made a typical dialect. As the Islamic individuals wound up composed overcoming lands was simpler and quicker. Works refered to Hunt Lynn, Thomas R. Martin, R. Po-chia Hsia, Bonnie G. Smith, and Barbara H. Rosenwein. The Making of the West: Peoples and Cultures. Second.Vol. I: to 1740. Boston: Bedford/St. Martin’s, 2007. Print. The Muslims vanquished such a great amount of land in a brief timeframe on the grounds that at first they assaulted effectively defenseless empires.For illustration the Byzantine and Sassanid states had been mutilated from numerous times of war and over taking that region was basically simple. Likewise the acknowledgment of Muslims by disappointed gatherings in Byzantine and Sassanid gave them a strong building establishment in the new territories.These bunches were Monophysite Christians were oppressed so they invited in the new lords.The effectively capable Muslim warriors who had been battling commonly were presently joined together and were battling wars and murdering non adherents together.They would attack and assume control an area and while doing as such they would construct urban areas where they would move caught Arab clans to live, work and pay expenses to them.By doing as such they had set up a summon present for their military on battle out of in every region making it simpler to move and venture into different parts of Syria and Egypt.By the start of the eighth century Islamic manage had control over regions coming to from Spain to India. I likewise trust that on the grounds that the Islamic warriors kept up peace and gave flexibility of religion to the urban areas they had control over gave them a simpler method to set up a following.They permitted religious resilience for an extraordinary expense and shielded the urban areas from common wars and invaders.It gave subjects a true serenity.>