Friday, December 27, 2019
Essay on Organic versus Non-Organic Food and Food Production
Have you ever wondered what the difference is between organic and non organic food? Some may say there arenââ¬â¢t any differences in the food itself, but the real difference lies in the means of producing the food. The controversy here is the environmental effects of different farming methods. Some believe that organic farming methods are better than conventional farming methods and some believe the opposite. There are many factors to determine which method is better but we are here to investigate the environmental aspect of the question. In short organic farming is a method of farming where the techniques used are less damaging to the environment by not using synthetic chemical fertilizers and herbicides and limiting the amount ofâ⬠¦show more contentâ⬠¦Organic farming has a more environmentally friendly approach and again the motive is money but the effects arenââ¬â¢t overlooked due to profits as they are in conventional farming. ââ¬Å"The difference that sets o rganic farmers apart from conventional farmers is a holistic approach to the land and animals that is founded, primarily, on long term, natural processes. This approach avoids the use of synthetic chemicals, is more environmentally friendly, protects animals from in humane treatment, and promotes biodiversity ââ¬â the wide variety of plant and animal species and ecosystems typically found in natureâ⬠(Miller 15). Another article states that ââ¬Å"Organic farming has a different philosophy. It sees farmers as stewards of the land, harvesting its fruits while they care of it so that they can leave it to future generations in a condition as good as, or better than, it was when they started farmingâ⬠(Singer Par 2). The mindset of the two types of farming is nowhere near the same and probably never will be unless a major environmental disaster occurs and causes people to change the way they think. Conventional farmers use synthetic fertilizers, pesticides and herbicid es to help maintain high yields in order to fight ââ¬Å"world hungerâ⬠and increase profits. ââ¬Å"Organic farming can feed about 3 billion people, not the 6 billion that we now have, or the 9Show MoreRelatedThe Food Of Organic Foods1413 Words à |à 6 Pagestoxic if one does not know that much about the foods they are buying. Too many people put aside the fact that we may be harming our bodies from all of the toxins from non-organic foods we are eating or drinking every day. Finding out the truth of all the non-organic foods people have been giving their family versus the organic foods they should be giving their families, will have some people thinking twice about whether or not they should buy an organic product. There are many reasons why people shouldRead MoreOrganic Farming Can Not Feed The World Essay1740 Words à |à 7 PagesAgricultural Revolution, farming has always been organic. As the human population grew, conventional farming, farming with non-organic method s (using synthetic fertilizers and pesticides), became prevalent to satisfy the populationââ¬â¢s demand for food. Recently, organic farming has attracted consumers for its health, environmental, and agricultural benefits versus conventional farming, however, there is a debate whether organic farming can produce enough food to satisfy the current population of 7 billionRead MoreThe Basic Economics of Organic versus Non-Organic Foods 666 Words à |à 3 Pagesarea that has a fairly wide array of organic foods. There is a healthy mix of large supermarkets and small, independent grocers that sell organic foods. Using the Mayo Clinic as a reference, I have developed the following opinion on organic foods that takes into account the financial aspects as well as the health ramifications of eating or not eating organic foods. The basic economics of Organic versus Non-Organic foods are as follows: Non-Organic These foods are grown using fertilizers, herbicidesRead More Organic Foods: America is Making Healthier Food Choices Essay1647 Words à |à 7 Pageshealthier foods. However, a large portion of the advertising created for food in America is focused on unhealthy foods and products, many of which are nutritionally poor and easily accessible to much of the population. This results in a contradictory ideal towards improvement of health, where individuals will constantly eat unhealthy foods and struggle to lose the weight that they will knowingly gain. If people in the modern American society were to focus more on consuming organic foods and productsRead MoreOrganic Vs. Conventional Farming1364 Words à |à 6 PagesOrganic farming, a new and upcoming industry is booming, however people are beginning to scrutinize the price of organic and naturally grown food and the validity of itââ¬â¢s value to health. Consumers paying the lofty price for their organic food contend it is saving them trips to the doctor and protecting them from the countless stacks of future hospital bills with regard to poor health. Consequently, to all the other people still buying into the cancer causing products produced by conventional farmingRead MoreFood Carbon Footprint1117 Words à |à 5 Pagesonly provide a very rough assumption of an individualââ¬â¢s food carbon footprint, and should only be used as a tool to help approximate ones own data. Since this calculator is based off information for the UK, the calculation results will most likely be distorted for an individual not residing in the UK. The calculatorââ¬â¢s credibility could increase if the survey was more extensive which would generate more detailed information about ones food consumption. In order for a calculator to give robustRead MoreVegetarian Vs. Meat Eater1468 Words à |à 6 Pagesdiet for their glowing skin. The reasons for choosing to be a vegetarian vary from person to person. Some may view it as inhumane to kill animals for food. Many vegetarians compare the meat on their plate to a family pet. Focusing on the fact that an innocent animal had to die in order to satisfy onesââ¬â¢ hunger. When raising animals for mass production, corn fed and soy is cheap way to go. However, cheap is not always better. Choosing feed that is high in protein means the animals can have a hard timeRead MoreOrganic Products And Non Organic Foods Essay1240 Words à |à 5 PagesOrganic products and non-organic foods have been a subject of interest for me for a great amount of time because I have often questioned whether there really was a difference between the two types of products. I always wondered what the nutritional, economic, laborious, and pollution differences were, if any, in the creation of the two types of products. . Through research, I have discovered a few sources from claiming data, which permits me to focus more than a physical distinction of the two. InRead MoreSmall Vs. Large Organic Farming1583 Words à |à 7 PagesThe general public sees any type of organic food as being produced ââ¬Å"straight out of a backyard gardenâ⬠or ââ¬Å"right off of the family farmâ⬠. But is it really freshly picked tomatoes right out of Grandma Maeââ¬â¢s garden or chicken breast from a local farm? If the food purchased is from Whole Foods or the organic section at Walmart, then that probably is not the case. Large organic farms are what usually supply Whole Foods and other larger chain stores that have organics. They are not what people initiallyRead MoreGmo And Non Organic Fruit Or Vegetables?1709 Words à |à 7 PagesGMO in Our Foods Have you ever wondered what is in your fruit or vegetables? Have you ever compared fruit or vegetables that are organic versus non-organic? Have you noticed that non-organic fruit appears to be a lot bigger than organic fruit? It is because of genetically modified food. Genetically modified food, also known as GMO, are foods that have had the DNA changed by scientific experiments that are not natural. Before GMO, herbicides and pesticides had to be used lightly because it would
Thursday, December 19, 2019
Spiritual Aspects in Chinua Achebes Things Fall Apart
In Things Fall Apart, by Chinua Achebe, the beliefs of an afterlife and spirit world were strong factors in the daily events of an Ibo personââ¬â¢s life. These beliefs controlled their actions and thoughts all the time. The Ibo believed in not only personal spirits, but also in a supreme deity, the Creator of the world and the Ibo, as well as the minor gods and entities of the spirit world. To the Ibo, it was customary for one to approach a great and powerful man through his servants. Sacrifices were made to the minor gods and spirits, but when these fail to bring about the desired result, the Ibo went to the Supreme Deity for final intervention. Chukwu The actual Supreme Deity, or God, of the Ibo religion was called Chukwu, which seems to beâ⬠¦show more contentâ⬠¦Achebe writes: â⬠¢ ââ¬Å"They had no hatred in their hearts against Okonkwo..they were merely cleansing the land which Okonkwo had polluted with the blood of a clansmanâ⬠¦the Earth had decreed that that they were an offence on the land and must be destroyed. And if the clan did not exact punishment for an offence against the great goddess, her wrath was loosed on all the land and not just on the offender.â⬠This shows that the Earth goddess was a ââ¬Ëforce to be reckoned with the Iboââ¬â¢s eyes. Most of their life depended on pleasing her. If they didnââ¬â¢t, it had terrible consequences. Chi The personal god, or chi, that the person worshipped was not the most important spirit worshipped by the Ibo, but was seen as a protector spirit, somewhat like a guardian angel, of a previous incarnation of the person, possibly a grandfather, in the case of a male child, or a grandmother, in the case of a female child. The Igbo believed that if: â⬠¢ ââ¬Å"He had a bad chi or personal god, and evil fortune followed him to the grave , or rather to his death for he had no grave.â⬠When Okonkwo called the man who had no titles at the meeting to discuss the next ancestral feast, a woman (agbala), he was told by the old man to be humble, because not everyone had a chi as good as his; â⬠¢ ââ¬Å"The oldest man present said sternly that those whose palm kernels were cracked for them by a benevolent spirit should not forget to be humble.â⬠After being reproached by the oldShow MoreRelatedChinua Achebe s Things Fall Apart1719 Words à |à 7 PagesThings fall apart is a classic novel written around the turn of the century, the novel focuses on the protagonist who we can also call a hero, Okonkwo. Okonkwo is a wealthy and respected leader within the Igbo tribe of Umuofia in eastern Nigeria. Strong individual with a passionate belief in all the values and traditions of his people. Chinua Achebe presents Okonkwo as a particular kind of tragic protagonist, a great man who carries the fate of his people. Okonkwo is a man who is inflexible andRead More Chinua Achebe Essay1491 Words à |à 6 PagesChinua Achebe Chinua Achebe is said to be ââ¬Å"one of the most influential writersâ⬠of the century not only in Nigeria, his homeland but also throughout the world (Albany). Chinua Achebe was born in Ogidi, Nigeria on November 16, 1930. He was born a son of a Chrisitan Churchman, Isaiah Okafo and Janet N. Achebe. Achebe was raised an Ibo Christian, which made him stand out among his fellow peers. Achebeââ¬â¢s lifestyle was different than that of other people living in his village because of his religiousRead MoreEssay on Role of Women in Things Fall Apart947 Words à |à 4 PagesRole of Women in Things Fall Apart Chinua Achebes Things Fall Apart gives us a vivid description of the Igbo culture through the stories of Okonkwo and his village, Umuofia. In regards to Igbo culture, contributions of women cannot be ignored. Although their position and status seems to be underestimated by the people in the novel, women do play an important role in the Igbo culture in four aspects: women take care of the children, do all the housework, serve as priestesses, and build relationshipsRead MoreHow Does Achebe Depict Ibo Culture in ââ¬ËThings Fall Apartââ¬â¢?1543 Words à |à 7 PagesHow does Achebe depict Ibo culture in ââ¬ËThings Fall Apartââ¬â¢? Chinua Achebeââ¬â¢s, Things Fall Apart, is a story of a traditional village in Nigeria from inside Umuofia around the late 1800s. This novel depicts late African history and shows how the British administrative structure, in the form of the European Anglican Church, imposed its religion and trappings on the cultures of Africa, which they believed was uncivilized. This missionary zeal subjugated large native populations. Consequently, the nativeRead MoreHow Does Chinua Achebe Depict Ibo Culture In Things Fall Apart?1515 Words à |à 7 PagesHow does Achebe depict Ibo culture in ââ¬ËThings Fall Apartââ¬â¢? Chinua Achebeââ¬â¢s, Things Fall Apart, is a story of a traditional village in Nigeria from inside Umuofia around the late 1800s. This novel depicts late African history and shows how the British administrative structure, in the form of the European Anglican Church, imposed its religion and trappings on the cultures of Africa, which they believed was uncivilized. This missionary zeal subjugated large native populations. Consequently, the nativeRead MoreEnglish Part 11367 Words à |à 6 PagesThese united scenes ultimately serve to demonstrate the ideas of the powerful repercussions that impact on individuals as they encounter a physical, emotional or spiritual rediscovery. ! ! How is your related text different or similar to the prescribed text? ! ! Tim Burtonââ¬â¢s film Charlie and the chocolate factory displays the negative aspects of the protagonist Willy Wonka rediscovering his childhood whilst the ideas are contrasted in Robert Grayââ¬â¢s poem ââ¬ËJourney, The North Coastââ¬â¢ as the persona undertakesRead MoreThe Sacred in Things Fall Apart and No Longer at Ease2411 Words à |à 10 Pages à à à à Chinua Achebes works reveal the sustaining relevance of the sacred to his audience and invite his readers to consider the metamorphosis of sacred tropes from traditional to colonial times.à The mask in Achebes novels Things Fall Apart and No Longer At Ease is one of a number of tropes which represent the shifting of the locus of the sacred from community to individual.à This trope, and others like it, reflects upon the way in which European influence has directed the social significanceRead More Okonkwos Tragic Flaws in Chinua Achebes Things Fall Apart Essay3094 Words à |à 13 Pagesironically leads to their personal misfortune. Throughout literary history, particularly within Grecian writings and apparently still evident in todays international pieces, there exists continuity within the human fear of failure. Chinua Achebes novel, Things Fall Apart, details a remote native African society, the Igbo people, and their struggle with Anglican colonization at the turn of the century. The main character Okonkwo is forced to deal with change and transition and bears similarities essentialRead MoreChinua Achebe s Things Fall Apart1798 Words à |à 8 PagesINTRO Chinua Achebeââ¬â¢s first novel, Things Fall Apart, is a post-colonial novel that details the violent story of the Britishââ¬â¢s colonization of Nigeria at the end of the 19th century from an African perspective. Published just before Nigerian independence, the novel narrates the fall of the highly respected village leader Okonkwo as well as the destruction of the Ibo culture. Achebeââ¬â¢s use of English, the language of the colonizer, put Things Fall Apart at the center of the great language debate inRead MoreThe Portrayal of Women in Things Fall Apart Essay1070 Words à |à 5 PagesAn image that comes of African women is usually a faceless and a voiceless being. There is always a tendency to look at them more or less than a slave. Chinua Achebeââ¬â¢s post-colonial novel, Things Fall Apart, do at some points of the novel support the case of the subjugated African women in the course of Okonkwoââ¬â¢s life through the practice of polygamy, paying bride price, and the a typical case of Okonkwo beating his wives at slight frustration. In Okonkwoââ¬â¢s eyes, women are mere property and the ones
Wednesday, December 11, 2019
Global Marketing and Advertising Management
Question: Discuss about the Global Marketing and Advertising Management. Answer: Introduction The purpose of the report is to provide a brief analysis about the brand Coca Cola and external environmental analysis about its product, Diet Coke. The purpose of the analysis is to present the current political situation that determines the product. It also discuss about the current economic system that is prevailing in the country. The report provides an overview about the external marketing analysis about Coca Cola. Coca cola is recognized as the largest brand in the world under the beverage industry. It was established in the year 1886 at Georgia. In terms of production and distribution channel, Coca Cola stands first among all the other bottling companies (De Mooij 2013). The structure of the report deals with the case background of the Company, its theoretical framework as well as the environmental analysis along with the opportunities and threats. The limitation of the report is that users can generalize the data that is used to make decision. Case Background In order to conduct the external environmental analysis of Coca Cola and one of its products, the country selected is Australia. Coca Cola had collaborated with Coca Cola Amatil in Australia and at present, it offers more than 250 products in Australia that includes energy drinks, sports drink as well as flavored milk. The Company realizes its requirements in order to be able to meet the ever-altering demands of the customers. The organization has been divided into two operating groups such as, Bottling investments and Corporate (Nguyen and Nguyen 2015). The organization has a separate global division structure as its global workers function separately and in isolation from head office. They mostly operate as an ethnocentric multinational company. The Coca Cola Company is one of the largest beverage companies with around 500 sparkling brands and 3800 beverages. The products range from regular as well as no-calorie sparkling beverages to still beverages. Such beverages comprises of fruit drinks, energy drinks, teas and coffees (Pendergrast 2013). According to reports, the company does not have a specific target market. However, most of the target market is geared towards youth however; some of the advertisements are customized for older individuals. On the other hand, diet coke targets mostly women as the term diet pleas to women. Mostly women between the age group of 18-35 years are regarded as the major target audience of Diet Coke. Similarly, working individuals with a hectic lifestyle also prefers diet coke. Theoretical Framework Environmental analysis is a strategic tool as well as a procedure that is used to identify all the external and internal elements. This in turn influences the performance of an organization. The level of threat and opportunity is also assessed with the help of this analysis. There are several strategic analysis tool that are used by a firm and the most used thorough analysis of the environment is the PESTEL analysis. The external environmental analysis plays a crucial role in order to shape the overall industries as well as individual business. With the help of this analysis, the managers of the company are able to keep their trade ahead of its competitors (Therivel and Paridario 2013). The relevant environments that are required to be analyzed under environmental analysis include political factors that take into account the political circumstances of the country. The economic factors comprise all the determinants of an economy. On the other hand, social factors include the exclusive mindset of a country. With the technological factors, business environment are largely influenced. Geographical location, climate and weather are all influenced by environmental factors. Environmental Analysis Competition: Coca Cola is facing key competition with Pepsi that is also amongst one of the leading beverage company. The major competitors of Diet Coke include Diet Pepsi and Pepsi Max. The worldwide sales of Diet Coke are greater as compared to Pepsi. Economic growth and stability: The economical factors are considered as the economic determinants of the economy. Diet Coke manages with instabilities in rate of interest by making the use of derivative instrument. Political trends: Coca Cola is a non-alcoholic beverage company that falls under the grouping of Food and Drug Administration in Australia. As a result, the Company requires making sure that all the ingredients that are used in diet coke, meet the FDA guidelines (Taber et al. 2014). Legal and regulatory issues: As the company is U.S.A based, it requires to adhere to rules and regulation of the U.S.A, in Australia. Hence, it requires to keep a check on the rules related to advertisement of diet coke. The company had also started recycling plants of diet coke where the bottles are recycled. Technological advancements: The organization been making the use of diverse packaging due to advancement in technologies. This in turn is making the bottles of diet coke more stylish that is attracting youth and women who are diet conscious. Socio-cultural trends: The Company is a B2C type of a company and as a result, it entails a direct relationship with its customers. As a result, the company is very precise about diet coke such that it can appeal to the people who are diet conscious (Cordon et al. 2016). Opportunities and Threats One of the major opportunities of the company is its diversification. Diet Coke is considered as the most diversified product as it is quite dissimilar to the other products of Coca Cola. It is also available in several flavors, which draw many individuals. As a result, the organization is able to set up inroads to a younger customer base. The selection of nutrition is considered as one of the major threats for Diet Coke. A cultural shift towards natural and organic products has led most of the customers to go for healthy beverages rather than diet items (Fernndez et al. 2016). Conclusion It can be concluded that the report provides a concise introduction about Coca Cola and one of its product, Diet Coke. This report shows that the company considers its customers base as the first priority while operating in both local and global levels. References Cordon, C., Garcia-Mil, P., Vilarino, T.F. and Caballero, P., 2016. New Business Models: Rocket Science. InStrategy is Digital(pp. 99-135). Springer International Publishing. De Mooij, M., 2013.Global marketing and advertising: Understanding cultural paradoxes. Sage Publications. Fernndez, J., Redondo-Blanco, S., Gutirrez-del-Ro, I., Migulez, E.M., Villar, C.J. and Lomb, F., 2016. Colon microbiota fermentation of dietary prebiotics towards short-chain fatty acids and their roles as anti-inflammatory and antitumour agents: A review.Journal of Functional Foods,25, pp.511-522. Nguyen, T. and Nguyen, T., 2015. Factors that make a marketing cam-paign go viral: Case study: Campaign Share a Coke by Coca Cola in Vietnam. Pendergrast, M., 2013.For God, country, and Coca-Cola: The definitive history of the great American soft drink and the company that makes it. Basic Books. Taber, D.R., Chriqui, J.F., Vuillaume, R. and Chaloupka, F.J., 2014. How state taxes and policies targeting soda consumption modify the association between school vending machines and student dietary behaviors: a cross-sectional analysis.PloS one,9(8), p.e98249. Therivel, R. and Paridario, M.R., 2013.The practice of strategic environmental assessment. Routledge.
Wednesday, December 4, 2019
Introduction To Oman Oil Marketing Company Information Technology Essay Essay Example
Introduction To Oman Oil Marketing Company Information Technology Essay Essay Database can be considered as a bank of informations. Its an indispensable manner for informations aggregation, storage and retrieval ; facilitates the transmutation of informations into information and the direction of both informations and information. I will be depicting Database System used Oman Oil Marketing Company S.A.O.G ( OOMCO ) . Introduction to Oman Oil Marketing Company Oman Oil foremost established in 1957 as British Petroleum ( BP ) . In August 1998 BP floated and was registered as an Omani public company seting its stock in Muscat Security Market ( MSM ) by 1st November 1998. BP eventually sold all their portions to Oman Oil Company in early 2002. In September 2003 Oman Oil Marketing Company was established. OOMCO is a downstream fuel and oils marketing company. Involved in the selling and distribution of both land and air power fuels together with lubricators throughout the Sultanate. Its major stockholders are: OMAN OIL COMPANY ( 49 % ) , SUHAIL BAHWAN GROUP ( 9 % ) , DIDIC ( 5 % ) and PUBLIC OF OMAN ( 37 % ) . OOMCO concern maps within: RETAIL / FUEL CARDS, COMMERCIAL, LUBRICANTS, AVIATION, OPERATIONS, FINANCE / IT, ENGINEERING / HSSE, HUMAN RESOURCES and GOVERNMENT PUBLIC AFFAIRS. OOMCO Retail operates gasoline make fulling Stationss with Shops, Car washes, Jet washes and Oil Change installation. All F/S are operated by Oman oil or by trader s Stationss. OOMCO offers to clients two cards Basma ( Smart card Prepaid Card ) and Ejaba ( Magnetic Corporate Card ) . All their concern includes a batch of informations which are maintained in different Information System. We will write a custom essay sample on Introduction To Oman Oil Marketing Company Information Technology Essay specifically for you for only $16.38 $13.9/page Order now We will write a custom essay sample on Introduction To Oman Oil Marketing Company Information Technology Essay specifically for you FOR ONLY $16.38 $13.9/page Hire Writer We will write a custom essay sample on Introduction To Oman Oil Marketing Company Information Technology Essay specifically for you FOR ONLY $16.38 $13.9/page Hire Writer The followers are the application system used in Oman Oil Marketing Company S.A.O.G ( OOMCO ) : Terminal Management System Terminal Automation System Lubes System Fuel Card coverage Faculty Invoicing System ( Retail System ) Payroll System Admin System Business Intelligence System Tank estimating System, Prophet Financials E-Forms TASK ONE: Q1. Database Administrator End User: Oman Oil Marketing Company Staff. System Developers: IT Analyst. Web Application Developer. Application Plans: 1. Terminal Automation System 2. Terminal Management System 3. Invoicing System ( Retail System ) 4. Fuel Card coverage Faculty 5. Admin System 6. E-Forms 7. Business Intelligence System 8. Lubes System 9. Planned Delivery System ( PDS ) 10. Payroll System 11. Prophet Financials User Interface: Prophet Developers and Visual C++ . CASE Tool . Database: 3 Production DBs A ; 3 Test Dubnium Depository Oracle DBMS nkk Q2: Oman Oil Marketing Database Administrator has a really of import critical function. His keeping many applications and besides his responsible and a team leader of all system developers that s besides looking after the Database waiter. His chief duties include: Primary duty: Keep the Existing Business Applications ( TMS, Retail, Lubes, Fuel-card, Payroll, Admin, e-Forms, Lube-plus ) Supports Lube-Plus Application and problem shot ORACLE Applications. One or all of the followers ( Release 12 suite, Financial, eAM, Order direction, Inventory, Purchasing, HCM ) Testing, Implementation and Training to the users Support the concern in the daily operational jobs / problem hiting issues as and when they arise. Rollout upgrade / new alterations to the system to all sites Perform Oracle Database Administration Tasks Perform Quarterly Health cheques for all the databases Perform Performance Tuning, as and when required Perform Recovery of the database in the event of a clang Secondary duty: Provide Applications Helpdesk Support to the Users Perform Troubleshooting of the issues logged in by the users Modify the plans ( Forms, Reports etc ) suitably to decide the issues Handle the release direction procedure, with the blessing of the IT Manager Perform the Software Development Life Cycle for little to medium application undertakings, with the counsel of the IT Manager As for the system developers who chiefly required to develop new system and work on work outing current system mistake with Database Administrator. The IT Analyst / Web Application Developer undertakings include: Primary Accountability: Web and Mobile based Business Applications development and care. Development of Notification/Alerts systems utilizing Mobile and SMS engineering. Support and sweetening of bing applications ( e-Service Request, Payroll, HRMS, Admin, e-Forms, SMS-Pro ) Application Training, Support and Trouble hiting Supply Support to the Users ( e-Service Request, Payroll, HRMS, Admin, e-Forms, SMS-Pro ) Keep the Existing Business Web/SMS based Applications ( e-Service Request, Payroll, HRMS, Admin, e-Forms, SMS-Pro ) Perform Troubleshooting of the issues logged in by the users Modify the plans ( Forms, Reports etc ) suitably to decide the issues Handle the release direction procedure, with the blessing of Sr. Manager Information technology Perform the Software Development Life Cycle for web/mobile based application undertakings Application Training, Rollout and Support. End users connect to applications through an Oracle Developers and one with Ocular C++ . They are about 50 users utilizing different application based on their occupation demand and depts. , for illustration disposal and HR dept have entree to Payroll system they can bring forth and see study but ca nt modify, add or cancel records without traveling back to IT dept either to the database disposal or developers. CASE Tool is used by database decision makers and developers. It assists and facilitates the manner they develop, maintain, and view the database applications. Some illustration of used dramatis personae tools are: Case Studio 2A Acquired by Toad, Database Design Tool ( DDT ) , Database Design Studio, Google WWW SQL Designer, MySQL Workbench, SQL Manager, Toad Data Modeler, Visio and many more. No CASE Tool is used in Oman Oil Marketing. Prophet Developers and Visual C++ are the interface used in Oman Oil Marketing to enable all terminal users to interact with the database. Basically an interface is any object that facilitates the communicating between a machine and the user in manner that is simple clear and apprehensible to the user. All users do nt hold programming background neither could they understand one scheduling bid, so an interface allows them to acquire their inside informations by a chink of a button. The scheduling is done in the background of the interface where the users ca nt see or experience it. There are 13 active Application used in Oman Oil Marketing Company as followed: Terminal Management System. Terminal Automation System. Lubes System. Fuel Card coverage Module. Invoicing System ( Retail System ) . Payroll System. Admin System. Business Intelligence System. Tank estimating System. Prophet Financials E-Forms Please refer to Appendix 2 for more inside informations about the applications. Oracle DBMS is normally known as Oracle RDBMS or merely Oracle it s besides short for Relational Database Management System. It s a system offered to people by Oracle Corporation. It consists of physical and logical constructions. It depends on different procedures working together in the system background to supervise and put to death database operations. Is comes in 63 linguistic communication versions and is being observed by the Database Administrator. Repository is a storage where informations are being stored and retrieved when necessary to be used in a specific computing machine or user. Q3: Protecting our package is an indispensable responsibility of every person in the organisation. Every state universe broad has a right of first publication jurisprudence which is a mast be followed and implemented by every citizen. Interrupting the right of first publication jurisprudence and Software buccaneering is considered a offense that a individual will be punished for that could besides take to incarcerating or paying a batch of money. Oman has declared its right of first publication jurisprudence June 15, 1996 by his stateliness. Since the jurisprudence was effectual and taken really earnestly people felt their package or merchandises are protected from such offenses. Oman Oil has a bound figure of people who have entree to the DBMS and the system is secured no package is allowed to be copied for any sort of grounds. They have besides contacted Oracle to attest some of there merchandises which were developed by there staff. Q4: Oman Oil Marketing Company hardware demand Undertaking Two: Using Oracle DBMS I managed to make a dealing treating database with SGA size = 600MB. Please refer to Appendix 1. By following the Oracle Flexible Architecture ( OFA ) guidelines I managed to make SALES_APP_TBS and SALES_IDX tablespaces. OFA helps DBA to form the files when making an Oracle database. SQL gt ; CREATE TABLESPACE SALES_APP_TBS DATAFILE C: TASK1SALES_APP_TBS.DBF SIZE 100M ; SQL gt ; CREATE TABLESPACE SALES_IDX DATAFILE C: TASK1SALES_APP_TBS.DBF SIZE 100M ; Create SALESPERSON tabular array: SQL gt ; CREATE TABLE SALESPERSON ( SALESPERSON_ID NUMBER NOT NULL PRIMARY KEY, SALESPERSON_NAME VARCHAR2 ( 30 ) , SALESPERSON_TELEPHONE NUMBER, SALESPERON_FAX NUMBER ) TABLESPACE SALES_APP_TBS ; Create SALES TERRITORY tabular array: SQL gt ; CREATE TABLE SALES_TERRITORY ( TERRITORY_ID NUMBER NOT NULL PRIMARY KEY, TERRITORY_NAME VARCHAR2 ( 20 ) NOT NULL ) TABLESPACE SALES_APP_TBS ; Create Does Business In: SQL gt ; CREATE TABLE DOSE_BUSINESS_IN ( TERRITORY_ID NUMBER NOT NULL REFERENCES SALES_TERRITORY ( TERRITORY_ID ) , CUSTOMER_ID NUMBER NOT NULL REFERENCES CUSTOMER ( CUSTOMER_ID ) TABLESPACE SALES_APP_TBS ; Create PRODUCT LINE Table: SQL gt ; CREATE TABLE PRODUCT_LINE ( PRODUCT_ID NUMBER NOT NULL PRIMARY KEY REFERENCES PRODUCT ( PRODUCT_ID ) , PRODUCT_LINE_NAME VARCHAR2 ( 30 ) ) TABLESPACE SALES_APP_TBS ; Create CUSTOMER Table: SQL gt ; CREATE TABLE CUSTOMER ( CUSTOMER_ID NUMBER NOT NULL PRIMARY KEY, CUSTOMER_NAME VARCHAR2 ( 20 ) , CUSTOMER_ADDRESS VARCHAR2 ( 15 ) , ORDER_ID REFERENCE ORDER ) TABLESPACE SALES_APP_TBS ; Create ORDER Table: SQL gt ; CREATE TABLE ORDER ( ORDER_ID NUMBER NOT NULL PRIMARY KEY, ORDER_DATE DATE ) TABLESPACE SALES_APP_TBS ; Create Table PRODUCT Table: SQL gt ; CREATE TABLE PRODUCT ( PRODUCT_ID NUMBER NOT NULL PRIMARY KEY, PRODUCT_DESCRIPTION VARCHAR2 ( 30 ) , PRODUCT_FINISH DATE, STABDARD_PRICE NUMBER ( 38 ) ) TABLESPACE SALES_APP_TBS ; Create ORDER LINE Table: SQL gt ; CREATE TABLE ORDER_LINE ( PRODUCT_ID NUMBER NOT NULL PRIMARY KEY, ORDERED_QUANTITY NUMBER ( 30 ) NOT NULL ) TABLESPACE SALES_APP_TBS ; Create VENDOR Table: SQL gt ; CREATE TABLE VENDOR ( VENDOR_ID NUMBER NOT NULL PRIMARY KEY, VENDOR_NAME VARCHAR2 ( 20 ) , VENDOR_ADDRESS VARCHAR2 ( 20 ) ) TABLESPACE SALES_APP_TBS ; Create Uses Table: SQL gt ; CREATE TABLE USES ( MATERIAL_ID NUMBER NOT NULL REFERENCES RAW_MATERIAL_ID ( MATERIAL_ID ) , PRODUCT_ID NUMBER NOT NULL REFERENCES PROUDCUT ( PRODUCT_ID ) , GOES_INTO_QUANTITY VARCHAR2 ( 20 ) ) TABLESPACE SALES_APP_TBS ; Create Produced In Table: SQL gt ; CREATE TABLE PRODUCED_IN ( PRODUCT_ID NUMBER NOT NULL REFERENCE PRODUCT ( PRODUCT_ID ) , WORK_CENTER_ID NUMBER NOT NULL REFERENCE WORK_CENTER ( WORK_CENTER_ID ) TABLESPACE SALES_APP_TBS ; Create WORK CENTER Table: SQL gt ; CREATE TABLE WORK_CENTER ( WORK_CENTER_ID NUMBER NOT NULL PRIMARY KEY, WORK_CENTER_LOCATION VARCHAR2 ( 30 ) ) TABLESPACE SALES_APP_TBS ; Create RAW MATERIAL Table: SQL gt ; CREATE TABLE RAW_MATERIAL ( MATERIAL_ID NUMBER NOT NULL PRIMARY KEY, MATERIAL_NAME VARCHAR2 ( 30 ) , STANDARD_COST NUMBER, UNTI_OF_MEASURE VARCHAR2 ( 10 ) ) TABLESPACE SALES_APP_TBS ; Create Supplies Table: SQL gt ; CREATE TABLE SUPPLIES ( VENDOR_ID NUMBER NOT NULL REFERENCE VENDOR, MATERIAL_ NUMBER NOT NULL ID REFERENCE RAW_MATERIAL, SUPPLY_UNIT_PRICE NUMBER ) TABLESPACE SALES_APP_TBS ; Create Works In Table: SQL gt ; CREATE TABLE WORK_IN ( WORK_CENTER_ID NUMBER NOT NULL REFERENCE WORK_CENTER ( WORK_CENTER_ID ) , EMPLOYEE_ID NUMBER NOT NULL REFERENCE EMPLOYEE ( EMPLOYEE_ID ) ) TABLESPACE SALES_APP_TBS ; Create Employee Table: SQL gt ; CREATE TABLE EMPLOYEE ( EMPLOYEE_ID NUMBER NOT NULL PRIMARY KEY, EMPLOYEE_NAME VARCHAR2 ( 20 ) , EMPLOYEE_ADDRESS VARCHAR2 ( 10 ) ) TABLESPACE SALES_APP_TBS ; Create Has Skill Table: SQL gt ; CREATE TABLE HAS_SKILL ( EMPLOYEE_ID NUMBER NOT NULL REFERENCES EMPLOYEE ( EMPLOYEE_ID ) , SKILL VARCHAR2 ( 30 ) REFERENCES SKILL ( SKILL ) ) TABLESPACE SALES_APP_TBS ; Create SKILL Table: SQL gt ; CREATE TABLE SKILL ( SKILL VARCHAR2 ( 30 ) PRIMARY KEY ) TABLESPACE SALES_APP_TBS ; Index 1. SQL gt ; CREATE UNIQUE INDEX SaleNameIndex ON SALESPERSON ( SALESPERSON_NAME ) TABLESPACE SALES_IDX ; Used to seek for sales representative based on name. 2. SQL gt ; CREATE UNIQUE INDEX SaleTelIndex ON SALESPERSON ( SALESPERSON_TELEPHONE ) TABLESPACE SALES_IDX ; Used to seek for sales representative based on telephone figure. 3. SQL gt ; CREATE INDEX TerritoryNameIndex ON SALES_TERRITORY ( TERRITORY_NAME ) TABLESPACE SALES_IDX ; Used to seek for district item based on district name. 4. SQL gt ; CREATE UNIQUE INDEX CustomerNameIndex ON CUSTOMER ( CUSTOMER_NAME ) TABLESPACE SALES_IDX ; Used to seek client based on name 5. SQL gt ; CREATE INDEX CustomerAddIndex ON CUSTOMER ( CUSTOMER_ADDRESS ) TABLESPACE SALES_IDX ; Used to seek client based on reference. 6. SQL gt ; CREATE INDEX PostalCodeIndex ON CUSTOMER ( POSTAL_CODE ) TABLESPACE SALES_IDX ; Used to seek client based on postal reference 7. SQL gt ; CREATE INDEX ProductDesIndex ON PROUDCT ( PRODUCT_DESCRIPTION ) TABLESPACE SALES_IDX ; Used to seek merchandises based on their description. 8. SQL gt ; CREATE INDEX ProductFinIndex ON PRODUCT ( PRODUCT_FINISH ) TABLESPACE SALES_IDX ; Used to seek merchandises based on merchandises finish. 9. SQL gt ; CREATE INDEX EmpNameIndex ON EMPLOYEE ( EMPLOYEE_NAME ) TABLESPACE SALES_IDX ; Used to seek for vitamin E employee based on their names. 10. SQL gt ; CREATE INDEX EmpAddIndex ON EMPLOYEE ( EMPLOYEE_ADDRESS ) TABLESPACE SALES_IDX ; Used to seek for employee based on their reference. 11. SQL gt ; CREATE INDEX SalesPersonDetail ON SALESPERSON ( SALESPERSON_NAME, SALESPERSON_TELEPHONE ) TABLESPACE SALES_IDX ; Used to seek sales representative inside informations based on their names and telephone figure. 12. SQL gt ; CREATE INDEX CustomerDetails ON CUSTOMER ( CUSTOMER_NAME, CUSTOMER_ADDRESS ) TABLESPACE SALES_IDX ; Used to seek for client based on their names and reference. 13. SQL gt ; CREATE INDEX EmpDetail ON EMPLOYEE ( EMPLOYEE_NAME, EMPLOYEE_ADDRESS ) TABLESPACE SALES_IDX ; Used to seek for employee based on their names and reference 14. SQL gt ; CREATE INDEX VendorDetail ON VENDOR ( VENDOR_NAME, VENDOR_ADDRESS ) TABLESPACE SALES_IDX ; Used to seek for seller based on their names and reference. Position SQL gt ; CREATE VIEW C1 AS SELECT CUSTOMER_ID, CUSTOMER_NAME FROM CUSTOMER ; SQL gt ; CREATE VIEW SC1 AS SELECT CUSTOMER_NAME, TERRITORY_NAME FROM CUSTOMER A, SALES_TERRITORY B WHERE A.CUSTOMER_ID=B.TERRITORY_ID ; 3. SQL gt ; SELECT PRODUCT_DESCRIPTION, PRODUCT_FINISH, ORDERED_QUANTITY FROM PRODUCT, ORDER_LINE WHERE PRODUCT.PRODUCT_ID=ORDER_LINE.PRODUCT_ID ; Tasting waiter 1st in server side: Get DB name: ORCL Get IP reference or waiter name ( to acquire IP add type in bid IP CONFIG ) . Port No: 1521 ( Logical port of Oracle ) . Disable firewall. 2nd the client side: Get IP reference of the waiter and trial connectivity between client and sever. Then travel to ALL PROGRAMaâ⬠ââ¬â¢ ORACLE-DevSuiteHome1aâ⬠ââ¬â¢ CONFIGURATION A ; MIGRATION TOOLS aâ⬠ââ¬â¢ NET CONFIGURATION ASSISTANT aâ⬠ââ¬â¢ LOCAL NET SERVICE NAME CONFIGURATION aâ⬠ââ¬â¢ NEXT aâ⬠ââ¬â¢ ADD aâ⬠ââ¬â¢ SERVICE NAME: ORCL aâ⬠ââ¬â¢ NEXT aâ⬠ââ¬â¢ TCP aâ⬠ââ¬â¢ NEXT aâ⬠ââ¬â¢ HOST NAME: 192.168.1.1 ( THIS IP IS JUST AN EXAMPLE ) aâ⬠ââ¬â¢ Following aâ⬠ââ¬â¢ YES PERFORM TEST aâ⬠ââ¬â¢ NEXT aâ⬠ââ¬â¢ NET SERVICES Name: SAMIYA aâ⬠ââ¬â¢ NO aâ⬠ââ¬â¢ FINISH. Then unfastened SQL user name, watchword, host twine ( type here the net service name ) I recommend Automatic Storage ManagementA ( ASM ) . It s a characteristic offered by Oracle Corporation inside the Oracle DB for Oracle 10g and supra. It enhances simpleness of DB files. It contains tools that manage file systems and volumes from inside the DB. As quoted from wiki website In drumhead ASM provides the undermentioned functionality: Manages groups of discs, called disc groups. Manages disk redundancy within a disc group. Provides near-optimal I/O equilibrating without any manual tuning. Enables direction of database objects without stipulating saddle horse points and file names. Supports big files.
Subscribe to:
Posts (Atom)