حلول واجبات المهندس أحمد , جروب الإمتياز ,, تنبيه : رقمي الوحيد لعدم التعرض للإحتيال 00966597837185
حل واجب الجامعة العربية المفتوحة 00966597837185 - 0597837185
حلول واجبات الجامعة العربية المفتوحة 00966597837185
بريد الكتروني a_al_shora@hotmail.com
M275 Web Development Using PHP and MySQL
Tutor Marked Assignment – Spring Semester 2017/2018
Cut-Off Date: TBA Total Marks: 100
Contents
Question-1 [20 marks]
XAMPP and WAMP servers are installed by using third-party installation packages:
a- What is meant by third-party installation package? [2 marks]
b- What does XAMPP stand for? [5 marks]
c- What does WAMP stand for? [4 marks]
d- List three differences between XAMPP and WAMP? [9 marks]
Question-2 [50 marks]
In this question you are required to implement a simple transcript calculator by applying HTML tags and PHP codes. The calculator final code with 2 snapshots should be provided in your answer sheet.
This calculator has the following specifications:
1- The user changes the initial marks of some or all courses, and then presses the button 'Calculate the Total and Average', to find out the total, average, result and the grade of the entered marks.
2- It is assumed that the initial mark of all courses is zero, the initial result value is empty string and the initial grade value is empty string.
3- The result value is 'PASS' if the average greater than or equal to 50, otherwise it is 'FAIL'. The grade value is determined according to the scale below:
A Average ≥ 90
B 80 ≤ Average < 90
C 70 ≤ Average < 80
D 50 ≤ Average < 70
F Average < 50
4- The web page of this calculator, as shown in figure-1, has the following specifications:
a- 'PHP Simple Transcript Calculator' as the title of this web page.
b- 'Simple Transcript Calculator' as the main header of this web page.
Figure-1: Simple Transcript Calculator with Initial Values
c- M105, M129, M130, M131, M132, Total, Average, Result and Grade as labels.
d- M105, M129, M130, M131, M132, Total, Average, Result and Grade as textboxes.
e- 'Calculate the Total and Average' as button name.
f- Courses' labels and their textboxes are located in a separate field set, and the others are located in a different field set.
Figure-2: Simple Transcript Calculator with Some Values
Figure-3: Simple Transcript Calculator with Some Values
Question-3 [30 marks]
'driver', 'car', 'accident' and 'report' are names of some tables in the insurance database system. These tables were created by executing the following SQL creation statements.
CREATE TABLE driver(
driverID INT NOT NULL PRIMARY KEY,
name VARCHAR(30) NOT NULL,
cityAddress VARCHAR(25)
);
CREATE TABLE car(
plateID INT NOT NULL PRIMARY KEY,
model VARCHAR(20) NOT NULL,
year YEAR(4) NOT NULL
);
CREATE TABLE accident(
reportNumber INT NOT NULL PRIMARY KEY,
date Date NOT NULL,
******** VARCHAR(20) NOT NULL
);
CREATE TABLE report(
reportNumber INT NOT NULL,
plateID INT NOT NULL,
driverID INT NOT NULL,
damageAmount DOUBLE
);
Based on the previous SQL creation statements, you are required to write each of the following queries in SQL.
1- List the names of all drivers who live outside neither 'Amman' nor 'Madaba'. [6 marks]
2- List the models of all cars that have even number plateIDs. [6 marks]
3- List the ********s of all accidents that happened after December 10, 2015. [6 marks]
4- List the models of all cars which were not involved in any accident. [6 marks]
5- List the names and addresses of all drivers who were not involved in any accident. [6 marks]
The End
حل واجب M275 <00966597837185 حلول المهندس أحمد , واجبات الجامعة العربية المفتوحة
M275 - 00966597837185 حل واجب M275 حل,واجبات,الجامعة,العربية,المفتوحة,المهندس,أحمد
حل واجب M275 تلفون 00966597837185 - 0597837185 (حلول واجبات الجامعة العربية المفتوحة)
حل واجب00966597837185 M275 حلول واجبات M275 TMA الجامعة العربية المفتوحة 2018
حلول M275 حل واجب M275 ، 00966597837185 من المهندس أحمد ,واجبات الجامعة العربية المفتوحة
حل واجب M275 حل#واجبات#الجامعة#العربية#المفتوحة 00966597837185 حل واجب M275 Eng.Ahmed
حلول 00966597837185 حل واجب M275 الحل المثالي واجبات الجامعة العربية المفتوحة
M275 حل واجب,حل واجبات,الجامعة العربية المفتوحة,حلول واجبات M275
حلول واجبات المهندس أحمد , جروب الإمتياز ,, تنبيه : رقمي الوحيد لعدم التعرض للإحتيال 00966597837185
حل واجب الجامعة العربية المفتوحة 00966597837185 - 0597837185
حلول واجبات الجامعة العربية المفتوحة 00966597837185
بريد الكتروني a_al_shora@hotmail.com
حل واجب الجامعة العربية المفتوحة 00966597837185 - 0597837185
حلول واجبات الجامعة العربية المفتوحة 00966597837185
بريد الكتروني a_al_shora@hotmail.com
M275 Web Development Using PHP and MySQL
Tutor Marked Assignment – Spring Semester 2017/2018
Cut-Off Date: TBA Total Marks: 100
Contents
Question-1 [20 marks]
XAMPP and WAMP servers are installed by using third-party installation packages:
a- What is meant by third-party installation package? [2 marks]
b- What does XAMPP stand for? [5 marks]
c- What does WAMP stand for? [4 marks]
d- List three differences between XAMPP and WAMP? [9 marks]
Question-2 [50 marks]
In this question you are required to implement a simple transcript calculator by applying HTML tags and PHP codes. The calculator final code with 2 snapshots should be provided in your answer sheet.
This calculator has the following specifications:
1- The user changes the initial marks of some or all courses, and then presses the button 'Calculate the Total and Average', to find out the total, average, result and the grade of the entered marks.
2- It is assumed that the initial mark of all courses is zero, the initial result value is empty string and the initial grade value is empty string.
3- The result value is 'PASS' if the average greater than or equal to 50, otherwise it is 'FAIL'. The grade value is determined according to the scale below:
A Average ≥ 90
B 80 ≤ Average < 90
C 70 ≤ Average < 80
D 50 ≤ Average < 70
F Average < 50
4- The web page of this calculator, as shown in figure-1, has the following specifications:
a- 'PHP Simple Transcript Calculator' as the title of this web page.
b- 'Simple Transcript Calculator' as the main header of this web page.
Figure-1: Simple Transcript Calculator with Initial Values
c- M105, M129, M130, M131, M132, Total, Average, Result and Grade as labels.
d- M105, M129, M130, M131, M132, Total, Average, Result and Grade as textboxes.
e- 'Calculate the Total and Average' as button name.
f- Courses' labels and their textboxes are located in a separate field set, and the others are located in a different field set.
Figure-2: Simple Transcript Calculator with Some Values
Figure-3: Simple Transcript Calculator with Some Values
Question-3 [30 marks]
'driver', 'car', 'accident' and 'report' are names of some tables in the insurance database system. These tables were created by executing the following SQL creation statements.
CREATE TABLE driver(
driverID INT NOT NULL PRIMARY KEY,
name VARCHAR(30) NOT NULL,
cityAddress VARCHAR(25)
);
CREATE TABLE car(
plateID INT NOT NULL PRIMARY KEY,
model VARCHAR(20) NOT NULL,
year YEAR(4) NOT NULL
);
CREATE TABLE accident(
reportNumber INT NOT NULL PRIMARY KEY,
date Date NOT NULL,
******** VARCHAR(20) NOT NULL
);
CREATE TABLE report(
reportNumber INT NOT NULL,
plateID INT NOT NULL,
driverID INT NOT NULL,
damageAmount DOUBLE
);
Based on the previous SQL creation statements, you are required to write each of the following queries in SQL.
1- List the names of all drivers who live outside neither 'Amman' nor 'Madaba'. [6 marks]
2- List the models of all cars that have even number plateIDs. [6 marks]
3- List the ********s of all accidents that happened after December 10, 2015. [6 marks]
4- List the models of all cars which were not involved in any accident. [6 marks]
5- List the names and addresses of all drivers who were not involved in any accident. [6 marks]
The End
حل واجب M275 <00966597837185 حلول المهندس أحمد , واجبات الجامعة العربية المفتوحة
M275 - 00966597837185 حل واجب M275 حل,واجبات,الجامعة,العربية,المفتوحة,المهندس,أحمد
حل واجب M275 تلفون 00966597837185 - 0597837185 (حلول واجبات الجامعة العربية المفتوحة)
حل واجب00966597837185 M275 حلول واجبات M275 TMA الجامعة العربية المفتوحة 2018
حلول M275 حل واجب M275 ، 00966597837185 من المهندس أحمد ,واجبات الجامعة العربية المفتوحة
حل واجب M275 حل#واجبات#الجامعة#العربية#المفتوحة 00966597837185 حل واجب M275 Eng.Ahmed
حلول 00966597837185 حل واجب M275 الحل المثالي واجبات الجامعة العربية المفتوحة
M275 حل واجب,حل واجبات,الجامعة العربية المفتوحة,حلول واجبات M275
حلول واجبات المهندس أحمد , جروب الإمتياز ,, تنبيه : رقمي الوحيد لعدم التعرض للإحتيال 00966597837185
حل واجب الجامعة العربية المفتوحة 00966597837185 - 0597837185
حلول واجبات الجامعة العربية المفتوحة 00966597837185
بريد الكتروني a_al_shora@hotmail.com