حلول واجبات الجامعة العربية المفتوحة المضمونة AOU

حلول واجبات الجامعة العربية المفتوحة لجميع تخصصات الجامعة ولجميع فروع الجامعة حلول واجبات – مشاريع تخرج – ملخصات هامة Mobile: 00966542495275 حلول واجبات الجامعة ا
 
الرئيسيةالرئيسية  س .و .جس .و .ج  بحـثبحـث  الأعضاءالأعضاء  المجموعاتالمجموعات  التسجيلالتسجيل  دخول  

شاطر | 
 

 Faculty of Computer Studies M275 Web Development Using PHP and MySQL Tutor Marked Assignment – Fall Semester 2017/2018 Cut-Off Date: TBA Total Marks: 100 Contents This TMA consists of 3 questions, where you are required to answer all of the questions. Th

استعرض الموضوع السابق استعرض الموضوع التالي اذهب الى الأسفل 
كاتب الموضوعرسالة
whatsapp::00966542495275
Admin


المساهمات : 2451
تاريخ التسجيل : 23/01/2012

مُساهمةموضوع: Faculty of Computer Studies M275 Web Development Using PHP and MySQL Tutor Marked Assignment – Fall Semester 2017/2018 Cut-Off Date: TBA Total Marks: 100 Contents This TMA consists of 3 questions, where you are required to answer all of the questions. Th   الأحد نوفمبر 19, 2017 11:53 pm

Faculty of Computer Studies M275 Web Development Using PHP and MySQL
Tutor Marked Assignment – Fall Semester 2017/2018

Cut-Off Date: TBA Total Marks: 100
Contents This TMA consists of 3 questions, where you are required to answer all of the questions. The TMA will be corrected by your tutor and you will be provided with a proper feedback file to understand your mistakes and avoid them on the final exam.


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:

M275 – TMA Page 2 of 4 2017-2018 / Fall
Question 1 [20 Marks]
Using the AOU e-Library or other online sources, search for and briefly discuss at least 3 advantages and 1 disadvantage of using PHP’s mysqli library over using PHP’s mysql library. Make sure to state the reference (where the info was gathered) in order to receive a full mark.


Question 2 [50 Marks]
This question is based on the “guessing machine” (Chapter 11) that was discussed during the tutorials.
You are asked to implement the PHP and HTML code that will complete the program below. The program is mainly a guessing game to try and guess a random, odd number between 1 and 99. Each time the user guesses the number, a new number is provided.


Here is a sample run with explanations that are followed by some hints:

For the first visit, the user will be presented with a welcome message and some info on what to guess.
The user enters 20.
The user is presented with a message that 20 is odd. He changed it to 25.

M275 – TMA Page 3 of 4 2017-2018 / Fall
The user is presented with a message that 25 is small and he tries 35.
The user is presented with a message that 35 is big and he tries 31
The user’s guess is correct and the game continues with a new random odd number.

Hints:

 rand (1, 99) provides a number between 1 and 99 including both odd and even numbers.

 $x = $x | 1 The “|” is used to perform bitwise or between $x and 1 which is used to convert $x to an odd number in case it was even.

 You might need to keep track of the random number the user is trying to guess using the following line of code:
Note: The sample run in the table above demonstrated the 5 different messages that are to be presented to the user.
M275 – TMA Page 4 of 4 2017-2018 / Fall
Question 3 [30 Marks]
Writing SQL queries: Read the section “Using Join” of Chapter 16 in the book (pages 312 -> 314 in the fifth edition) then answer the questions below:
Consider the following tables:
students student_id firstname lastname 123 Some One 125 Another One 167 Good Student
grades student_id gpa 123 2.34 125 3.21 167 3.86


a- Write an SQL queries that would create the tables students and grades based on the tables above.
b- Write SQL insert queries to add the data into the tables as it is presented in the tables above.
c- Write an SQL select query to find the honors students (whose GPA is above 3.5) Note: You might need to search online for the MySQL built-in function “LEFT” and use it with the function “CONCAT” to generate the name of the student as the following table:
name gpa G. Student 3.86




End of the Questions

_________________
الإجــابة النمــوذجية
----------------------
[عزيزي الزائر يتوجب عليك التسجيل لمشاهدة الإجابة النموذجية ، للتسجيل اضغط هنا]


Watsapp: 00966542495275

خدمات مجانية – حلول واجبات الجامعة العربية المفتوحة
لجميع تخصصات الجامعة ولجميع فروع الجامعة
حلول واجبات – مشاريع تخرج – ملخصات هامة
http://learning.123.st/
http://aoua.forumegypt.net/
http://tarbawy.123.st/


Watsapp: 00966542495275

smsm.hamdy66@yahoo.com
حلول مضمونة وغير مكررة وغير متشابهة لجميع واجبات الجامعة
متوفرمدرسين ومدرسات لجميع المواد والتخصصات
KSA-Kuwait-Bahrain-Oman-Jordon-Lebanon-Egypt
الرجوع الى أعلى الصفحة اذهب الى الأسفل
معاينة صفحة البيانات الشخصي للعضو http://learning.123.st
 
Faculty of Computer Studies M275 Web Development Using PHP and MySQL Tutor Marked Assignment – Fall Semester 2017/2018 Cut-Off Date: TBA Total Marks: 100 Contents This TMA consists of 3 questions, where you are required to answer all of the questions. Th
استعرض الموضوع السابق استعرض الموضوع التالي الرجوع الى أعلى الصفحة 
صفحة 1 من اصل 1
 مواضيع مماثلة
-
» خطط التحسن ونظم المتابعة لجميع المجالات2016/2017
» تشكيل لجنة لإعداد ملف لاستضافة المغرب لأمم إفريقيا عام 2015 أو 2017
» الخطوات والبنود التي تتم بها مراجعة وتدقيق الجداول الزمنية
» شرح ال Yes\No Question
» الإصدار النهائي مع الكيجن Total Recall v3.0.3

صلاحيات هذا المنتدى:لاتستطيع الرد على المواضيع في هذا المنتدى
حلول واجبات الجامعة العربية المفتوحة المضمونة AOU :: حلول واجبات الجامعه العربيه المفتوحه 2017/2018 fall :: منتدى حل الواجبات-
انتقل الى: