منتديات طلاب الجامعات - والجامعة العربية المفتوحة
مشاريع التخرج - حل الواجبات - جميع الجامعات
شرح كورسات - مراجعات - فيديوهات - مراجعات قبل الامتحانات
حلول واجبات الجامعة العربية المفتوحة
لجميع تخصصات الجامعة ولجميع فروع الجامعة
حلول واجبات – مشاريع تخرج – ملخصات هامة
00966590355976 :WhatsٍِِِApp
WhatsٍِِِApp: 00201102862484
professor.tma@gmail.com
حلول مضمونة وغير مكررة وغير متشابهة لجميع واجبات الجامعة
متوفرمدرسين ومدرسات لجميع المواد والتخصصات
KSA-Kuwait-Bahrain-Oman-Jordon-Lebanon-Egypt

منتديات طلاب الجامعات - والجامعة العربية المفتوحة

مشاريع التخرج - حل واجبات الجامعات - الجامعة العربية المفتوحة - الجامعة السعودية الالكترونية - مع الشرح لكل واجب
 
الرئيسيةالبوابةس .و .جبحـثالأعضاءالمجموعاتالتسجيلدخول

مع أفضل نخبة من الاساتذة والمهندسين - حل واجبات - شرح اونلاين - ملخصات - مراجعات - مشاريع تخرج - الجامعة العربية المفتوحة بجميع فروعها - الجامعة السعودية الالكترونية - جامعة الملك فيص وجامعة الملك فهد وجامعة ام القرى وجامعة السلطان قابوس وجامعة الملك فهد

شاطر | 
 

 حل واجب M275 Fall 2018

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

عدد المساهمات : 1661
تاريخ التسجيل : 06/02/2012

مُساهمةموضوع: حل واجب M275 Fall 2018   السبت أكتوبر 13, 2018 6:24 pm

In this question you are required to develop a simple software system that will generate simple arithmetic test. The generated test will be conducted through a web page; this test consists of 4 simple problems about addition, subtraction, multiplication and division. Each problem consists of two integer operands and the user should find out the answers of these problems. The problems of the test should be generated randomly. The test is developed for students of grade-2.
The software system should be implemented by using HTML tags and PHP codes. The final code with 2 snapshots should be provided in your answer sheet.
The software system has the following specifications:
1- The system starts with browsing a web page with:
a. suitable title,
b. header,
c. empty textboxes for holding the addition, subtraction, multiplication and division operands,
d. empty textboxes for holding the sum, difference, product and quotient of the two operands
e. two buttons for starting and marking the test.
Note:
The design and the layout of the web page are left intentionally for the student to show his/her creativity in this part.
2- Once the user presses on the start button, the test starts by generating one adding problem, one subtracting problem, one multiplying problem and one dividing problem and placing the operands in the allocated textboxes in the web page.

The generated test should satisfy the following 5 conditions:
a. The test consists of 4 different problems that generated randomly.
b. Addition problem consists of two operands between 0 and 100 inclusive and not involves any carry operation.
The following table shows some invalid examples that should be avoided in the generated test:
33 + 105 = Invalid because the second operand is greater than 100
26 + 47 = Invalid because this problem requires the carry operation
c. Subtraction problem consist of two operands between 0 and 100 inclusive and not involves any borrow operation. The first operand should be greater than the second operand. All questions will not.
The following table shows some invalid examples that should be avoided in the generated test:
33 - 70 = Invalid because the second operand is greater than the first operand.
76 - 47 = Invalid because this problem requires the borrow operation
d. Multiplication problem consist of two operands between 0 and 10 inclusive.
The following table shows some invalid examples that should be avoided in the generated test:
12 X 7 = Invalid because the first operand is greater than 10.
6 X 11 = Invalid because the second operand is greater than 10.
e. Division problem consist of two operands between 1 and 100 inclusive, the quotient should be an integer number and the first operand should be greater than the second operand.
The following table shows some invalid examples that should be avoided in the generated test:
112 ÷ 7 = Invalid because the first operand is greater than 100.
6 ÷ 12 = Invalid because the second operand is greater than the first operand.
50 ÷ 7 = Invalid because the quotient is not integer.
3- The user should find out the answer of each question, and enters the result in the allocated textboxes in the web page.
4- Once the user presses on the 'Mark' button, the system returns the result of the test. The user will earn 2.5 marks for each correct answer and zero for wrong and questions left without answers.  
5- The user can start another test by pressing on the 'Start' button.

Question-2 [20 marks]
Bahrain Business students' association in AOU keeps some information about students' sport activities and the fees per semester to do that activity. This information is saved in Excel sheet as shown below.
Student Activity-1 Cost Activity-2 Cost
Hala Mahmood Walking 20JD
Qusay Salman Tennis 55JD Netball 20JD
Yaqoub Naser Tennis 55JD Walking 20JD
Sara Hani Walking 20JD Swimming 40JD
Hala Mahmood Swimming 40JD
Leen Ahmad Walking 20JD Netball 20JD
Ammar Ayman Netball 20JD Tennis 55JD
Omar Ali Basketball 33JD
Sara Hani Swimming 40JD
This sheet does not satisfy the basic design' rules of database. In this question, as a database designer/developer, you are requested to:
1- Determine the basic database design' rules that were not satisfied in the previous Excel sheet.
2- Develop a new database design for the information saved in the previous Excel sheet so that all mistakes and violations made in the previous design will be removed and the new design satisfies the third normal form.

Question-3 [30 marks]
'driver' and 'car' are names of two tables in the insurance database system. By using MySQL server, the following SQL statements were executed, in the same order given below, to implement 'driver' and 'car' tables with data.  
CREATE TABLE driver (
driverID INT NOT NULL PRIMARY KEY,
name VARCHAR(30) NOT NULL,
cityAddress VARCHAR(25)
);
CREATE TABLE car (
plateID CHAR(6) NOT NULL PRIMARY KEY,
model VARCHAR(20) NOT NULL,
driverID INT NOT NULL
);
INSERT INTO driver VALUES ('111', 'Ahmad', 'Madaba');
INSERT INTO driver VALUES ('222', 'Mazen', 'Zarqa');
INSERT INTO car VALUES ('111aaa', 'Toyota', '222');
INSERT INTO car VALUES ('222bbb', 'Nissan', '111');
INSERT INTO car VALUES ('333ccc', 'Mitsubishi', '111');
Based on the above information, answer the following 4 questions:
1- Write two different SQL statements to generate the table below from the insurance database system:
driverID name cityAdress plateID model driverID
222 Mazen Zarqa 111aaa Toyota 222
111 Ahmad Madaba 222bbb Nissan 111
111 Ahmad Madaba 333ccc Mitsubishi 111
2- Write two different SQL statements to generate the table below from the insurance database system:
plateID model name cityAdress
111aaa Toyota Ahmad Madaba
111aaa Toyota Mazen Zarqa
222bbb Nissan Ahmad Madaba
222bbb Nissan Mazen Zarqa
333ccc Mitsubishi Ahmad Madaba
333ccc Mitsubishi Mazen Zarqa
3- Write two different SQL statements to generate the table below from the insurance database system:
plateID name cityAdress
111aaa Mazen Zarqa
222bbb Ahmad Madaba
333ccc Ahmad Madaba
4- Write two different SQL statements to generate the table below from the insurance database system:
name plateID model
Ahmad 111aaa Toyota
Mazen 111aaa Toyota
Ahmad 222bbb Nissan
Mazen 222bbb Nissan
Ahmad 333ccc Mitsubishi
Mazen 333ccc Mitsubishi



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

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






خدمات مجانية – حلول واجبات الجامعة العربية المفتوحة
لجميع تخصصات الجامعة ولجميع فروع الجامعة
حلول واجبات – مشاريع تخرج – ملخصات هامة
http://quiz.123.st/
Watsapp: 00201102862484

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

صلاحيات هذا المنتدى:لاتستطيع الرد على المواضيع في هذا المنتدى
منتديات طلاب الجامعات - والجامعة العربية المفتوحة  :: حل واجبات - كورسات - ملخصات - مراجعات :: حل واجبات - شرح كورسات M275-
انتقل الى: