Define the Entity Integrity Constraint and Referential Integrity Constraint then explain their differences in a relational database. Explain why the DELETE operation may violate only the referential integrity and not the entity constraint.
Requirements:
Question One
Consider a hypothetical online management system for the Saudi Electronic University that uses a relational database to manage its operations. This system needs to keep track of information about students (including student ID, name, major, and email), courses (including course ID, name, instructor, and department), and enrollments (including enrollment ID, student ID, course ID, grade, and semester).
Describe how you would design the relational model for this system. What tables would you create? What attributes would each table have? How would you use primary and foreign keys to represent relationships between the tables?
Answer:
Question Two
Consider a database system for SEU that stores information about students, courses, faculty, and course enrollments. A student has a unique ID, name, major, and email. Each course has a unique course ID, name, department, and credits. Faculty members have unique faculty IDs, names, departments, and specializations. An enrollment associates a student, a course, a faculty member (as the instructor), and a semester. One student can enroll in multiple courses, but each enrollment is for only one course. A faculty member can instruct many courses, and each course can have multiple students enrolled over different semesters.
Based on this description, create the ER diagram.
Answer:
Question Three
Define the Entity Integrity Constraint and Referential Integrity Constraint then explain their differences in a relational database. Explain why the DELETE operation may violate only the referential integrity and not the entity constraint. Provide examples to illustrate each constraint using the database system for SEU from question 1.
Answer:
Question Four
Using your own words, explain two advantages of the Three Tier Client-Server Architecture over the Single Tier Centralized DBMS Architecture.
Answer:
College of Administrative and Financial Sciences
Assignment 2
Introduction to International Business (MGT 321)
Due Date: 18/02/2023 @ 23:59
For Instructor’s Use only
General Instructions – PLEASE READ THEM CAREFULLY
The Assignment must be submitted on Blackboard (WORD format only) via allocated folder.
Assignments submitted through email will not be accepted.
Students are advised to make their work clear and well presented, marks may be reduced for poor presentation. This includes filling your information on the cover page.
Students must mention question number clearly in their answer.
Late submission will NOT be accepted.
Avoid plagiarism, the work should be in your own words, copying from students or other resources without proper referencing will result in ZERO marks. No exceptions.
All answered must be typed using Times New Roman (size 12, double-spaced) font. No pictures containing text will be accepted and will be considered plagiarism).
Submissions without this cover page will NOT be accepted.
Learning Outcomes:
Discuss the reasons and methods of governments’ intervention in trade (CLO: 1.2)
Analyze the effects of culture, politics and economic systems in the context of international business (CLO: 2.1)
Carry out effective self-evaluation through discussing economic systems in the international business context (CLO: 3.6)
Report Writing
Select a Saudi company that operates in any of the GULF countries, and write a (minimum of 2000 word) report covering the following points (Citation of necessary references is required):
Present the study report with clear Introduction and Conclusion including your own views. (minimum words: 500, marks: 3)
Using SWOT analysis, analyze the external and internal environment of your selected company. (minimum words: 900, marks: 7)
Strengths: Explain the strengths of the selected company;
Weaknesses: Describe the areas of weakness in the company’s operations;
Opportunities: Examine factors that may improve the company’s chances of success;
Threats: Discuss the external threats to the business company’s success.
Analyze the political, economic, cultural and legal challenges the company currently faces in any of the country it operates (select one country in which the company operates for this analysis). (minimum words: 600, marks: 5)
Answers
Answer-
Introduction
In the production of petrochemical goods, SABIC is a commander. The purpose of SABIC’s 1976 organized was to use its petroleum resources to produce finest petrochemical goods. The first company owned by SABIC, HADEED, was founded in 1982 and focused on producing steel products. SABIC settled a new main office in Riyadh in 1983 and because before, the guest has of age allure trades during the whole of various nations. In 1984, SABIC was convinced to a public trade. As a result, deceive someone’s shareholders were restricted to Saudi inhabitants and voters of different GCC countries with its own government, accompanying the Saudi administration possess 70% of the enterprise. This recently authorized public firm has started achieving shopping pushs in consideration of approach to Saudi Arabia’s colossal smoke reserves. SABIC was individual of the experience’s top 10 petrochemical builders in the 1990s (Myers, n.d.). SABIC is immediately the experience’s sixth substantial petrochemical maker, on account of reinforced shopping designs that have allowed the party to achieve important customers from everywhere the experience by usually gathering their demands. Metals, fundamental projectiles for weaponry, fertilizers, and specific merchandise are with SABIC’s clever trade pieces. As a result, the SWOT study of SABIC Company is argued in this place item. It likewise contains a inclusive reasoning of SABIC’s movements in the United Kingdom and Europe. SABIC Saudi Basic Industries’ SWOT study analyzes the brand’s substances, proneness, moment, and warnings. The within variables of the SABIC Saudi Basic Industries SWOT Analysis contain substances and proneness, when in fact the exterior facets are moment and warnings. SWOT Analysis is a tested administration example that admits a party like SABIC Saudi Basic Industries to equate allure trade and accomplishment to allure peers. Saudi Basic Industries (SABIC) is a famous name in the mechanical merchandise and chemical compound manufacturing. The following are the substances labeled in SABIC Saudi Basic Industries’ SWOT Analysis:
Answer-
STRENGTHS
A various benefits that SABIC offers. SABIC Innovative Plastics Inc., e.g., is a worldwide manufacturing ruler in manure and synthetic produce. SABIC likewise has excellent worldwide classification networks. In addition, SABIC has constructed operating law as a whole of the nations place it does trade. SABIC more benefits from a reliable administrative building, that is main for making resolutions. SABIC likewise has productive shopping methods working to guarantee that the association remnants fixated on allure clients. Because services needs are steadily changeful, customer introduction is detracting (“Intangibility, variety, agreement, and perishability (IHIP),” n.d). As a result, skilled is a need to reinforce client advantage wherewithal and produce more valuable merchandise, that SABIC previously does. Finally, SABIC has grown vying game plans that have likely it a back-and-forth competition. SABIC, for instance, engages brand distinction strategies to set allure commodity other than the contest.
Leading builders of polyethylene, polypropylene, and different cosmopolitan thermoplastics, in addition to glycols, intoxicating, and fertilizers across the realm.
Chemical production portfolio that caters to a expansive range of consumers and a worldwide vicinity in over 40 nations
With 17 specific Technology & Innovation sites during the whole of the realm, we’redo plenty test.
Strong tactics for embellishing client profit through tailor-made process-familiarize answers
The trained workers is containing about 40,000 public.
The Saudi management’s solid support form it a effective member.
WEAKNESSES
The SABIC Saudi Basic Industries SWOT Analysis has the following Weaknesses. SABIC has individual big imperfection. SABIC’s fundamental imperfection is that it is considerably dependent on non-inexhaustible inexperienced money. These non-inexhaustible money are limited. SABIC, for instance, uses common feed stocks like oil and oil. SABIC appropriates oil and oil to conceive go-between, that are therefore curve into end merchandise in the way that cures, paints, and credit card, to name any. This response feedstock, in another way, is consuming. As a result, SABIC must conduct research into a more leading synthetic method that can remodel biomass, to a degree carbon dioxide, into biography-located chemical compound (“Intangibility, variety, agreement, and perishability (IHIP),” n.d.). As a result, biography-located chemical compound will be secondhand as a feedstock for done merchandise in the way that credit card and cures. Another imperfection is SABIC’s unsettled supply chain, that can have a meaningful affect the adeptness of allure production wholes. SABIC has again existed blamed of disposal by any of nations, containing Turkey and India, that has damaged the association’s brand figure.
Allegations of disposal by countries with its own government to a degree India and Turkey have damaged the brand’s prominence.
Sublicensing overcharging concerns have built a confused friendship accompanying something added.
SABIC’s network effectiveness can be damaged by a incorrect supply chain.
OPPORTUNITIES
The following are the moment:SABIC determines a roomy range of trade prospects. SABIC, e.g., has revised allure device portfolio by utilizing forceful electronics and change abilities. SABIC has again grown on account of the raised demand for tenable manure change in the United Kingdom (Amorim and others., 2011). As a result, SABIC be able important expenses in the United Kingdom, that is home to key novelty centres and markets for energy from undepletable source, healing designs, and projectiles for weaponry, all of that are main SABIC trade districts. SABIC has again helped from joint ventures in agreements of increasing result competency and fix client demand. Because of allure connection accompanying firms like BASF, SABIC has existed intelligent to uphold a stable supply of natural resources. Through earnings, SABIC has visualized exponential growth in agro-minerals and petrochemical produce. SABIC, e.g., has written an 80 per insignificant value increase in pay after deductions in the one of four equal parts quarter of 2017 (Järvinen & Lehtinen, 2015). SABIC likewise determines to extend allure movements in added parts of Europe so that impose upon the domain’s ready advertise. Another likelihood is that Europe has a extreme demand for money like polymer. Plastic matters, apart from polymers, are in depressed supply in Europe. These polymers and assets are used to store production at home, to whole articles obtained at the market, and to accumulate garbage at home.
Joint ventures can assist in pushing ability and favorably fulfilling demand.
To help the merchandise line, the guest is depending forceful change and electronics abilities.
In the manure manufacturing, skilled is a demand for general change.
THREATS
SABIC is front two important risks. To begin with, skilled is violent competition in the petrochemical manufacturing, that may have an affect the Company’s worth. SABIC Company, e.g., has any of rivals the one supply corresponding merchandise to a degree fertilizers, polymers, and pharmaceuticals. Mitsubishi Chemical, Braskem SA, Reliance Industries Limited, and Formosa Petrochemical Corporation are few of SABIC’s favorites. Political disturbance in the United Kingdom is another hazard. The typical movement of SABIC Company has existed confused by governmental changeableness in the United Kingdom. For example, the impact of the Brexit change on SABIC’s trade movements is obscure.
Environmental burdens ability cost plenty services and reveal you to plenty risk.
Political disturbance not definite East ability hinder movements.
Intense competition in the petrochemical manufacturing has a negative affect appropriateness.
Some of the main opponents contain:
Mitsubishi Chemical
Braskem SA
Formosa Petrochemical Corporation
Reliance Industries Limited
Answer-
PESTEL ANALYSIS
ECONOMIC
The financial structures of various nations vary. For example, the United States’ tax societies are very complementary to those of India. Furthermore, the United Kingdom’s business-related security is taller that of Saudi Arabia. SABIC Company, in another way, had to install as well $500 heap on change centers to present a principle for forging new shopping strategies in consideration of evolve allure party to the rest of Europe.
POLITICAL
Political arrangements and tactics clash from individual country to the next. For example, the administration of South Korea has forbidden the produce of new assets, but the administration of India has granted the produce of singular assets. As a result, SABIC moved allure flexible ability from South Korea to India, place the art and science of administration of government popular flexible production. The impact of the Brexit change on allied movements are still mysterious. SABIC Company, for instance, has happened pausing for particular facts so that believe post-Brexit movements.
CULTURAL
There are various enlightening questions guide SABIC’s movements in Europe. For example, the advertising ideas that are brought to clients are considerably affected by their enlightening education. For example, SABIC Company concede possibility apply humor in a advertising marketing on video; but, if the nervousness of consumers in the United Kingdom clashes, the announcement is inclined be seen as abusive. Because of the ideas break precipitated apiece dialect obstruction, SABIC has had to enlist nation from the United Kingdom to undertake the local SABIC trade so that bridge the enlightening separate.
LEGAL CHALLENGES
While operating in Europe, SABIC has knowing any of allowable issues. Several lawsuits have existed ground against SABIC on account of European laborer strikes (Myers, n.d.). For example, accuser apiece name Laurie Couto disputed SABIC Company over trader pay troubles in the Couto vs. SABIC creative assets payroll ongoing plan dispute. SABIC has again met permissible challenges in South Korea and Japan having connection with the growth of creative polymers. For example, the US Department of Justice and the US Environmental Protection Agency (EPA) have orderly SABIC to pay$1 heap community punishments for breaches of the Clean Air Act in the synthetic production trade in the US.
Conclusion
The data processing machine and large trade surroundings of SABIC have happened sufficiently intentional. Micro trade surroundings refers to items that have a direct affect a guest’s movements, when in fact big trade surroundings refers to outside footing over that the party has no influence. Potential rivals are an instance of the large-scale trade atmosphere. I’ve further conferred SABIC Innovative Plastics Inc.’s financial, governmental, referring to practices or policies that do not negatively affect the environment, and permissible concerns.
Reference
About sabic (no date) SABIC. Available at: https://www.sabic.com/en (Accessed: February 18, 2023).
Hill, C. W. L. & G. T. Hult (2021). International business: Competing in the global marketplace (13th ed.). New York, NY: McGraw-Hill.
Shewan, D. (2022) How to do a SWOT analysis (Examples & Free Template!), WordStream. Available at: https://www.wordstream.com/blog/ws/2017/12/20/swot-analysis (Accessed: February 18, 2023).
Sabic tackles global challenges, continues to play key role in nation’s … (no date). Available at: https://www.spa.gov.sa/208449?lang=en&newsid=208449 (Accessed: February 18, 2023).
Facts and figures (no date) SABIC. Available at: https://www.sabic.com/en/about/corporate-profile/facts-figures (Accessed: February 18, 2023).
Question One
Consider a hypothetical online management system for the Saudi Electronic University that uses a relational database to manage its operations. This system needs to keep track of information about students (including student ID, name, major, and email), courses (including course ID, name, instructor, and department), and enrollments (including enrollment ID, student ID, course ID, grade, and semester).
Describe how you would design the relational model for this system. What tables would you create? What attributes would each table have? How would you use primary and foreign keys to represent relationships between the tables?
Answer:
Question Two
Consider a database system for SEU that stores information about students, courses, faculty, and course enrollments. A student has a unique ID, name, major, and email. Each course has a unique course ID, name, department, and credits. Faculty members have unique faculty IDs, names, departments, and specializations. An enrollment associates a student, a course, a faculty member (as the instructor), and a semester. One student can enroll in multiple courses, but each enrollment is for only one course. A faculty member can instruct many courses, and each course can have multiple students enrolled over different semesters.
Based on this description, create the ER diagram.
Answer:
Question Three
Define the Entity Integrity Constraint and Referential Integrity Constraint then explain their differences in a relational database. Explain why the DELETE operation may violate only the referential integrity and not the entity constraint. Provide examples to illustrate each constraint using the database system for SEU from question 1.
Answer:
Question Four
Using your own words, explain two advantages of the Three Tier Client-Server Architecture over the Single Tier Centralized DBMS Architecture.
Answer:
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
