حلول واجبات الجامعة العربية المفتوحة (لعــspring2015ـــام)

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

شاطر | 
 

  حل واجب M275

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


عدد المساهمات : 1343
تاريخ التسجيل : 07/10/2014

مُساهمةموضوع: حل واجب M275   الجمعة أغسطس 26, 2016 10:46 pm

Faculty of Computer Studies
M275
Web Development Using PHP and MySQL
Tutor Marked Assignment – Third Semester 2015/2016

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:

Question 1 [20 Marks]

Using the AOU e-Library, go to the “DOAJ (Directory of Open Access Journals)” sub-library and search for the term MySQL. Among the first few results you should find a link to the article “On-Line Tests”.

Open/Download the article and answer the following question:

In section 3 “The connecting-up to the database” the author discussed some functions that will be used to create a connection to MySQL and present errors if the connection failed.
- Briefly state the 3 functions used and what each of them is used for. (Note: the author of the article used the mysql_ set of functions and not the mysqli_ set of functions.
[15 Marks]

- State the name of the file that was created to include the connection code and the PHP statement(s) used to import the connection library.
[5 Marks]


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 practice tool to guess prime numbers.

Here is a sample run with explanations:

The user is presented with the first prime number and a form to try and guess a bigger prime

With each submission, the program determines if the number is bigger than the current prime and the checks if it is a prime or not.

The user is challenged to keep guessing a bigger prime, until he decides to stop playing.



Question 3 [30 Marks]

Given the following un-normalized table:

id name GPA Course1 Grade1 Course2 Grade2 Course3 Grade3

Using the learnt Normalization rules, create a well normalized set of tables adding necessary primary keys for the given un-normalized table. Adding some explanation is necessary to justify your tables.

Note: There is no need for SQL queries or relationship type, just table fields and justification


End of the Questions

_________________
الإجــابة النمــوذجية
----------------------

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






خدمات مجانية – حلول واجبات الجامعة العربية المفتوحة
لجميع تخصصات الجامعة ولجميع فروع الجامعة
حلول واجبات – مشاريع تخرج – ملخصات هامة
http://learn.123.st/
Mobile: 00966544321455  or 0544321455
Watsapp: 00966544321455

a_al_shora@hotmail.com
حلول مضمونة وغير مكررة وغير متشابهة لجميع واجبات الجامعة
متوفرمدرسين ومدرسات لجميع المواد والتخصصات
KSA-Kuwait-Bahrain-Oman-Jordon-Lebanon-Egypt
الرجوع الى أعلى الصفحة اذهب الى الأسفل
معاينة صفحة البيانات الشخصي للعضو http://learn.123.st
 
حل واجب M275
استعرض الموضوع السابق استعرض الموضوع التالي الرجوع الى أعلى الصفحة 
صفحة 1 من اصل 1

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