الكويت البحرين عمان الأردن لبنان مصر البحرين حائل الرياض الدمام جدة المدينة المنورة الاحساء
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
Case Study:
Pepsi's Global Strategy
Mike Doyle, creative director at Arnell Group, explains that there was a great depth of exploration and research that was conducted before even beginning to formulate a new Pepsi packaging strategy. PepsiCo and Arnell Group traveled extensively to emerging markets to find key consumer product drivers for youth cultures and to learn how the Pepsi brand was perceived in different countries.
They found, somewhat surprisingly, that there were very few differences around the world in how consumers felt about Pepsi's fun, effervescent brand image. "The brand equity is really consistent," says James Miller, marketing director, Pepsi-Cola North America. They also found many consistencies in youth cultures around the world in how today's youth is preoccupied with newness, discovery, and personalization of their possessions. Miller describes the design campaign's goal as "sustainable discovery," where the consumer audience is constantly intrigued and engaged.
Designers at Arnell Group created the dozens of new and vibrant designs with only a handful of blue and gray shades. Each design tells a story of sorts and each can design has a unique website address on the side of the can. The first one on the "Your Pepsi" can allows web users to design a digital billboard that will appear in Times Square, and one coming shortly will allow users to mix their own music online.
"We redefined packaging as media in the marketplace for Pepsi," says Doyle. "It speaks to youth in their language." Doyle believes that the designs succeed because they are able to capture the audience's mind space. "The designs are reflecting back to the culture instead of talking to the culture or imposing on it.
Pepsi actually asked their loyal consumers what brand elements would have to remain so that they would be intuitively reassured that their favorite drinks were not changing and the brand they trusted was still essentially the same. Their answer was direct and consistent. Pepsi-lovers needed to see three elements for sure—the Pepsi "globe," the iconic Pepsi blue, and the familiar tilted Pepsi capital letters.
Arnell Group updated the primary logo substantially and cleverly without really redesigning its key elements. The most recent logo design had the Pepsi wordmark on top of and slightly overlapping the iconic Pepsi red-white-and-blue "globe." On the previous can design, the wordmark wrapped halfway around the can, and the globe was off-center. The new cans and bottles have un-bundled the word and globe, making the newly centered globe more of the hero, and the smaller Pepsi wordmark less prominent.
Television ad campaigns are reinforcing the globe-centric approach by featuring a boulder-sized Pepsi globe in various settings careening to and fro like a pinball. In the ads and on the front of most of the new packages is the reassuring tag line: "Same Pepsi inside, new look outside." Miller explains that it is customary and important to reassure consumers for at least six months in situations like this. Miller also sees today's youth as demanding authenticity from the products they come into contact with in their day-to-day experiences. The new Pepsi design strategy is versatile because it can be authentic and stay current, and it could also make introducing special seasonal or regional designs more intriguing and less disruptive. "This is a new way of using packaging as media," explains Miller. "The consumer is looking for more variety and expecting more from their brands. They want to have a dialogue with their favorite brands."
Answer the following questions:
Question 1: (30 Marks)
All companies must continually conduct research to understand the needs and priorities of their market segments. Consumer needs are shaped by the environment, culture, education, and life experiences.
a. Define Marketing concept and explain briefly the three elements of the marketing strategic framework. (15 Marks)
b. Show how PEPSI is applying the Marketing concept. (15 Marks)
Word count: 300 words
Question 2: (30 Marks)
a. Define the communication concept, list its 5 basic components and elaborate on the MEDIUM concept (15 Marks)
b. Discuss the following statement revealed by Miller : "This is a new way of using packaging as media" (15 Marks)
Word count: 300 words
Question 3: (20 Marks)
Brand is the "name, term, design, symbol, or any other feature that identifies one seller's good or service as distinct from those of other sellers."
a. What is Brand Personality? (10 Marks)
b. Discuss PEPSI’s Brand personality (10 Marks)
Word count: 250 words
Question 4: (20 Marks)
A total product is much more than a physical product. If a product is involved, it probably needs packaging. Further, physical products and services probably should be branched to make sure that they are clearly identifiable and that satisfied customers will know what to ask for next time.
What is your favorite package designed by PEPSI? Describe it and explain why.
Word count: 200 words
حل واجبات الجامعة العربية المفتوحة
حل واجبات الجامعه العربية المفتوحه مع الشرح
لجميع فروع الجامعة ولجميع التخصصات ولجميع المواد
الكويت البحرين عمان الأردن لبنان مصر البحرين حائل الرياض الدمام جدة المدينة المنورة الاحساء
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
الكويت البحرين عمان الأردن لبنان مصر البحرين حائل الرياض الدمام جدة المدينة المنورة الاحساء
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
حل واجب 0.5.4.4.3.2.1.4.5.5 الجامعة العربية المفتوحة
حل واجبات الجامعة العربية المفتوحة O54.4.3.2.1.4.5.5 - OO96654.4.3.2.1.4.5.5
ايميل : a_al_shora @ h.o.t.m.ail.c.o.m
سكايبي: a_al_shora
واتس اب: OO96654.4.0.5.0.8.9.7
M359, Relational Databases: Theory and Practice
Summer-2015
Assignment Booklet
Cut-off date:………….. 2015
Plagiarism Warning:
As per AOU rules and regulations, all students are required to submit their own TMA work and avoid plagiarism. The AOU has implemented sophisticated techniques for plagiarism detection. You must provide all references in case you use and quote another person's work in your TMA. You will be penalized for any act of plagiarism as per the AOU's rules and regulations.
Declaration of No Plagiarism by Student (to be signed and submitted by student with TMA work):
I hereby declare that this submitted TMA work is a result of my own efforts and I have not plagiarized any other person's work. I have provided all references of information that I have used and quoted in my TMA work.
Name of Student:………………………………..
Signature:…………………………………………...
Date:……………………………………………………
TMA M359 Cut-off date: ………….., 2015
This assignment should be submitted electronically. You should write your solutions to the questions in a single word document, which is named using your short ID (6 digits), your full name, the course code and the TMA, your file name should look as follows:
M359-TMA-SUMMER-2015-YourBranchName-YourID-YourFullName.doc
Submit your document to your tutor on or preferably before the cut-off date shown above.
This TMA assesses your work of the course covering the material from block one unit one to block three of M359. The total marks for each question are shown at the beginning of each question.
You are requested to provide answers on ALL the questions.
The marks allocation is as follows:
Using the AOU’s E-library facility or external resources, provide an adequate answer to this question with proper referencing.
a) What is a real-time database Systems (RTDBSs)? And how is it different from the traditional database systems? (5 marks)
b) List four real time applications? (4 marks)
c) List three commercial RTDBS with their website links and three RTDBS prototype projects with their supported organization? (6 marks)
Question 2: [20 marks]
Give a conceptual data model (CDM) for the following given scenario using the Entity-Relationship model, including the complete E-R diagram, the entity types, attributes, any required constraints, assumptions and limitations.
A company wants to create a photo hosting website. It is intended to be a popular website for subscribers to upload and share their personal photos.
The website system offers three types of accounts: Free, advertisement-free and double-space. The free option includes limited storage space defined by the company. The advertisement-free option allows the subscriber to avoid advertisements for annual fee. The double-space account includes twice the storage of the free account for annual fee too. An account entity details are kept in as accountID, acountDescription and Fee.
The subscriber needs to register an account in order to upload photos into the website. Registering an account includes creating a profile page containing subscriberID, subscriberName, birthDate, emailAddress, Country. The subscriber has the ability to add another subscriber as a contact.
Subscribers can organise their uploaded photos into albums where one photo can belong to one album, many albums, or not at all. Each album should have a unique album identifier albumID, a title, number of photos and the creation date/time of the album. Subscribers may label their uploaded photos with titles, descriptions, date/time taken and the privacy control flag. In addition to a system generated unique photo identifier photoID, and some other details about the photo filename and its type (e.g. png, jpg, tif,...)
Photos may be tagged by the uploader. These text tags enable the computer searching process for these photos. The system keeps track of all tags in a separate table.
Question 3: [10 marks]
a) Declare the relations corresponding to the fragment of an E-R diagram model below and draw, if possible, one equivalent ER diagram with three entity types.
State the following queries using relational algebra
a) List all business type buildings with age > 3’.
b) List the Building name, type, and address of all buildings that are looked after by a keeper.
c) Get the names of keepers who look after hotel buildings and they are ‘junior’ grade and have less than 2 years of service.
d) Get the names of keepers who look after hotels but not business buildings.
e) Get the names of keepers who look after all the buildings.
Question 6: [15 marks]
Write SQL queries, and run them using MySQL or ISQL against the University database. Include in your answer BOTH the SQL query you wrote and the output table that results. You MUST use meaningful column names, which may require using column aliases in the SQL query.
Students are required to use the University Database for answering this part of the TMA
a) How many students are tutored in each course?
b) Get all students’ ID and names who have enrolled before January 2003.
c) Get the names of tutors who is teaching ‘Syntax’ course.
d) List students enrolled and not attended the examination.
e) List the names and mark of the students whose examination mark in C4 is less than the average examination mark for the same course.
“End of Question”
حل واجبات الجامعة العربية المفتوحة
حل واجبات الجامعه العربية المفتوحه مع الشرح
لجميع فروع الجامعة ولجميع التخصصات ولجميع المواد
الكويت البحرين عمان الأردن لبنان مصر البحرين حائل الرياض الدمام جدة المدينة المنورة الاحساء
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
الكويت البحرين عمان الأردن لبنان مصر البحرين حائل الرياض الدمام جدة المدينة المنورة الاحساء
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
حل واجب 0.5.4.4.3.2.1.4.5.5 الجامعة العربية المفتوحة
حل واجبات الجامعة العربية المفتوحة O54.4.3.2.1.4.5.5 - OO96654.4.3.2.1.4.5.5
ايميل : a_al_shora @ h.o.t.m.ail.c.o.m
سكايبي: a_al_shora
واتس اب: OO96654.4.0.5.0.8.9.7
Faculty of Computer Studies
T215B
Communication and Information Technologies – Part B
Tutor Marked Assignment
Cut-Off Date: July 27, 2015 Total Marks: 80
Contents
Part A: Hill cipher
Part B: Hill cipher Encryption and Decryption
Plagiarism Warning:
As per AOU rules and regulations, all students are required to submit their own TMA work and avoid plagiarism. The AOU has implemented sophisticated techniques for plagiarism detection. You must provide all references in case you use and quote another person's work in your TMA. You will be penalized for any act of plagiarism as per the AOU's rules and regulations.
Declaration of No Plagiarism by Student (to be signed and submitted by student with TMA work):
I hereby declare that this submitted TMA work is a result of my own efforts and I have not plagiarized any other person's work. I have provided all references of information that I have used and quoted in my TMA work.
Name of Student:
Signature:
Date:
Part A: Hill cipher (40 marks)
You have studied several algorithms of encryption during your study of T215B course. This part focuses on Hill cipher cryptography algorithm; this task aims to assist you in learning more about the Hill cipher. Your answer for this task should be as report which starting with introduction and ending with conclusion, the report should be within 800 – 1000 words (long report, you should adhere to word count), the report must have proper citations and references. The body of your report should answer the following questions:
1. Define Hill Cipher? (3 marks)
2. Mention briefly the history of Hill cipher? (2 marks)
3. The advantages of Hill cipher?(4 marks)
4. The disadvantages of Hill cipher? (3 marks)
5. Describe the Hill cipher Encryption step? (6 marks)
6. Describe the Hill cipher Decryption step? (5 marks)
7. Discuss the Cryptanalysis of the Hill System? (5 marks)
8. Discuss how Cracking a Hill Cipher? (5 marks)
Your answer should be within the range of (800 – 1000) words count. (2 marks) Any extra words mean deduction of marks.
Note: You should provide proper references and use citation (2 marks)
Part C: Hill Cipher Encryption and Encryption (40 marks)
This part is a practical one. Based on the previous study of Hill cipher in Part A, you have to test the algorithm of Encryption, and Decryption by using the following table.
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
1. If the matrix size is [2x2], use your first name as an input message (Plaintext), and use the key (GLEP) to encrypt your first name. Your answer should be detailed, you should show each output of each step of the algorithm besides the final answers. (16 marks)
Note: Any empty places can be padded with redundant letters (the ‘x’ in the chosen)
2. If the matrix size used in Encryption is [3x3] and the key was (JQDSMFIBL), answer the following question
a- What will be the Inverse Matrix? Your answer should be detailed (8 marks)
b- What is the Plaintext if the Chiphertext is (ECKGYKOFRLNR) (16 marks)
Your answer should be detailed, you should show each output of each step of the algorithm besides the final answers.
NOTES
• Make sure to write your name and ID clearly.
• Answer all questions and do not exceed the word count.
• Always make citations and referencing (provide proper references using any format).
• Use your own words (copy and paste cause deduction of marks even if you provide proper references).
--------------------------------
End of TMA
Good Luck
حل واجبات الجامعة العربية المفتوحة
حل واجبات الجامعه العربية المفتوحه مع الشرح
لجميع فروع الجامعة ولجميع التخصصات ولجميع المواد
الكويت البحرين عمان الأردن لبنان مصر البحرين حائل الرياض الدمام جدة المدينة المنورة الاحساء
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
الكويت البحرين عمان الأردن لبنان مصر البحرين حائل الرياض الدمام جدة المدينة المنورة الاحساء
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
حل واجب 0.5.4.4.3.2.1.4.5.5 الجامعة العربية المفتوحة
حل واجبات الجامعة العربية المفتوحة O54.4.3.2.1.4.5.5 - OO96654.4.3.2.1.4.5.5
ايميل : a_al_shora @ h.o.t.m.ail.c.o.m
سكايبي: a_al_shora
واتس اب: OO96654.4.0.5.0.8.9.7
Page 1 of 3
Summer 2014-2015 - TT284 - TMA .
TT284 - Tutor-Marked Assignment Cut-Off Date: 22, July 2015 Total Marks: (40) Contents Question1 (4 marks) Question2 (6 marks) Question3 (5 marks) Question4 (25 marks) Plagiarism Warning As per AOU rules and regulations, all students are required to submit their own TMA work and avoid plagiarism. The AOU has implemented sophisticated techniques for plagiarism detection. You must provide all references in case you use and quote another person's work in your TMA. You will be penalized for any act of plagiarism as per the AOU's rules and regulations. Declaration of No Plagiarism by Student (to be signed and submitted by student with TMA work) I hereby declare that this submitted TMA work is a result of my own efforts and I have not plagiarized any other person's work. I have provided all references of information that I have used and quoted in my TMA work. Name of Student: ………………………………….….. Signature: ……………………………………….……... Date: ………………………………………….………… Faculty of Computer Studies TT284: Web Technologies
Page 2 of 3
Summer 2014-2015 - TT284 - TMA .
TT284 - TMA Cut-off date xx July 2015 This TMA covers Blocks 1, 2 and 3. This TMA consists of 4 questions, and the total mark is out of 40 Question 1: [4 marks] Assume that the user is visiting a website with an average data transmission rate of 512 (Kbps); consider the request for a single webpage comprising 8000 bytes of text (including HTML tags), and a CSS file containing 3000 bytes, along with three images at an average size of 4000 bytes, and a single image for the banner at a size of 11000 bytes. Assume that it takes the server 9 millisecond to respond to each file request. Note: the single image for the banner is not stored in the browser’s cache. Calculate the total time required to download all these files. Question 2: [6 marks] There are many software applications that are imped within and used in the web browsers. Discuss and explain four of these applications (browser’s based clients), what is the main purpose of each one of them? Question 3: [5 marks] Define and discuss five problems occurs while using mobile devices to access websites. Question 4: [25 marks] Create a dynamic web page. Search the web and make a comparison between Lumia 540 Dual SIM and HTC One M9 based on their body, display, processor and main functionalities. After that develop a web page that includes the following requirements: 1. Page Title. 2. Your own logo (design a logo that has your name or initials, eg Omar Alali or OA). 3. Short introduction about the importance Mobile Phones. 4. Sub web pages that include: a. Lumia 540 Dual SIM and HTC One M9. One image for each is adequate. b. Drop-down list to choose either Lumia 540 Dual SIM or HTC One M9 and display the selected phone specifications you found from your search. c. A form that asked you to enter phone screens width and height in inches and in pixels then calculate the resolution of the phone in pixels per inch Using JavaScript. d. References to source of information.
Page 3 of 3
Summer 2014-2015 - TT284 - TMA .
What to submit? 1. An initial sketch of the web page using The Pencil Environment Application. (a screen shot image NOT the execution) (2 marks) 2. The required XHTML code. It should be functioning correctly. (16 marks) 3. The needed CSS code. (3 marks) 4. The JavaScript code that made the above calculations. (4 marks) Hints: you may compress all files above in one .rar or .zip file to submit. But if your e-TMA system did not accept compressed files, ask your Tutor to provide another link in the LMS so as you can submit all. we mean by 'your page should be functioning correctly' is that if you put all files in one directory then by clicking on the "index" file, your page will run as described. End of TMA KEY Guide
حل واجبات الجامعة العربية المفتوحة
حل واجبات الجامعه العربية المفتوحه مع الشرح
لجميع فروع الجامعة ولجميع التخصصات ولجميع المواد
الكويت البحرين عمان الأردن لبنان مصر البحرين حائل الرياض الدمام جدة المدينة المنورة الاحساء
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
الكويت البحرين عمان الأردن لبنان مصر البحرين حائل الرياض الدمام جدة المدينة المنورة الاحساء
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
حل واجب 0.5.4.4.3.2.1.4.5.5 الجامعة العربية المفتوحة
حل واجبات الجامعة العربية المفتوحة O54.4.3.2.1.4.5.5 - OO96654.4.3.2.1.4.5.5
ايميل : a_al_shora @ h.o.t.m.ail.c.o.m
سكايبي: a_al_shora
واتس اب: OO96654.4.0.5.0.8.9.7
عمادة البرامج الأكاديمية في التربية
استمارة الواجب الدراسي (TMA Form)
مقرر الحضارة العربية الاسلامية...- GR111
الفصل الدراسي الصيفي- 2014/2015
الجزء (1) (خاص بالطالب)
اسم الطالب
/ الطالبة
الرقم الجامعي
رقم الهاتف
البريد الإلكتروني
رمز المقرر ورقمه
تاريخ تسليم الواجب
الجزء (2) (خاص بعضو هيئة التدريس)
تاريخ الاستلام
من الطالب
اسم عضو هيئة التدريس
الفرع
على عضو هيئة التدريس التأكد من استكمال تعبئة كافة البيانات
الدرجة لكل نشاط (في حالة وجود عدة نشاطات) الدرجة النهائية: / / 20
ملاحظات المصحح:
.................................................. .................................................. .....
.................................................. .................................................. .....
.................................................. .................................................. .....
.................................................. .................................................. .....
.................................................. .................................................. .....
امضاء المصحح....................................... ....التاريخ: / / 2015
عزيزي الطالب / ة:
- يخصص لهذا الواجب 20 درجة من درجات أعمال السنة (20 %).
- ينبغي أن تجيب عن الأسئلة بنفسك، وبأسلوبك الخاص .
- المطلوب طباعة الواجب وتسليمه عبر المنبر الالكتروني الخاص بالفرع (LMS).
- بالإمكان استخدام المكتبة الإلكترونية الخاصة بالجامعة.
- سوف يقوم عضو هيئة التدريس بمناقشتك في إجابتك، فضلاً عن تدوينه لملاحظاته على هذه الإجابات ،والتي ينبغي الاسترشاد بها كتغذية راجعة.
- مراعاة التوثيق بطريقة علمية .
- توخي الدقة في الأمانة العلمية.
- تمثل الحالات التالية أنماطاً من الغشّ والسرقة العلمية تحرمها لوائح الجامعة:-
أ. النسخ الحرفي للمواد المطبوعة وتقديمها ضمن الواجبات الدراسية دون توثيق علمي حسب الأصول.
ب. النسخ الحرفي للمادة التي تظهر على شبكة الانترنت بما في ذلك الجداول والصور.
ج. نسخ ملاحظات الطلبة الآخرين أو تقاريرهم.
د. المادة التي يعدّها للطالب أفراد أو مؤسسات، بأجر أو بدون أجر.
ﻫ. استخدام المواد أو الأدوات الممنوعة في الامتحانات، أو الشروع في ذلك.
مع أطيب الأمنيات بالتوفيق ،،،
الواجب الدراسي – TMA
مقرر الحضارة العربية الاسلامية – GR111
الفصل الدراسي الصيفي 2015-2014 -
سؤال الواجب:
" اهتم المسلمون بعلم الفلك منذ بداية نهضتهم العلمية حيث اقبل العلماء المسلمون على دراسة هذا العلم ومعرفة اصوله ، فأقاموا لذلك المراصد الفلكية الكثيرة وابتكروا العديد من الآلات الفلكية التي سهلت عليهم رصد ومتابعة حركة الكواكب والنجوم ، فتمكنوا بفضل هذه الجهود من تحقيق انجازات علمية هامة في هذا المجال ..."
في ضوء ذلك، اكتب عن علم الفلك عند المسلمين مركزا حديثك على النقاط التالية:
1- اذكر اسباب اهتمام المسلمين بعلم الفلك ؟ (4 درجات )
2- اذكر أسماء اشهر علماء الفلك المسلمين واهم مؤلفاتهم العلمية ؟ ( 8 درجات )
3- وضح اهم انجازات العلماء المسلمين في علم الفلك واثر ذلك على النهضة الاوربية ؟ (8 درجات )
ملاحظة : يجب توثيق اجابتك بطريقة علمية صحيحة .
( انتهت الاسئلة )
حل واجبات الجامعة العربية المفتوحة
حل واجبات الجامعه العربية المفتوحه مع الشرح
لجميع فروع الجامعة ولجميع التخصصات ولجميع المواد
الكويت البحرين عمان الأردن لبنان مصر البحرين حائل الرياض الدمام جدة المدينة المنورة الاحساء
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
الكويت البحرين عمان الأردن لبنان مصر البحرين حائل الرياض الدمام جدة المدينة المنورة الاحساء
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
حل واجب 0.5.4.4.3.2.1.4.5.5 الجامعة العربية المفتوحة
حل واجبات الجامعة العربية المفتوحة O54.4.3.2.1.4.5.5 - OO96654.4.3.2.1.4.5.5
ايميل : a_al_shora @ h.o.t.m.ail.c.o.m
سكايبي: a_al_shora
واتس اب: OO96654.4.0.5.0.8.9.7
Page 1 / 3
TU170
Tutor-marked Assignment – Summer 2014-2015
Cut-off date: -----------
Total marks: 20
Submitting your work
This TMA should be submitted to your tutor electronically through the LMS system before the
cut-off date indicated above. Please note that it is your responsibility to ensure that your work is
submitted in the correct format. Anything submitted after the midnight deadline will not count
for assessment purposes.
The TMA is marked out of 20, for the continuous assessment grade.
It consists of 4 questions. The total marks for each question are shown at the beginning of each
question. The marks allocated to each part of a question are indicated in the margin.
Plagiarism Warning:
As per AOU rules and regulations, all students are required to submit their own TMA work and
avoid plagiarism. The AOU has implemented sophisticated techniques for plagiarism detection.
You must provide all references in case you use and quote another person's work in your TMA.
You will be penalized for any act of plagiarism as per the AOU's rules and regulations.
Important note: Before you start working with this assignment, you need to refer to the
plagiarism tutorial posted in LMS.
By submitting the TMA through the LMS system, you are declaring that this submitted TMA work
is a result of your own efforts and you have not plagiarized any other person's work.
Arab Open University
Faculty of Computer Studies
TU170 Computing Essentials
Page 2 / 3
Part 1 [5 marks]
Use the common forum in LMS, in TU170 page, to initiate a discussion and to share your ideas with your classmates about one of the following topics:
Types of computers
Why browsers are needed when surfing the web
Computer’s memory
Cloud storage
Type of networks
You should provide screenshots (NOT copy and paste) of all the thread messages in your solution for this part. The thread must contain at least ten messages; five of them should be yours.
Part 2 [6 marks]
1. Define information system and its parts. [2 marks]
2. Discuss any three principals (guidelines) you may follow when sending an email. [2 marks]
3. Discuss the concept of illusion of anonymity that the internet brings. [2 marks]
For each question you must use your own words, within the range of 80-120 word count.
Part 3 [3 marks]
In your LMS, search the e-library using one of the keywords GUI, Webcasts or touch screens history.
For this part you are required to:
Copy at least two paragraph from any source selected. [0.5 mark]
Provide the reference of your source. It must be a link directing the user to the source. [0.5 mark]
Provide two screenshots of:
list of hits (the result that contains the keyword). [1 mark]
the source you have selected. [1 mark]
Page 3 / 3
Part 4 [2 marks]
Open your email (if you don’t have an email account, you can create a new one using one of the webmail providers such as Hotmail, Yahoo or Gmail). Send an email to your tutor’s email address describing what are the computer essentials, knowledge, skills that you gained from studying the course TU170. You should use your own words.
For this question, you should provide one screenshot of the email sent to your tutor.
Notes:
Sending an email to your tutor without providing a screenshot will not be counted when marking this question.
You should use your email account to send the email.
Minimum word count required for this part is 80.
TMA presentation [4 marks]
The TMA word document must satisfy the following:
Header contains student’s name and id
Page numbering
Page borders
No grammar and spelling mistakes
How to submit the TMA
Submit ONLY one word file contains your solution for this TMA
Name your TMA file as studentId_firstName_ surname
حل واجبات الجامعة العربية المفتوحة
حل واجبات الجامعه العربية المفتوحه مع الشرح
لجميع فروع الجامعة ولجميع التخصصات ولجميع المواد
الكويت البحرين عمان الأردن لبنان مصر البحرين حائل الرياض الدمام جدة المدينة المنورة الاحساء
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
الكويت البحرين عمان الأردن لبنان مصر البحرين حائل الرياض الدمام جدة المدينة المنورة الاحساء
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
حل واجب 0.5.4.4.3.2.1.4.5.5 الجامعة العربية المفتوحة
حل واجبات الجامعة العربية المفتوحة O54.4.3.2.1.4.5.5 - OO96654.4.3.2.1.4.5.5
ايميل : a_al_shora @ h.o.t.m.ail.c.o.m
سكايبي: a_al_shora
واتس اب: OO96654.4.0.5.0.8.9.7
Arab Open University
Faculty of Business Studies, KWB
T306A TMA- Summer 2015
Please read these instructions carefully. However, contact your tutor in case any difficulties with the instructions. You should submit your completed assignment to your tutor no later than July 25, 2015.
Please use standard A4 size paper for your TMA. Your name, personal identifier, course and assignment numbers must appear at the top of each sheet. Please leave wide margins and space at the end of each sheet for tutor comments. It is better to use double spacing so that you can easily handwrite corrections to your drafts and tutors have space to encourage with your points as you make them. Start each question in the assignment on a new page. Any extended text should ideally be word-processed, but, diagrams and accompanying notes may be hand drawn and you can use large sheets of paper.
Completing and sending your assignments
When you have completed each of your TMA, fill in an assignment form (PT3), taking care to enter correctly your personal identifier course and assignment numbers. Each TMA and its PT3 form should be sent to your tutor with your name, address and personal identifier written on it. Keep a copy of your TMA for security. The copy that is eventually returned to you after the assessment process will have comments written on it. All assignments are treated in strict confidence.
It is very important that you ensure that your tutor receives each assignment by the cut off date given. If you feel that you are unable to meet the cut-off date for any of the TMA, please contact your tutor as soon as possible to discuss your situation.
Plagiarism
You can score very well on this assignment using the materials provided as part of the course. However, if you have access to other sources of information such as reference books or the Internet, you may find it interesting to look there for additional relevant information. Very short extract from published sources may be included in context but you should avoid copying significant amounts of text from other authors. You should note that whilst the internet can provide lots of information much of it is not refereed and should be treated with caution.
If you take material from the course or elsewhere and incorporate it in your answer word-for-word, you must indicate where you have taken it from. Not to do so it termed ‘plagiarism’ and is regarded as an infringement of copyright. To attempt to pass off such work as your own is cheating.
You must therefore acknowledge all your sources of information.
Plagiarism will lead to a loss of marks and extensive plagiarism could mean that you fail this TMA. For more information about what constitutes plagiarism or cheating you should refer to the current Assessment Handbook.
General
There are three questions in this TMA at the end of this case study. You should answer them all. You should notice the mark allocations for each question and allocate your effort accordingly. Appropriate use of diagrams is expected throughout the TMA.
Read the following case and then answer all the questions that follow.
National Bank of Kuwait (NBK)
NBK was formed almost 60 years ago to meet the needs of the Kuwaiti business community. To ensure that it continues to be relevant, in recent years it has undergone a comprehensive IT facelift, a central part of which has been a total revamp of its BI system. Turning your back on customers can prove fatal. It’s hardly groundbreaking news, but sadly the world of commerce is littered with examples of those that ignored the blindingly obvious and paid the price. Legend has it that when the British Bank of the Middle East (BBME) in Kuwait rejected a prominent local merchant’s request to open a Letter of Guarantee for 10,000 Indian Rupees (which is equivalent today to about 750 KWD or $2600) it could hardly have expected what was to follow. The merchant was so infuriated by this apparently unreasonable refusal that he made sure the news spread far and wide. The response, following much discussion within the business community, was to form a national bank that would prioritise Kuwaiti needs and help the economic growth of the country. To this end, an Amiri decree was issued on 19th May 1952 to open the National Bank of Kuwait (NBK). It commenced operations six months later and is now the largest private sector institution in Kuwait, having built up market share of almost 40 per cent. BBME, on the other hand, was bought out by HSBC in 1959; the name was consigned to the history books, its new owner having steered it to a better place under the auspices of its Saudi British Bank affiliate group.
In 2009, Global Finance magazine named NBK as one of the world’s 50 safest banks. In pure financial terms, by year-end 2008, it was posting $10.27 billion of assets under management and claimed a market capitalisation of $11.2 billion.
Its banking activities have grown to cover all areas, including retail banking, corporate banking and international trade, as well as investment banking and private banking. Products and services are managed through NBK’s homeland HQ and branches and its network of subsidiaries in 14 countries across the Middle East, Africa, Europe, North America and South East Asia.
NBK intends to keep hold of its credibility, mindful of what can happen, directly or indirectly, at the hands of poor customer service, and has gone out of its way to deliver an enterprise-wide data system to keep it on track.
An important milestone – and the turning point for NBK’s IT strategy – revealed it in 2003, recalls Hani Khalil, enterprise architect for NBK’s IT division. It started, he says, with the realisation that NBK needed to replace its core business and technology systems, the awareness of a systems shortfall at that time fuelled by the possibilities being afforded to go-ahead banks by the economic boom and expansion of financial markets globally. ‘Our priorities, or shall I say our dependencies, were evolved from our core strategy and vision to revamp our core capabilities,’ explains Khalil. Indeed, given NBK group’s mission to establish a leadership position across the region, it initiated an enterprise transformation project – codenamed Shorouq (Arabic for sunrise) – to revamp its business processes and IT infrastructure. The IT transformation project would include a full revamp of its core systems and, pertinent to its customer focus, all associated decision support tools – with more than a passing nod to Business Intelligence (BI). ‘The Shorouq programme was envisaged as a long-term enterprise technology architecture and IT strategy,’ notes Khalil. NBK has a full project roadmap that started in 2004 and will run until 2012 for application and data related projects. ‘As part of the programme, we formed an enterprise programme division to deliver this project in four major phases.’ The decision was taken to use a partner model to support this delivery, bringing in specialist application and technology vendors where required. Each element of Shorouq was aligned with the overall NBK business strategy.
Following intense discussion, the resultant enterprise architecture plan comprised three main streams as enablers for achieving the IT strategy: core system changes; the building of an SOA-driven integration platform; and the delivery of a BI system as part of fluid information architecture. A new Operational Data Store (ODS) – effectively a data warehouse – would consolidate data from across the enterprise and provide NBK with the ability to drive all of its enterprise BI and information requirements, and support all decisions out of one place. Befitting a bank that knew what it wanted, the project had a definite modus operandi from the word go. ‘As a part of Shorouq, we strategically decided to run all three streams in parallel, as opposed to the conventional waterfall approach of first implementing the integration platform, then implementing the core system, and finally investing in BI strategies and tools,’ says Khalil. NBK chose a number of vendors to cover the three project areas ‘as enablers for this journey’. India-based BI solutions specialist, iCreate was drafted in to help form and execute the BI strategy. iCreate was chosen because it had ‘knowledge and experience in the core banking system space – especially in the emerging market context – as well as the BI aspects of a bank’, explains Khalil. ‘This helped us keep the BI streams in line with all other critical tracks.’ iCreate, he adds, was ‘essential in delivering this successful vision’. Praise indeed, but success in this field comes with hard work from all parties. Unsurprisingly, the team had a clear target in sight. The existing system, prior to the Shorouq initiative, was completely ‘locked in’ to a mainframe platform which, over time, had become ‘a home for many custom applications’, serving the changing business needs of the bank. ‘The applications and systems were in a state where maintenance and further enhancements were becoming costly and slow,’ admits Khalil. The desire for NBK to grow required the implementation of what he describes as solutions based on ‘industry-standard best practices’. The key systems that were identified as being in need of full replacement were the core retail banking solution, trade finance, payment cards and the general ledger. ‘The decision to implement specialist systems for each of these functions brought with it a challenge of data consolidation,’ notes Khalil. In fact, the need to run a complementary BI programme to consolidate data across the systems was, in part, born out of the realisation that these specialist systems would not necessarily integrate at a data level, nor therefore align with NBK’s vision of enterprise-wide BI. However, implementing individual specialist components ‘allowed us to carry out the BI initiative in a piecemeal approach, yet still based on a solid foundation for achieving the final vision for NBK’s BI,’ explains Khalil. That vision, he adds, was to ensure that data quality and high availability could be maintained, to enable effective business operations, decision-making and reporting. ‘I can say that our key drivers within the BI initiative were good risk management, customer-centric marketing, increased demand of regulatory reporting and the integration of the regional branches of NBK. In NBK terminology, what was being sought was the single version of the truth.’ In order to make real this vision, Khalil’s team evaluated a number of BI technology options and, in consultation with iCreate, finally decided to deploy the Microsoft-based BI toolset because of its ‘low total cost of ownership’, as well as the fact that it would align with NBK’s strategy for channel and data management. SAP Business Objects software was also chosen to cover operational reporting as the vendor’s distribution and access were felt to be in line with the needs of the bank. With the various strands of the project getting underway simultaneously, iCreate’s knowledge of core banking systems was tested straight away, needing to source the data from the multiple systems to feed the BI initiative and, of course, the ODS. ‘We worked with iCreate to build the BI infrastructure and foundation,’ explains Khalil. ‘Some of these frameworks in the BI space are now found in the ODS, the retail banking data marts, and the enterprise reporting and distribution – and we had additional help from them in building data-related architectural components.’ Khalil comments that NBK’s partnership with iCreate has enabled the ‘seamless integration’ of the bank’s various systems for core banking, trade finance, card management, and legacy mainframe banking – along with a variety of other departmental systems – into the single enterprise ODS. The ODS was deployed on an MS SQL server. ‘We have used the ETL [extract, transform, load] tools within the SQL server umbrella to enable this project and, of course, we use the SAP Business Objects tools for reporting and distribution of information,’ he notes, clearly quite satisfied with the progress.
One of the first tasks from phase one, starting in Q2 2005 and completing in Q4 2005, was to migrate core data from NBK’s legacy applications to the new ODS using the ETL tool. This, says Khalil, was to ensure that all data was streamlined into the bank’s daily operations. Phase one of the migration continued with the ETL of existing management, operational and regulatory reporting data from those legacy systems to the new ODS. This duly started in Q1 2006 and was completed in Q4 that same year. The second project phase continued the migration into the ODS of all management, operational and regulatory reporting data from legacy systems but also covered ETL of data into the ODS from the other systems newly implemented under Shorouq. As well as TCS’s Bancs, the list included ACI’s Base24 EFTPOS and card system, and the CSI Banktrade trade finance system. This started in Q4 2006 and completed in Q2 2007. An enterprise-wide deployment of the SAP Business Objects solution for users was completed for the majority of the user community in Q1 2007, having kicked off in Q1 2005. From Q2 2007 to Q4 2007, the streamlining of the daily extract operations was carried out. From Q1 2008 to the end of the year, a data mart project was formally established to lay down the Management Information Systems (MIS) framework and platform. This included a complete enterprise data model for the delivery of consumer retail products and the customer mart, with data extraction from the legacy ODS side and from the new ODS. ‘This helps us ensure data consistency and integrity between the current operational data and final migrated data in the last phase of the programme,’ explains Khalil. The first two major project phases have now been delivered, with iCreate having played a major guiding role in each of these. An additional project milestone is expected to be delivered by the middle of this year, with the last of the four scheduled phases due for completion before the end of the year. The data integration project has had its share of challenges, but Khalil states that the team has been able to overcome each one ‘without any significant impacts on timelines or cost’. As an example of an area where matters could have come unstuck, he recalls that the legacy systems and their lack of proper documentation ‘formed a hurdle to the speed of analysis and transformation into the new models of technologies’. However, he notes, ‘using various techniques such as reverse engineering and ground-up analysis helped us overcomes these issues’. In terms of delivery of usable BI, NBK has successfully put in place processes to roll out functional solutions for its various user groups within the organisation. It has carried out a controlled roll out in the consumer banking group – ‘with good results’, claims Khalil. ‘We have more plans with the consumer banking group and other groups such as credit and corporate banking as well as risk management,’ he adds. The strategy of roll-out started with the main locations and then expanded to include all regional offices. Currently, the majority of systems are live in all country locations with ‘limited functionality’.
The project team continues to keep a close eye on performance as data volumes increase. In response, it makes ‘minor modifications to continuously improve the performance of the system’. So far, states Khalil, ‘we have not discovered any major deficiencies or limitations’. This good fortune he primarily attributes to ‘the rigorous technical design and planning that the team went through’. He adds that NBK and its technology team are sure that there is more to come from the system in terms of the final vision of making the bank’s systems and infrastructure agile and responsive to all market changes. In terms of overall project progress to date, Khalil says that ‘we have successfully managed to stay on course with our vision’. TCS Bancs, for example, is live on some of the modules (including loans and term deposits and a partial realisation of the CIF). By the end of June it is anticipated that NBK should be live with everything else in this strand, bar the corporate lending module. In the BI zone, whilst some elements are still to be rolled out, Khalil notes that what has been done to date ‘is already starting to exceed the expectations’ of the user community. ‘As we are still in the penultimate phase of implementation, the focus is more on delivering functionality and easing roll-out pains, rather than on performance or other such system health indicators,’ he explains. ‘However, we will review the completeness of our solution and implementation with each passing phase.’ The bank will validate the outcome and continue to compare and contrast usable functions to expected results. It will also be looking for the all-important ROI. To continue the journey, Khalil believes that working with trusted and experienced partners ‘such as iCreate’ in the area of BI is the right strategy. In this way, NBK’s banking personnel can continue to focus on their core business while NBK’s technology and implementation partners are able to get on with the implementation of the vision and strategy for enterprise technology.
Questions:
1. Critique the relevance and suitability of hard or soft approach in highlighting issues faced by NBK about 600 words. (20% marks)
2. Apply the Hard Systems Method (HSM) to this NBK situation case, including spray diagram, systems map, and multiple-cause diagram. Analyse and make suitable recommendations about 1500 words. (60% marks)
3. Investigate further suitable approaches and tools that could be used to investigate, illustrate and make recommendation to solving problems. Please consult all your course materials and undertake relevant literature search about 600 words. (20% marks)
حل واجبات الجامعة العربية المفتوحة
حل واجبات الجامعه العربية المفتوحه مع الشرح
لجميع فروع الجامعة ولجميع التخصصات ولجميع المواد
الكويت البحرين عمان الأردن لبنان مصر البحرين حائل الرياض الدمام جدة المدينة المنورة الاحساء
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
الكويت البحرين عمان الأردن لبنان مصر البحرين حائل الرياض الدمام جدة المدينة المنورة الاحساء
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
Plagiarism Warning:
As per AOU rules and regulations, all students are required to submit their own TMA work and avoid plagiarism. The AOU has implemented sophisticated techniques for plagiarism detection. You must provide all references in case you use and quote another person's work in your TMA. You will be penalized for any act of plagiarism as per the AOU's rules and regulations.
Declaration of No Plagiarism by Student (to be signed and submitted by student with TMA work):
I hereby declare that this submitted TMA work is a result of my own efforts and I have not plagiarized any other person's work. I have provided all references of information that I have used and quoted in my TMA work.
Name of Student:………………………………..
Signature:…………………………………………...
Date:……………………………………………………
Question One (10 marks)
1) (Based on Block 1) consider description of a Smart Navigation System ICT and then draw a detailed block diagram for it?
A vehicle has an onboard unit (which contains a GPS receiver, a voice simulator and others). The GPS receiver communicated with four GPs Satellites for locating vehicle location purposes by receiving signals from the satellites.
To use the Smart Navigation System the driver alerts the control center by pressing a button on the dashboard to speak to a human adviser in the control center. The driver informs the adviser of the required destination, and the vehicle’s current location is transmitted to the computer in the control center via the mobile network.
The on-board unit has a GPS receiver and a link to the control center via a mobile phone network. The computer plots a route, which is sent to the on-board unit via the mobile phone link.
Control center uses a network of ANPR cameras along major roads. Data from these enables the control center to maintain a database of the current state of traffic flow on most of the major roads and motorways in the country. The route that is sent to the vehicle takes account of prevailing traffic conditions.
As the driver drives along the route that has been sent from the control center, the on-board GPS receiver monitors the car’s position so that appropriate instructions can be given. Modifications to the route can be issued during the journey if, for instance, the driver misses a turning or new traffic conditions emerges.
The following figure describes the system.
(5 marks)
Hint: consider the computer in the control center in addition to all other equipment as one subsystem in your diagram. Also consider the onboard unit in the vehicle with its entire component as one subsystem in the block diagram.
2) In your house there are:
• A scanner that is connected to a laptop via cable.
• A mobile that is connected to another mobile via a Bluetooth link
• An RFID Reader in the kitchen which interrogates items about their expiration date.
• An AC controlled by a remote control.
• The laptop, mobiles, RFID reader, and AC are all part of the Zigbee network which contains a network coordinator.
Draw a detailed system map for the description above? (5 marks)
Question Two (10 marks)
In Block 2 Part 3 you learnt about many wireless technologies, but still there is more. Microwaves are a type of electromagnetic radiation. Search the web to answer the following:
1) What is the frequency band of the Microwaves? (1 mark)
2) List four properties of microwaves. (2 marks)
3) List four uses of Microwaves. (2 mark)
4) Choose one of the uses you mentioned in the answer of question c and write 60-80 words about it.(2 marks)
5) List two effect of microwave on our health. (1 mark)
6) List two URLs of the web pages you used. (Wikipedia is not counted) (2 marks)
حل واجبات الجامعة العربية المفتوحة
حل واجبات الجامعه العربية المفتوحه مع الشرح
لجميع فروع الجامعة ولجميع التخصصات ولجميع المواد
الكويت البحرين عمان الأردن لبنان مصر البحرين حائل الرياض الدمام جدة المدينة المنورة الاحساء
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
الكويت البحرين عمان الأردن لبنان مصر البحرين حائل الرياض الدمام جدة المدينة المنورة الاحساء
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
حل واجب 0.5.4.4.3.2.1.4.5.5 الجامعة العربية المفتوحة
حل واجبات الجامعة العربية المفتوحة O54.4.3.2.1.4.5.5 - OO96654.4.3.2.1.4.5.5
ايميل : a_al_shora @ h.o.t.m.ail.c.o.m
سكايبي: a_al_shora
واتس اب: OO96654.4.0.5.0.8.9.7
Faculty of Business Studies
Tutor Marked Assignment
B301 B: Making Sense of Strategy II
Summer 2014 – 2015
This tutor marked-assignment is meant to assess the student’s ability in understanding, and application of the course materials provided in the class room and ideas from external sources, as well as to test his/her reflection and critical thinking. Among other ILOs, it is also intended to test the student’s ability to argue relevantly and to justify a point of view besides, constructing, defending and evaluating an argument, using relevant evidence and giving reasons for conclusions. It accounts for 20% of the total grade assigned to the course
INSTRUCTIONS
The TMA must be done with strict compliance to the guidelines and instructions stated, otherwise there will be penalties in form of marks deduction as per the university’s policy.
You are encouraged to collaborate with others in studying, but submitted work copied from or written jointly with others is not acceptable. Submitting work that has been done by someone else and persistent borrowing of other people’s work without citation are obvious instances of plagiarism and are regarded as cheating. Paying for work from other sources and submitting it as your own is also cheating. It is intellectually dishonest to cheat. If a case of plagiarism is proven, this is a serious offence and the disciplinary procedures will be followed, as described under the Examination Policy of the AOU. Cases of plagiarism will receive a mark of “Zero” on the assignment. Please refer to AOU plagiarism policy.
1. TMA must be written in ESSAY format, BULLETS and NUMBERING to be avoided. Avoid writing TMA in first person tense. E.g. “I suggest that …” or “In this TMA I am going to discuss…”etc.
2. Word count should be exact with 10% (More/less) tolerance.
3. You must acknowledge all sources of information using full Harvard Style Referencing (In-text referencing plus list of references at the end) Minimum of 5 references are required. MUST include E-library and course materials.
4. Wikipedia is not recommended as a reference.
5. Copy and paste- plagiarized work will be detected by TURNITIN and heavily penalized.
6. TMAs to tutors through emails and late submission not permitted.
7. Strictly use the PT3 form with green color mark accompanying this TMA.
Any other non compliance to guidelines and requirements will be penalized
WARNING: THERE WILL BE NO EXTENSION OF CUT-OFF DATE UNDER ANY CIRCUMSTANCE.
Please Note that this particular TMA is meant to respond to recommendations given by EE to encourage and develop greater critical analytical skills especially at level 6, by encouraging the students to read more widely; the greater use of comparative case studies; and encouraging part-time students to reflect on the application of the theories discussed to their own workplace.
Question
You are required to critically analyze and discuss how the government of your country has established and operates its Petroleum /Oil industry by using the Diamond of National Advantage.
**Note: Your discussion must comprise of ALL the four determinants of national competitive advantage
(1500 Words)
(Bahrain, Jordan, Lebanon, Kuwait, Oman, Saudi Arabia, Egypt or Sudan) Reference may be made to Readings for Block 3.Readings 12,
***************** Good Luck *********************
حل واجبات الجامعة العربية المفتوحة
حل واجبات الجامعه العربية المفتوحه مع الشرح
لجميع فروع الجامعة ولجميع التخصصات ولجميع المواد
الكويت البحرين عمان الأردن لبنان مصر البحرين حائل الرياض الدمام جدة المدينة المنورة الاحساء
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
الكويت البحرين عمان الأردن لبنان مصر البحرين حائل الرياض الدمام جدة المدينة المنورة الاحساء
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
Plagiarism Warning:
As per AOU rules and regulations, all students are required to submit their own TMA work and avoid plagiarism. The AOU has implemented sophisticated techniques for plagiarism detection. You must provide all references in case you use and quote another person's work in your TMA. You will be penalized for any act of plagiarism as per the AOU's rules and regulations.
Declaration of No Plagiarism by Student (to be signed and submitted by student with TMA work):
I hereby declare that this submitted TMA work is a result of my own efforts and I have not plagiarized any other person's work. I have provided all references of information that I have used and quoted in my TMA work.
Name of Student:
Signature:
Date:
Question 1 [20 marks]
Using the AOU e-Library, go to the “IEEE Computer Society” sub-library and search for the article “Performance Comparison of Web Service Engines in PHP, Java and C”. You should find the article among the first few results.
Download the pdf version of the document and skim through it.
Write a brief summary of what is written under section 5 as a comparison of PHP and Java with respect to robustness, portability, efficiency, and speed of XML parsing. The summary should be one paragraph with a maximum word count of 200 words.
[20 marks]
Question 2 [35 marks]
Write a PHP code to create a multi-dimensional array about AOU courses. In PHP it is an array of arrays. Each inner array should have only 2 items, a level and a string of course names separated by commas. Such as:
level => 1
courses => M180,M150A,M105
You need to create at least 3 levels with a minimum of 3 courses per level.
Note: to understand the multi-dimensional arrays, review Listing 8.1 (page 142) in the book.
[10 marks]
Your script should generate HTML in the form of a header for the level of the courses and an un-ordered list for listing the courses similar to the following output.
Note: You can use explode() [Page 179, or check it online] on how to convert a string of values separated by commas into an array, so that you can loop it and generate each index as a separate HTML list item.
[25 marks]
Question 3 [45 marks]
Write SQL queries for each of the following parts:
a- Create the table drivers with fields (driver_id as int, driver_name as varchar(60), driver_age as int)
[3 marks]
b- Create the table cars with fields (car_number as int, car_color as varchar(15))
[3 marks]
c- Create the table drivenby with fields (driver_id as int, car_number as int)
[3 marks]
d- Insert into each table the following values:
drivers
driver_id driver_name driver_age
12 Fred Racer 21
15 Ahmad Taxi 33
16 Georges Beetle 48
20 Ali Drifter 24
[3 marks]
cars
car_number car_color
671 Yellow
189 Purple
325 Orange
217 Blue
310 Green
[3 marks]
drivenby
driver_id car_number
15 217
20 189
16 671
[3 marks]
e- (select) Retrieve all the drivers whose age < 25
[4 marks]
f- (select) Retrieve all the car_color ordered by car_number in descending order
[4 marks]
g- (select) Retrieve using join between the tables drivers and drivenby the car_number and respective age
[5 marks]
h- (select) Retrieve using join between drivers and drivenby the driver names who are driving a car
[5 marks]
i- Update table drivers to increase the age of all drivers by 1
[4 marks]
j- Delete all the cars whose car number is between 150 and 250
[5 marks]
End of the Questions
حل واجبات الجامعة العربية المفتوحة
حل واجبات الجامعه العربية المفتوحه مع الشرح
لجميع فروع الجامعة ولجميع التخصصات ولجميع المواد
الكويت البحرين عمان الأردن لبنان مصر البحرين حائل الرياض الدمام جدة المدينة المنورة الاحساء
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
رد مع اقتباس