Kingdom of Saudi Arabia Ministry of Higher Education Al-Imam Muhammad Ibn Saud Islamic University College of Computer and Information Sciences

In: Computers and Technology

Submitted By mtb550
Words 697
Pages 3
KINGDOM OF SAUDI ARABIA Ministry of Higher Education Al-Imam Muhammad Ibn Saud Islamic University College of Computer and Information Sciences

‫ا ر ا‬ ‫ا‬ ‫وزارة ا م ا‬ ‫د ن ود ا‬ ‫ا م‬ ‫ب وا و ت‬ ‫وم ا‬


Lab on PL/SQL Introduction to Databases (CS 340)

Problem 1 (20 points)
Table Client ClientID
10000 10001 10002 10003 10004

Ahmad Ghazi Mohamed Al-Imam Mohamed University King Saud University

Abd Allah Al-Amri Al-Hamed

2134657 2345676 5467698 1020000

Riyadh Riyadh Riyadh Riyadh

Professor Professor Professor University University

Table Bank BankID
30001 30002

Al-Rajhi AL-Balad

Table Branch BranchID
A100 R100 R101

30002 30001 30001

BranchName BranchAddress
Olaya Olaya King Fahd Riyadh Riyadh Riyadh

Table Account AccountID BranchID
AC100 AC101 AC107 AC108 A100 A100 R101 R100

10000 10001 10003 10004

20,000 120,000 300,000,000 200,000,000

Table Salary ClientID
10000 10001 10002

10000 9800 6500

10003 10003 10004 1/7
21 January 2008 at 10H

Dr. Anis Koubâa and Habeeb Allah Vulla

Question 1. Draw the relational

model of the database (2 points)

Question 2. Write a PL/SQL procedure ShowAccountInfo (AccountID) that takes as a parameter AccountID of an account and displays the Balance and the BranchID of this account. (4 points)

Dr. Anis Koubâa and Habeeb Allah Vulla


21 January 2008 at 10H

Question 3. Write a PL/SQL procedure ShowAllClients () that displays the list of all clients. (4 points)

Question 4. Write a PL/SQL function TransferSalary that takes as input parameter
• • First input: the Account ID of a University, Second input: the Account ID of a professor

and adds the salary to the balance of the account of the professor. You must check that the first Account ID…...

Similar Documents

Women in Saudi Arabia

...Frederick Akoun ENGL 102 Aaron Percich December 6th, 2011 Women’s Rights in Saudi Arabia One of the most driving forces in the world today is the issue of power and who should have it or not have it. Power relates to rights and applies to both males and females alike. Power transcends to human rights and the free will to do as a person wants to do as long as it’s within the boundaries of the rules and regulations that govern a particular place. However, we know that power has been held by an overwhelming majority by males which has led to women being deprived of some of the basic privileges that should be afforded to every human being. There have been varying reasons why women’s rights and privileges have been denied ranging from their biological inferiority to religious reasons. Saudi Arabia is known as the birthplace of Islam. Consequentially, the country adheres to a strict interpretation of Islamic religious law called the Sharia. For example, in Saudi Arabia, men and women are not permitted to attend public events together. Furthermore, men and women are segregated in the work place with men getting finer office spaces and women getting offices that alienate them from public view. In Saudi Arabia, there is an obvious divide of gender roles where men basically have majority of the power while women are afforded very limited rights (Mackey 10). I will be evaluating women’s rights in Saudi Arabia to show how they are denied their basic rights as human beings like......

Words: 3112 - Pages: 13

Saudi Arabia Exports and Imports

...Part I The Kingdom of Saudi Arabia is the largest country in the Arabian Peninsula. Saudi Arabia’s population is 27 million, including 8.4 million foreign residents (2010 census), and its capital city is Riyadh. Saudi Arabia’s geography is diverse, with forests, grasslands, mountain ranges and deserts. The climate varies from region to region. Temperatures can reach over 110 degrees Fahrenheit in the desert in the summer, while in the winter temperatures in the north and central parts of the country can drop below freezing. Saudi Arabia gets very little rain, only about four inches a year on average. Saudi Arabia is a monarchy based on Islam, which in turn has a government that is headed by the King, who is also the commander in chief of the military. One of the few monarchy’s left in the world, their power and influence continues to increase because of their natural resources as well as workforce diversity for foreigners. The King governs with the help of the Council of Ministers, also called the Cabinet (Saudi Embassy). There are 22 government ministries that are part of the Cabinet. Each ministry specializes in a different part of the government, such as foreign affairs, education and finance. Since the beginning of the first Saudi state in the 18th century through the founding of the modern Kingdom of Saudi Arabia by the late King Abdulaziz bin Abdelrahman Al-Saud on September 23, 1932, Shari'ah (Islamic law) has been the pier and source of Saudi Arabia's basic......

Words: 1830 - Pages: 8

Islam and Science

...Islam and science The road to renewal THE sleep has been long and deep. In 2005 Harvard University produced more scientific papers than 17 Arabic-speaking countries combined. The world’s 1.6 billion Muslims have produced only two Nobel laureates in chemistry and physics. Both moved to the West: the only living one, the chemist Ahmed Hassan Zewail, is at the California Institute of Technology. By contrast Jews, outnumbered 100 to one by Muslims, have won 79. The 57 countries in the Organisation of the Islamic Conference spend a puny 0.81% of GDP on research and development, about a third of the world average. America, which has the world’s biggest science budget, spends 2.9%; Israel lavishes 4.4%. Many blame Islam’s supposed innate hostility to science. Some universities seem keener on prayer than study. Quaid-i-Azam University in Islamabad, for example, has three mosques on campus, with a fourth planned, but no bookshop. Rote learning rather than critical thinking is the hallmark of higher education in many countries. The Saudi government supports books for Islamic schools such as “The Unchallengeable Miracles of the Qur’an: The Facts That Can’t Be Denied By Science” suggesting an inherent conflict between belief and reason. Many universities are timid about courses that touch even tangentially on politics or look at religion from a non-devotional standpoint. Pervez Hoodbhoy, a renowned Pakistani nuclear scientist, introduced a course on science and world affairs,......

Words: 1686 - Pages: 7

Muhammad Ibn Mūsā Al-Khwārizmī

...Mathematician/Theologian Muhammad ibn Mūsā al-Khwārizmī Muhammad ibn Mūsā al-Khwārizmī was born around the year 780 and died around the year 850. He was born in the town of Khwarizm in Khorasan province of Uzbekistan. His family moved soon afterward, to a place near Baghdad, where he accomplished most of his work in the period between 813 and 833. ( He is known as a Persian scientist, mathematician, and author. He was also Muslim. Muhammad developed the concept of the algorithm in mathematics. He also made major contributions to the fields of algebra, trigonometry, astronomy, geography and cartography. ( His systematic and logical approach to solving linear and quadratic equations gave shape to the discipline of algebra. Mathematics is the metaphor against which all other sciences are checked according to Muhammad ibn Mūsā al-Khwārizmī. Sciences “like astronomy and physics could not have developed without the foundation of mathematics and algebra” ( by him and other Muslim mathematicians and astronomers. He was the author of about a half dozen astronomical works, including a book well known in the mathematics world entitled Al-jabr w'al muqabala that gave the name al-jabr to the branch of mathematics that is now known by its modern spelling as algebra. ( Al-Khwarizmi's algebra was based on the earlier work of the Hindu mathematician Brahmagupta. His work was also influence from Babylonia and Greek......

Words: 624 - Pages: 3

Islamic Finance

... Islamic Banking and Finance To Dr Mohammad Omar Zubair, who is a source of inspiration for all those working in the field of Islamic economics and finance Islamic Banking and Finance New Perspectives on Profit-Sharing and Risk Edited by Munawar Iqbal Islamic Development Bank, Saudi Arabia David T. Llewellyn Loughborough University, UK Edward Elgar Cheltenham, UK • Northampton, MA, USA In association with: International Association of Islamic Economics Islamic Development Bank The Islamic Foundation © Dr Munawar Iqbal and Professor David T. Llewellyn 2002 (on behalf of the Steering Committee for the Fourth International Conference on Islamic Economics and Banking held at Loughborough University, UK, August 13–15, 2000) All rights reserved. No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise without the prior permission of the publisher. Published by Edward Elgar Publishing Limited Glensanda House Montpellier Parade Cheltenham Glos GL50 1UA UK Edward Elgar Publishing, Inc. 136 West Street Suite 202 Northampton Massachusetts 01060 USA A catalogue record for this book is available from the British Library Library of Congress Cataloguing in Publication Data Islamic Banking and Finance: New Perspectives on Profit-Sharing and Risk / edited by Munawar Iqbal, David T. Llewellyn p. cm. “Some of the papers were......

Words: 106697 - Pages: 427

Saudi Arabia Is a Medium Political Risk

...Saudi Arabia is a medium political risk country. Saudi Arabia is the No. 1 oil exporter, underpins U.S. security policy in the Middle East and holds great sway over the world's 1.6 billion Muslims through its guardianship of Islam's two holiest sites.  The first political risk facing is the succession. King Abdullah turns 90 this year and his heir, half-brother Crown Prince Salman, turns 77. In February he named his youngest half-brother, Prince Muqrin, 70, as second deputy premier, a role often seen as making its holder second-in-line to rule. However, it is not certain that Muqrin will one day become king and the ruling al-Saud family is preparing for the moment when the line of brothers born to its founder Ibn Saud is exhausted and power must move to the next generation. By appointing Ibn Saud's grandsons to new roles, including interior minister and governor of Riyadh province, in recent months, Abdullah has already started the gradual transfer of power to younger princes. The second political risk is the domestic strains. King Abdullah has advanced some economic and social reforms to address youth unemployment, corruption and a lack of housing but offered no big political reforms. Riyadh plans to spend a record $219 billion on welfare and infrastructure in 2013. Tensions smoulder between those who want more social change, such as bringing more women into the workplace, and powerful conservatives who condemn such reforms as un-Islamic. Clerics have protested against......

Words: 1007 - Pages: 5

Saudi Arabia Paper by Mansor Turbo

...Saudi arabia is the largest Arab state in Western Asia by land area, constituting the bulk of the Arabian Peninsula, and the second-largest in the Arab world (after Algeria). It is bordered by Jordan and Iraq on the north and northeast, Kuwait, Qatar, Bahrain and the United Arab Emirates on the east, Oman on the southeast, and Yemen on the south. The Kingdom of Saudi Arabia was founded by Abdul-Aziz bin Saud (known for most of his career as Ibn Saud) in 1932, although the conquests which eventually led to the creation of the Kingdom began in 1902 when he captured Riyadh, the ancestral home of his family, the House of Saud, referred to in Arabic as Al Saud. The Saudi Arabian government, which has been an absolute monarchy since its inception, refers to its system of government as Islamic. The kingdom is sometimes called "The Land of the Two Holy Mosques" in reference to Al-Masjid al-Haram (in Mecca), and Al-Masjid al-Nabawi (in Medina), the two holiest places in Islam. Saudi Arabia has the world's second largest oil reserves which are concentrated largely in the Eastern Province and oil accounts for more than 95% of exports and 70% of government revenue. This facilitates the creation of a welfare state although the share of the non-oil economy is growing recently. It has also the world's sixth largest natural gas reserves. The new kingdom was one of the poorest countries in the world, reliant on limited agriculture and pilgrimage revenues.However, in 1938 vast reserves of......

Words: 1370 - Pages: 6

Information Security Policy for E-Government in Saudi Arabia: Effectiveness, Vulnerabilities

...Information Security Policy for E-government in Saudi Arabia: Effectiveness, Vulnerabilities and Threats [Name of the Writer] [Name of the Institute] Executive Summary Introduction: In many countries, the implementation of the E-Government has proved to be useful in providing efficient services to the consumers. This increases the speed of the work and does not cause any unnecessary delays. All these aspects matters for the efficient service of the Government work. In the end, it proves to be beneficial for both Government and the citizens living in Saudi Arabia. Therefore, in this study, all the issues related to the Information Security Policy will be discussed in detail. The research study is worth for a number of reasons. Firstly, it will help in assessing the degree of effectiveness of the present security policy, security holes in the policy, and threats not addressed by the policy. It, in turn, would help in coming up with measures of ensuring that the policy is security-oriented, which increases citizens’ confidence in using e-government services. Literature Review: The primary purpose of producing literature review is to support the findings of this study via the theoretical justifications obtained from literature. The review revealed that in Saudi Arabia, there is the absence of agencies to monitor the accountability of e-government services. Most of the workers of offices in Saudi Arabia lack professionalism, and this is a great weakness in the......

Words: 10327 - Pages: 42

Female Dentists in Saudi Arabia

...Female Dentists in Saudi Arabia Name Institution Female Dentists in Saudi Arabia According to a survey conducted in 1974, the Kingdom of Saudi Arabia only had seven million people. The population has been on the rise, overtime. The population increased to 27,601,038 million in 2007, according to results of a survey by the Central Department of Statistics.1 Approximately 54.3 percent of the Saudi Arabia’s national population consists of males while the remaining 45.7 percent are females. Even though the population increases rapidly, it does not adversely affect critical sectors in Saudi Arabia such as education. Instead, the population growth is beneficial in promoting development of key sectors in Saudi Arabia. The rapid growth prompted the ministry of education, for instance, to establish schools. The ministry also improved existing educational facilities to accommodate the increasing student population. In 1994, there were only seven major universities and eighty-three colleges in Saudi Arabia.2 Presently, over 142,000 students study in Saudi universities and colleges. Among the students, 60,000 are female. Most female students pursue their studies in five different universities: King Saud, Abdul Aziz, Faisal, Imam Muhammad and Umm Al-Qura. The largest faculty in King Saud University (KSU) is its famous College of Dentistry.2 KSU is the first among all colleges in Saudi Arabia to offer dentistry program across the entire Arabian......

Words: 512 - Pages: 3

Pest Analysis Saudi Arabia

...Saudi Arabia PEST analysis Policital factors Saudi Arabia is politically a very stable country in the Middle East since it is ruled by the Al Saud dynasty's which main goal is to concentrate on modernization and on developing the country's role as a regional power. It is general known that Saudi Arabia is the biggest petroleum exporter in the world which was discovered on March 3rd 1938. Before that the country was only a trade-based economy. The Kingdom is besides a member of the OPEC, the Organization of Petroleum Exporting Countries. It is of importance to mention that Saudi joined the WTO – the World Trade Organization - on 11th December 2005. This well-known organization reviewed the corresponding trade policies and practices in January 2012. Responsible for the developing followed by the realization of Saudi’s trade policies is the Ministry of Commerce and Industry, the MCI. To enter Saudi Arabia by air you will need a Visa and valid passport for at least another six month from the date of entry. The country has two major visa options, a travel and a working one. A working visa which should be applied through a visa agencies accredited to the Royal Embassy of Saudi Arabia. Besides a business partner, any Saudi business that “hold a majority interest in the company”1, is needed, who acts as a sponsor which is required as well for doing business in SA. Be aware, “you may be refused entry to Saudi Arabia if your passport contains evidence of previous travel to Israel or......

Words: 2527 - Pages: 11

Determinants of Library Use, Collections and Services Among the Students of Engineering: a Case Study of King Saud University

...students of engineering: a case study of King Saud University Akhtar Hussain Civil Engineering Department, King Saud University, Riyadh, Kingdom of Saudi Arabia, and Abdulwahab M. Abalkhail Department of Library and Information Science, King Saud University, Riyadh, Kingdom of Saudi Arabia Abstract Purpose – The purpose of this paper is to examine the determinants of library use, collections and services among the students of engineering at King Saud University, Riyadh (KSA). Design/methodology/approach – A survey was designed to collect needed information about the level of usage of library collections, services and satisfaction of users. A well-structured questionnaire was circulated among the faculties, research scholars, postgraduates, undergraduates, and other categories to collect the necessary primary data, keeping in mind the objectives of the study. Findings – The findings clearly reveal that the majority of users of the library used the circulation service. The study found that a majority of research scholars consult the reference books for research work followed by undergraduate students who used the library circulation service. Research limitations/implications – The present paper consists only of College of Engineering users and the geographical area is restricted to the central library at the King Saud University, Riyadh. The scope of the paper could be extended to additional private and government universities in KSA and abroad. A comparative study......

Words: 6330 - Pages: 26

History of Saudi Arabia

...In pre-Islamic times, apart from a small number of urban trading settlements (such as Mecca and Medina), most of what was to become Saudi Arabia was populated by nomadic tribal societies in the inhospitable desert.[38] The Islamic prophet, Muhammad, was born in Mecca in about 571 A.D. In the early 7th century, Muhammad united the various tribes of the peninsula and created a single Islamic religious polity. Following his death in 632, his followers rapidly expanded the territory under Muslim rule beyond Arabia, conquering huge swathes of territory (from the Iberian Peninsula in west to modern day Pakistan in east) in a matter of decades. In so doing, Arabia soon became a politically peripheral region of the Muslim world as the focus shifted to the more developed conquered lands.[39] From the 10th century to the early 20th century Mecca and Medina were under the control of a local Arab ruler known as the Sharif of Mecca, but at most times the Sharif owed allegiance to the ruler of one of the major Islamic empires based in Baghdad, Cairo or Istanbul. Most of the remainder of what became Saudi Arabia reverted to traditional tribal rule.[40][41] In the 16th century, the Ottomans added the Red Sea and Persian Gulf coast (the Hejaz, Asir and Al-Ahsa) to the Empire and claimed suzerainty over the interior. One reason was to thwart Portuguese attempts to attack the Red Sea (hence the Hejaz) and the Indian Ocean.[42] Ottoman degree of control over these lands varied over the next......

Words: 7082 - Pages: 29

Al Barakah

...About Al Baraka |   | Al Baraka Islamic Bank B.S.C. (c) - Bahrain (AIB - Bahrain) established 1984 in Bahrain and up the years has pioneered the development of Islamic banking and finance. The Bank is registered with the Bahrain Ministry of Industry &, Commerce CR no. 14400 and is licensed by Central Bank of Bahrain (CBB) as an Islamic Retail Bank, with an authorized capital of US$ 600 Million, of which US$ 122 Million has been issued and fully paid.AIB - Bahrain is one of the Banking Units of Al Baraka Banking Group's (ABG). ABG is a Bahraini Joint Stock Company listed on Bahrain and Dubai stock exchanges and one of the well-known leading international Islamic banks.  It has been rated by Standard & Poor's as BBB- with a short-term rating of A-3. ABG offers retail, corporate and investment banking and treasury services strictly in accordance with the principles of the Sharia'a. The authorized capital of ABG is US$1.5 billion, while the total equity amounts to about US$ 1.8 billion.  The Group has a wide geographical presence in the form of subsidiary banking Units in 14 countries, which in turn provide their services through more than 400 branches.  These banking Units are Jordan Islamic Bank/ Jordan, Al Baraka Islamic Bank - Bahrain, Al Baraka Bank Limited/ Pakistan, Banque Al Baraka D'Algerie/ Algeria, Al Baraka Bank Sudan/ Sudan, Al Baraka Bank Ltd/ South Africa, Al Baraka Bank Lebanon/ Lebanon, Al Baraka Bank Tunisia/ Tunisia, Al Baraka Bank Egypt/ Egypt, Al......

Words: 2512 - Pages: 11

Road Accidents in Saudi Arabia

...[Type the document title] Literature Review: Road Traffic Accidents 9/17/2011 Student Name: University: Table of Contents INTRODUCTION TO ROAD TRAFFIC ACCIDENTS 4 Safety 4 Safety of Roads 4 Safety condition of Vehicles 5 Road Traffic Accidents 5 Major Causes of Road Traffic Accidents 7 Improper maintenance of vehicle 8 Red Light Running 9 Use of Mobile Phones while driving 10 Drunk driving 11 Avoiding Seat Belt or Helmets 11 Youth races and careless driving 11 Improper road structure 12 Effects of Traffic Accidents 13 Social Impacts of Road Traffic Accidents 13 Economic Impacts of Road Traffic Accidents 14 Ways for controlling the traffic accidents 14 INTRODDUCTION INTO THE CEASES OF TRAFFIC ACCIDENTS IN JEDDAH CITY 18 History of the problem in Saudi Arabia 18 The Roads and Public Transport in Saudi Arabia 19 The causes of the Road Traffic Accidents in Saudi Arabia 19 The effects of the Road Traffic Accidents in Saudi Arabia 20 Jeddah City 22 Population 22 Economy 22 Society 22 Road &Traffic Laws in Saudi Arabia (Jeddah) 23 THE USED METHDOLGIES AND ANALYSIS OF DATA 23 The different used methodologies for gathering the data 23 Analysis of international data 24 Analysis Middle East data 27 Analysis Saudi Arabia and Jeddah data 28 CONCLUSION/RECOMMENDATION 29 REFERENCES 31 Literature Review INTRODUCTION TO ROAD TRAFFIC ACCIDENTS Safety According to Security Industry Association (SIA 160),......

Words: 11782 - Pages: 48

Saudi Arabia

...religious beliefs, traditions, work ethic ( culture) The full name of Saudi Arabia is the Kingdom of Saudi Arabia. Arabic is the official language. In the 7th century, the successor of the Mohammed who was the founder of Islam established Arab empire. The 8th century is a heyday for Saudi Arabia, and its territory crosses Europe, Asia and Africa. However, in the 16th century, Arab empire was ruled by the Ottoman Empire. In the 19th century, The Great Britain invaded into Arab, it was divided into two parts, Hejaz and Nejd. In 1924, the chief of Hejaz in Saudi Arabia merged Nejd and then gradually unified the Arabian Peninsula. Finally, in September 1932, he declared the establishment of Saudi Arabia kingdom. Saudi Arabia is the birthplace of Islam. Islam has become the world’s second large religion. The founder Muhammad established Islam approximately A.D 600 in Mecca; the sacred city of Islam is located in Saudi Arabia. Islam prospers in northwestern Africa, the Middle East, Central Asia, Pakistan, and some Southeast cities. Religion strongly affects consumption behavior of Arabian. For example, Muslim consumers are not allowed to consume alcohol and pork, besides that, the nation is governed under the Law of Islamic. Muslim pray five times a day, the local people usually go to the mosque to do religious service. Women must wear black robes in that day. Some of the traditions and customs in Saudi Arabia are similar to the other countries, but some of them are......

Words: 2053 - Pages: 9