aou حل واجبات الجامعه العربيه المفتوحه2017/2018
الرئيسيةالرئيسية  اليوميةاليومية  س .و .جس .و .ج  بحـثبحـث  الأعضاءالأعضاء  المجموعاتالمجموعات  التسجيلالتسجيل  دخول  

شاطر | 

  حل واجب M275

اذهب الى الأسفل 
كاتب الموضوعرسالة

المساهمات : 153
تاريخ التسجيل : 22/08/2016

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

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

Cut-Off Date: TBA Total Marks: 100

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:

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://wagbat-123.a7larab.net
حل واجب M275
الرجوع الى أعلى الصفحة 
صفحة 1 من اصل 1

صلاحيات هذا المنتدى:لاتستطيع الرد على المواضيع في هذا المنتدى
wagbat.123 :: حل واجبات الجامعه العربيه المفتوحه whats.app: 00966542495275 :: حلول واجبات 2017/2018 AOU(يشاهدة الآن 3537 زائر)-
انتقل الى: