حل واجبات الجامعة العربية المفتوحة اتصل : OO966544321455 واتس اب: 966544321455+ 2015 2016

shora2 · Nov 10, 2015

حل واجبات الجامعة العربية المفتوحة
اتصل : O544321455 - OO966544321455
واتس اب: 966544321455+
ايميل : a_al_shora@hot mail.com
سكايبي : a_al_shora

حل واجب 0.5.4.4.3.2.1.4.5.5 الجامعة العربية المفتوحة

حل واجبات الجامعة العربية المفتوحة O54.4.3.2.1.4.5.5 - OO96654.4.3.2.1.4.5.5
ايميل : a_al_shora @ h.o.t.m.ail.c.o.m
سكايبي: a_al_shora
واتس اب: OO96654.4.3.2.1.4.5.5

TMA M131 fall 2015-2016

The TMA covers only chapters 1, 2, 4 and 9 and consists of eight questions for a total of 40 marks. Please solve each question in the space provided. You should give the details of your solutions and not just the final results.

Q−1: [3+2 marks]Determine whether the statement is a tautology,
a) using the truth table method,
b) using logic laws.

Q−2: [5×1 marks]Given a predicate P(x) where the domain is the set of real numbers, determine the truth value of each of the following quantifier, Justify your answer:
a) .
b) .
c) .
d) .
e) .

Q¬−3: [5×1 marks]Let A×B= {(1,1), (2,2), (3,1), (3,2), (1,2), (1,4), (2,1), (2,4), (3,4)}. Find
a) P(B),
b) Number of binary relations from A to B,
c) ,
d) ,
e) .

Q¬−4:[5×1marks]For all integersa, b, c, d, determine whether each of the following is TRUE or FALSE, Justify your answer:
a) If a | (b + c), then a | b and a | c.
b) If a | c and b | c, then (ab) | c2.
c) If a | b and c | d, then (ac) | (b + d).
d) If a | b, b | c and c | d, then a | d.
e) Ifa | b and c | d, then (a + c) | (b + d).

Q−5: [1+2+2 marks] Perform the following arithmetic operations for the numbers in the bases indicated and write outanswers in base 5 notation:
a) 244 + 132 (base 5).
b) 11101 × 111 (base 2).
c) F7 – B6 (base 16).

Q¬−6:[5 marks]Find the set of all binary relations on {0, 1}.

Q¬−7:[3+2 marks]LetA be the set of all ordered pairs of positive integers andR be the relation defined on A where (a, b)R(c, d) means that b - a = d - c.
a) Show that R is an equivalence relation.
b) Find [(3, 5)] and [(7, 1)].

Q¬−8:[5×1 marks]Let A be the set of all integers greater than or equal to 2 and R be the relation on A where(x, y)R if and only if x is a divisor of y. Determine whether each of the following is TRUE or FALSE, Justify your answer:
a) 7 is a minimal element of A.
b) 6 is not a minimal element of A.
c) A does not have any maximal elements.
d) 2 is the least element of A.
e) R is a total order relation.

خدمات مجانية – حلول واجبات الجامعة العربية المفتوحة
لجميع تخصصات الجامعة ولجميع فروع الجامعة
حلول واجبات – مشاريع تخرج – ملخصات هامة
http://quiz.7olm.org/
Mobile: 00966544321455 or 0544321455

Watsapp: 00966544321455

a_al_shora@hotmail.com
حلول مضمونة وغير مكررة وغير متشابهة لجميع واجبات الجامعة
متوفرمدرسين ومدرسات لجميع المواد والتخصصات

shora2 · Nov 10, 2015

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

اتصل : O544321455 - OO966544321455
واتس اب: 966544321455+
ايميل : a_al_shora@hot mail.com
سكايبي : a_al_shora

حل واجب 0.5.4.4.3.2.1.4.5.5 الجامعة العربية المفتوحة

حل واجبات الجامعة العربية المفتوحة O54.4.3.2.1.4.5.5 - OO96654.4.3.2.1.4.5.5
ايميل : a_al_shora @ h.o.t.m.ail.c.o.m
سكايبي: a_al_shora
واتس اب: OO96654.4.3.2.1.4.5.5

TMA M132 fall 2015-2016
Q−1:[5×2 marks]
Answer each of the following as True or False (justify your answer):

a) If the matrices A and B are two invertible matrices, then (A + B) is also invertible.

b) A square matrix A is called symmetric if At = A. If B is a square matrix, then B.Bt and B + Bt are symmetric.

c) If A and B are symmetric matrices and if AB = BA, then AB is symmetric.

d) If A is an invertible 2 x 2 matrix, then At is invertible and (At)-1 = (A-1)t.

e) For λ = 0, the vectors form a linearly dependent set in R3.

Q−2: [5+5 marks]
a) Show that the vectors form a linearly dependent set in R4.
b) Express each vector as a linear combination of the other two.

Q−3: [5+5 marks] Let
a) Find A-1
b) Solve the system A.x = b for .

Q¬−4:[4+3+3 marks] Let

a) Find det(B) in terms of k;
b) For what value(s) of k are the column vectors of B linearly dependent;
c) For k = 0, find det(B) and .

Q¬−5:[4+3+3 marks] Let be the augmented matrix for a linear system. For what values of a and b does the system have:
a) A unique solution;
b) Infinitely many solutions;
c) No solutions.

Q−6:[2+4+4 marks]: Consider the linear system

a) Use row-reduction to solve the linear system;
a) If A is the coefficient matrix, find A-1;
b) If C.A = B, where . Find matrix C and its elements.

خدمات مجانية – حلول واجبات الجامعة العربية المفتوحة
لجميع تخصصات الجامعة ولجميع فروع الجامعة
حلول واجبات – مشاريع تخرج – ملخصات هامة
http://quiz.7olm.org/
Mobile: 00966544321455 or 0544321455

Watsapp: 00966544321455

a_al_shora@hotmail.com
حلول مضمونة وغير مكررة وغير متشابهة لجميع واجبات الجامعة
متوفرمدرسين ومدرسات لجميع المواد والتخصصات

shora2 · Nov 10, 2015

حل واجبات الجامعة العربية المفتوحة
اتصل : O544321455 - OO966544321455
واتس اب: 966544321455+
ايميل : a_al_shora@hot mail.com
سكايبي : a_al_shora

حل واجب 0.5.4.4.3.2.1.4.5.5 الجامعة العربية المفتوحة

حل واجبات الجامعة العربية المفتوحة O54.4.3.2.1.4.5.5 - OO96654.4.3.2.1.4.5.5
ايميل : a_al_shora @ h.o.t.m.ail.c.o.m
سكايبي: a_al_shora
واتس اب: OO96654.4.3.2.1.4.5.5

TMA M132 fall 2015-2016
Q−1:[5×2 marks]
Answer each of the following as True or False (justify your answer):

a) If the matrices A and B are two invertible matrices, then (A + B) is also invertible.

b) A square matrix A is called symmetric if At = A. If B is a square matrix, then B.Bt and B + Bt are symmetric.

c) If A and B are symmetric matrices and if AB = BA, then AB is symmetric.

d) If A is an invertible 2 x 2 matrix, then At is invertible and (At)-1 = (A-1)t.

e) For λ = 0, the vectors form a linearly dependent set in R3.

Q−2: [5+5 marks]
a) Show that the vectors form a linearly dependent set in R4.
b) Express each vector as a linear combination of the other two.

Q−3: [5+5 marks] Let
a) Find A-1
b) Solve the system A.x = b for .

Q¬−4:[4+3+3 marks] Let

a) Find det(B) in terms of k;
b) For what value(s) of k are the column vectors of B linearly dependent;
c) For k = 0, find det(B) and .

Q¬−5:[4+3+3 marks] Let be the augmented matrix for a linear system. For what values of a and b does the system have:
a) A unique solution;
b) Infinitely many solutions;
c) No solutions.

Q−6:[2+4+4 marks]: Consider the linear system

a) Use row-reduction to solve the linear system;
a) If A is the coefficient matrix, find A-1;
b) If C.A = B, where . Find matrix C and its elements.

خدمات مجانية – حلول واجبات الجامعة العربية المفتوحة
لجميع تخصصات الجامعة ولجميع فروع الجامعة
حلول واجبات – مشاريع تخرج – ملخصات هامة
http://quiz.7olm.org/
Mobile: 00966544321455 or 0544321455

Watsapp: 00966544321455

a_al_shora@hotmail.com
حلول مضمونة وغير مكررة وغير متشابهة لجميع واجبات الجامعة
متوفرمدرسين ومدرسات لجميع المواد والتخصصات

shora2 · Nov 10, 2015

حل واجبات الجامعة العربية المفتوحة
اتصل : O544321455 - OO966544321455
واتس اب: 966544321455+
ايميل : a_al_shora@hot mail.com
سكايبي : a_al_shora

حل واجب 0.5.4.4.3.2.1.4.5.5 الجامعة العربية المفتوحة

حل واجبات الجامعة العربية المفتوحة O54.4.3.2.1.4.5.5 - OO96654.4.3.2.1.4.5.5
ايميل : a_al_shora @ h.o.t.m.ail.c.o.m
سكايبي: a_al_shora
واتس اب: OO96654.4.3.2.1.4.5.5

TT284 - TMA
This TMA covers Blocks 1, 2 and 3. This TMA consists of 4 questions, and the total
mark is out of 100
Important: Enter your solutions into a solution document in Word and
an RTF document or over-large files
Question 1: [30 marks]
Search the Web for "Samsung Galaxy S6 edge
specification, in a table wise
may consult any website but state the URL reference pages you visited. Based on
your finding calculate screen resolution
determine which one of them is
Question 2: [30 marks]
a) What’s a Mobile Web App?
[15 marks]
b) Publishing on Google Play
Before you publish your apps on Google Play and distribute them to users, you need
to get the apps ready, test them, and prepare your p
Search the Web for the publishing process for a successful product launch on
Google Play and summarize th
publishing your app on Google Play.
You may discuss the steps in any sequence
sequence gives a rough idea of
(Hints: summarize and use your own words
answer that may lead to ZERO Mark
Question 3: [40 marks]
Creating a dynamic Java****** Calculators
Referring to your text in blocks one and two
Java****** Calculator similar to the following calculator image
functions and a reset bottom, label it as 'C'.

Cut-off date 15
to the e-TMA system.
edge" and "Apple iPhone 6 Plus
wise, compare and summaries the differences you find.
for both smart phones and compare and
finer or coarser. Explain your answer.
Explain its advantages. Discuss your answer.
Play:
promotional materials.
those tasks you'll need to complete before
that works for you, h
the overall process.
and avoid copying direct text into your
to be awarded for this question
Calculators.
, visit w3schools.com
image. Include only simple
December 2015
avoid sending
Plus" full
, You
[15 marks]
romotional , however, a logical
question).
to create simple

You may consult Notepad++ or simply use w3schools editor to test and run your
code such as the following screen shot that I try it myself.
(Hints: there are many sites in the web that may have similar function. The point is to
try yourself the code and use an editor to test your results. Avoid copying direct
codes into your answer that may lead to ZERO Mark to be awarded for this
question).
What to submit?
1. The required HTML or XHTML code. (30 marks)
2. The needed CSS code or the style code. (10 marks)
(Hints:
• you may compress all files above in one .rar or .zip file to submit. But if
your e-TMA system did not accept compressed files, ask your Tutor to
provide another link in the LMS so as you can submit all.
• Writing good style and output layout design worth up to 5 marks.
)
End of TMA

خدمات مجانية – حلول واجبات الجامعة العربية المفتوحة
لجميع تخصصات الجامعة ولجميع فروع الجامعة
حلول واجبات – مشاريع تخرج – ملخصات هامة
http://quiz.7olm.org/
Mobile: 00966544321455 or 0544321455

Watsapp: 00966544321455

a_al_shora@hotmail.com
حلول مضمونة وغير مكررة وغير متشابهة لجميع واجبات الجامعة

shora2 · Nov 10, 2015

حل واجبات الجامعة العربية المفتوحة
اتصل : O544321455 - OO966544321455
واتس اب: 966544321455+
ايميل : a_al_shora@hot mail.com
سكايبي : a_al_shora

حل واجب 0.5.4.4.3.2.1.4.5.5 الجامعة العربية المفتوحة

حل واجبات الجامعة العربية المفتوحة O54.4.3.2.1.4.5.5 - OO96654.4.3.2.1.4.5.5
ايميل : a_al_shora @ h.o.t.m.ail.c.o.m
سكايبي: a_al_shora
واتس اب: OO96654.4.3.2.1.4.5.5

TT284 - TMA
This TMA covers Blocks 1, 2 and 3. This TMA consists of 4 questions, and the total
mark is out of 100
Important: Enter your solutions into a solution document in Word and
an RTF document or over-large files
Question 1: [30 marks]
Search the Web for "Samsung Galaxy S6 edge
specification, in a table wise
may consult any website but state the URL reference pages you visited. Based on
your finding calculate screen resolution
determine which one of them is
Question 2: [30 marks]
a) What’s a Mobile Web App?
[15 marks]
b) Publishing on Google Play
Before you publish your apps on Google Play and distribute them to users, you need
to get the apps ready, test them, and prepare your p
Search the Web for the publishing process for a successful product launch on
Google Play and summarize th
publishing your app on Google Play.
You may discuss the steps in any sequence
sequence gives a rough idea of
(Hints: summarize and use your own words
answer that may lead to ZERO Mark
Question 3: [40 marks]
Creating a dynamic Java****** Calculators
Referring to your text in blocks one and two
Java****** Calculator similar to the following calculator image
functions and a reset bottom, label it as 'C'.

Cut-off date 15
to the e-TMA system.
edge" and "Apple iPhone 6 Plus
wise, compare and summaries the differences you find.
for both smart phones and compare and
finer or coarser. Explain your answer.
Explain its advantages. Discuss your answer.
Play:
promotional materials.
those tasks you'll need to complete before
that works for you, h
the overall process.
and avoid copying direct text into your
to be awarded for this question
Calculators.
, visit w3schools.com
image. Include only simple
December 2015
avoid sending
Plus" full
, You
[15 marks]
romotional , however, a logical
question).
to create simple

You may consult Notepad++ or simply use w3schools editor to test and run your
code such as the following screen shot that I try it myself.
(Hints: there are many sites in the web that may have similar function. The point is to
try yourself the code and use an editor to test your results. Avoid copying direct
codes into your answer that may lead to ZERO Mark to be awarded for this
question).
What to submit?
1. The required HTML or XHTML code. (30 marks)
2. The needed CSS code or the style code. (10 marks)
(Hints:
• you may compress all files above in one .rar or .zip file to submit. But if
your e-TMA system did not accept compressed files, ask your Tutor to
provide another link in the LMS so as you can submit all.
• Writing good style and output layout design worth up to 5 marks.
)
End of TMA

خدمات مجانية – حلول واجبات الجامعة العربية المفتوحة
لجميع تخصصات الجامعة ولجميع فروع الجامعة
حلول واجبات – مشاريع تخرج – ملخصات هامة
http://quiz.7olm.org/
Mobile: 00966544321455 or 0544321455

Watsapp: 00966544321455

a_al_shora@hotmail.com
حلول مضمونة وغير مكررة وغير متشابهة لجميع واجبات الجامعة

shora2 · Nov 10, 2015

حل واجبات الجامعة العربية المفتوحة
اتصل : O544321455 - OO966544321455
واتس اب: 966544321455+
ايميل : a_al_shora@hot mail.com
سكايبي : a_al_shora

حل واجب 0.5.4.4.3.2.1.4.5.5 الجامعة العربية المفتوحة

حل واجبات الجامعة العربية المفتوحة O54.4.3.2.1.4.5.5 - OO96654.4.3.2.1.4.5.5
ايميل : a_al_shora @ h.o.t.m.ail.c.o.m
سكايبي: a_al_shora
واتس اب: OO96654.4.3.2.1.4.5.5

TMA M129 fall 2015-2016
Tutor’s Comments:
This TMA covers only chapters 0, 1, 2, 3 and 4. The TMA consists of eight
questions for a total of 40 marks. Please solve each question in the space
provided. You should give the details of your solutions and not just the
final results.
Q−1: [3+2Marks]
a) Given
,

Find the zeros of g(x) and f(x).
b) Find the points of intersection, if any, of the pair of curves :

,
Q−2: [2+2+1Marks]
a) Let
.
(I) Find f(g(x)).
(II) Find g(f (x)).
b) Find the domains of g(f (x)).
Q−3: [2+3 Marks]
Use the definition of the derivative to find f ′(x) if
a)

b)

Q−4: [2 + 3 Marks]
a) Find an equation of the tangent line to the graph of

at the point whose x-coordinate is 1.
b) Find the equation of the tangent line to the curve
 
2
x y x    2 1
at
the point (4,1).
Q−5:[2.5+2.5 Marks] differentiate the following function:
a)

b)

Q−6: [5×1Marks] Let

a) Find f ′(x) and f ′′(x).
b) Find the intervals on which f (x) is increasing or decreasing.
c) Find the local maximum and minimum of f (x), if any.
d) Find the intervals on which the graph of f (x) is concave up or
concave down.
e) Find the inflection points of f (x), if any.
Q−7:[5 Marks] Poster is to be designed with 50 in2
of printed type, 4 inch
margins on both the top and the bottom, and 2 inch margins on each side. Find
the dimensions of the poster which minimize the amount of paper used.
Q−8:[5 Marks]Use the logarithmic differentiation to differentiate the function

خدمات مجانية – حلول واجبات الجامعة العربية المفتوحة
لجميع تخصصات الجامعة ولجميع فروع الجامعة
حلول واجبات – مشاريع تخرج – ملخصات هامة
http://quiz.7olm.org/
Mobile: 00966544321455 or 0544321455

Watsapp: 00966544321455

a_al_shora@hotmail.com
حلول مضمونة وغير مكررة وغير متشابهة لجميع واجبات الجامعة
متوفرمدرسين ومدرسات لجميع المواد والتخصصات

shora2 · Nov 10, 2015

حل واجبات الجامعة العربية المفتوحة
اتصل : O544321455 - OO966544321455
واتس اب: 966544321455+
ايميل : a_al_shora@hot mail.com
سكايبي : a_al_shora

حل واجب 0.5.4.4.3.2.1.4.5.5 الجامعة العربية المفتوحة

حل واجبات الجامعة العربية المفتوحة O54.4.3.2.1.4.5.5 - OO96654.4.3.2.1.4.5.5
ايميل : a_al_shora @ h.o.t.m.ail.c.o.m
سكايبي: a_al_shora
واتس اب: OO96654.4.3.2.1.4.5.5

M359 Relational databases: theory and practice
TMA M359 Fall 2015

Question 1 (8 marks)
Contrast the modern relational database approach with the old file systems approach. Provide a critical evaluation of the current technology with respect to the following questions:
i. What kind of interface does each approach provide?
ii. What are the advantages of the style of interface provided by the modern database approach?
iii. What sort of database maintenance problems can be solved by the new database approach?
iv. Explain how is the new style of database interface implemented in the modern database approach?
8
Question 2 (8 marks)
Use the e-library and other resources to the answer the following questions about Big Data and Big Data Analytics:
i. Give definitions of what Big data is and what is meant by big data analytics and what are its benefits? You can quote experts to answer this part, but you need to state your reference.
ii What are the characteristics of big data?
iii what are some of the sources of big data today ?
iv. What are the different types of big data in terms of how they are structured? Give examples.
8
Question 3 (8 marks)
Develop a conceptual model for the following scenario:
It is desired to build a database for AOU. The following is a modified version of the database scenario. Develop a complete Conceptual data Model for it. The data model should consist of the usual 5 components: E-R diagram, Entity Types including entity type identifiers, assumptions, additional constraints, and limitations.
1. AOU needs to keep details of its staff and students and courses. Details of the performance of the students and their academic history should be made available as well. Information about all semesters and all years should be kept.
2. Staff are employed by exactly one branch and students are admitted to exactly one branch. Each branch is identified by a branch number in the range 00-99, inclusive. Other branch details include its name, address and telephone number.
3. Personal information about each student are recorded initially when the student is first
40
4
admitted to the university. This includes the student's ID (issued at the time of admission), name, address and date of admission. Each student is admitted in one particular branch, but students may change their branch later on. Initially, admitted students will not have any registered courses, but they can register courses in each semester. Every time the student registers a course, the registration date is recorded.
4. Information recorded for each member of staff includes the staff number, name, address, telephone number and email address and the branch in which the staff member is employed.
5. Staff may teach zero or more course groups each semester but each group must be assigned exactly one staff to teach it. Each staff member may or may not be assigned the role of General Course Coordinator (GCC) for one or more courses. A staff member may also be assigned the role of Branch Course Coordinator (BCC) for one or more courses. Information about only the current GCC and BCC assignments need to be kept.
6. Students may or may not register in any course groups during a particular semester. Initially, groups may not have any registered students, so each group may have zero or more student registrations at any given time. Students may register a maximum of 16 credit hours per semester. Student scores on each course (tma, mta, final and letter grade) need to be kept. Students cannot register in any course group unless it has a tutor assigned to it.
7. A course may have zero or more groups but each group must be associated with exactly one course. Each group meets once weekly. It has a group number that is unique only within the same course, same term and same year. The number may repeat for a different course, a different term or a different year. A group also has a meeting place (location), start time and end time. Each course group has an upper limit on the number of students registered in it that is different for each course. This limit is recorded in the database for each course and no group is allowed to exceed this limit. Students cannot register in more than one group for the same course, during the same year and the same term.
8. Each course is given a course code that consists of two letters, followed by three digits. For example, CS100, CE234, and so on. Each course also has a title and a value for credit hours – either 1, 3, 4, 5 or 8 credits.
9. Each course has a single Tutor Marked Assignment (TMA), a single Mid Term Assessment (MTA), a single Final exam and, obviously, a single letter grade. The scores of those assessment items will be entered in the database as they become available. So, there could be a time after student registration and before the assessments' marks are entered when those marks will not be available. Keep in mind, however, that null values are not allowed in the database.
Note: you should expect about 10 entity types, 12 relationship types, 57 attributes, 13 additional constraints, 5 assumptions and 4 limitations in the CDM for this application.
5
Question 4 (8 marks)
i. Convert the following relational representation back into a CDM using two relationships and three entity types. Explain how the constraint is being represented in the CDM.
relation user
user_Id: user_Ids
name: Names
primary key user_Id
relation tweets
user_Id: user_Ids
tweet_Id: tweet_Ids
primary key tweet_Id
foreign key user_Id references user
foreign key tweet_Id references tweet
constraint ((project tweet over tweet_Id) difference (project tweets over tweets_Id)) is empty
relation tweet
tweet_Id: tweet_Ids
date_time: date_time
tweet_text: text
primary key tweet_Id
ii. use the relation schema below to answer the following questions:
marriage (man_id, woman_id, marriage_date, man_name, woman_name)
fd1: man_id, woman_id  marriage_date, man_name, woman__name
fd2: man_id  man_name
fd3: woman_id  woman_name
a. what is the highest normal form to which the relation complies ? show why the above relation conforms to the normal form you identified and why it does not comply with the next higher form.
b. normalize the above relation into the next higher normal form
8
6
Question 5 (8 marks)
16
You will need to refer to the University database to answer this question. Write SQL queries to perform the following operations. in each case show the SQL statement you used and the output from MySQL.
a) List the student details for all students registered after 1st of January 2004.
2
b) List all region numbers for regions that have students registered in them (with no duplicates).
2
c) List the staff no. and name only for all staff in regions 1, 2 and 3 only
2
d) return a list of student names and the titles of courses each student is enrolled in, ordered by student names
2
e) get the ids of all students not currently enrolled in any courses
2
f) Write a query to get the number of courses enrolled by each student, orederd by student name.
2
g) Write a query to get for each course, the ids of the students who achieved an examination mark that is above the average examination mark of the course.
2
h) Write a query to retrieve the name of the students with the highest examination mark for each course

خدمات مجانية – حلول واجبات الجامعة العربية المفتوحة
لجميع تخصصات الجامعة ولجميع فروع الجامعة
حلول واجبات – مشاريع تخرج – ملخصات هامة
http://quiz.7olm.org/
Mobile: 00966544321455 or 0544321455

Watsapp: 00966544321455

a_al_shora@hotmail.com
حلول مضمونة وغير مكررة وغير متشابهة لجميع واجبات الجامعة
متوفرمدرسين ومدرسات لجميع المواد والتخصصات

shora2 · Nov 10, 2015

حل واجبات الجامعة العربية المفتوحة
اتصل : O544321455 - OO966544321455
واتس اب: 966544321455+
ايميل : a_al_shora@hot mail.com
سكايبي : a_al_shora

حل واجب 0.5.4.4.3.2.1.4.5.5 الجامعة العربية المفتوحة

حل واجبات الجامعة العربية المفتوحة O54.4.3.2.1.4.5.5 - OO96654.4.3.2.1.4.5.5
ايميل : a_al_shora @ h.o.t.m.ail.c.o.m
سكايبي: a_al_shora
واتس اب: OO96654.4.3.2.1.4.5.5

M359 Relational databases: theory and practice
TMA M359 Fall 2015

Question 1 (8 marks)
Contrast the modern relational database approach with the old file systems approach. Provide a critical evaluation of the current technology with respect to the following questions:
i. What kind of interface does each approach provide?
ii. What are the advantages of the style of interface provided by the modern database approach?
iii. What sort of database maintenance problems can be solved by the new database approach?
iv. Explain how is the new style of database interface implemented in the modern database approach?
8
Question 2 (8 marks)
Use the e-library and other resources to the answer the following questions about Big Data and Big Data Analytics:
i. Give definitions of what Big data is and what is meant by big data analytics and what are its benefits? You can quote experts to answer this part, but you need to state your reference.
ii What are the characteristics of big data?
iii what are some of the sources of big data today ?
iv. What are the different types of big data in terms of how they are structured? Give examples.
8
Question 3 (8 marks)
Develop a conceptual model for the following scenario:
It is desired to build a database for AOU. The following is a modified version of the database scenario. Develop a complete Conceptual data Model for it. The data model should consist of the usual 5 components: E-R diagram, Entity Types including entity type identifiers, assumptions, additional constraints, and limitations.
1. AOU needs to keep details of its staff and students and courses. Details of the performance of the students and their academic history should be made available as well. Information about all semesters and all years should be kept.
2. Staff are employed by exactly one branch and students are admitted to exactly one branch. Each branch is identified by a branch number in the range 00-99, inclusive. Other branch details include its name, address and telephone number.
3. Personal information about each student are recorded initially when the student is first
40
4
admitted to the university. This includes the student's ID (issued at the time of admission), name, address and date of admission. Each student is admitted in one particular branch, but students may change their branch later on. Initially, admitted students will not have any registered courses, but they can register courses in each semester. Every time the student registers a course, the registration date is recorded.
4. Information recorded for each member of staff includes the staff number, name, address, telephone number and email address and the branch in which the staff member is employed.
5. Staff may teach zero or more course groups each semester but each group must be assigned exactly one staff to teach it. Each staff member may or may not be assigned the role of General Course Coordinator (GCC) for one or more courses. A staff member may also be assigned the role of Branch Course Coordinator (BCC) for one or more courses. Information about only the current GCC and BCC assignments need to be kept.
6. Students may or may not register in any course groups during a particular semester. Initially, groups may not have any registered students, so each group may have zero or more student registrations at any given time. Students may register a maximum of 16 credit hours per semester. Student scores on each course (tma, mta, final and letter grade) need to be kept. Students cannot register in any course group unless it has a tutor assigned to it.
7. A course may have zero or more groups but each group must be associated with exactly one course. Each group meets once weekly. It has a group number that is unique only within the same course, same term and same year. The number may repeat for a different course, a different term or a different year. A group also has a meeting place (location), start time and end time. Each course group has an upper limit on the number of students registered in it that is different for each course. This limit is recorded in the database for each course and no group is allowed to exceed this limit. Students cannot register in more than one group for the same course, during the same year and the same term.
8. Each course is given a course code that consists of two letters, followed by three digits. For example, CS100, CE234, and so on. Each course also has a title and a value for credit hours – either 1, 3, 4, 5 or 8 credits.
9. Each course has a single Tutor Marked Assignment (TMA), a single Mid Term Assessment (MTA), a single Final exam and, obviously, a single letter grade. The scores of those assessment items will be entered in the database as they become available. So, there could be a time after student registration and before the assessments' marks are entered when those marks will not be available. Keep in mind, however, that null values are not allowed in the database.
Note: you should expect about 10 entity types, 12 relationship types, 57 attributes, 13 additional constraints, 5 assumptions and 4 limitations in the CDM for this application.
5
Question 4 (8 marks)
i. Convert the following relational representation back into a CDM using two relationships and three entity types. Explain how the constraint is being represented in the CDM.
relation user
user_Id: user_Ids
name: Names
primary key user_Id
relation tweets
user_Id: user_Ids
tweet_Id: tweet_Ids
primary key tweet_Id
foreign key user_Id references user
foreign key tweet_Id references tweet
constraint ((project tweet over tweet_Id) difference (project tweets over tweets_Id)) is empty
relation tweet
tweet_Id: tweet_Ids
date_time: date_time
tweet_text: text
primary key tweet_Id
ii. use the relation schema below to answer the following questions:
marriage (man_id, woman_id, marriage_date, man_name, woman_name)
fd1: man_id, woman_id  marriage_date, man_name, woman__name
fd2: man_id  man_name
fd3: woman_id  woman_name
a. what is the highest normal form to which the relation complies ? show why the above relation conforms to the normal form you identified and why it does not comply with the next higher form.
b. normalize the above relation into the next higher normal form
8
6
Question 5 (8 marks)
16
You will need to refer to the University database to answer this question. Write SQL queries to perform the following operations. in each case show the SQL statement you used and the output from MySQL.
a) List the student details for all students registered after 1st of January 2004.
2
b) List all region numbers for regions that have students registered in them (with no duplicates).
2
c) List the staff no. and name only for all staff in regions 1, 2 and 3 only
2
d) return a list of student names and the titles of courses each student is enrolled in, ordered by student names
2
e) get the ids of all students not currently enrolled in any courses
2
f) Write a query to get the number of courses enrolled by each student, orederd by student name.
2
g) Write a query to get for each course, the ids of the students who achieved an examination mark that is above the average examination mark of the course.
2
h) Write a query to retrieve the name of the students with the highest examination mark for each course

خدمات مجانية – حلول واجبات الجامعة العربية المفتوحة
لجميع تخصصات الجامعة ولجميع فروع الجامعة
حلول واجبات – مشاريع تخرج – ملخصات هامة
http://quiz.7olm.org/
Mobile: 00966544321455 or 0544321455

Watsapp: 00966544321455

a_al_shora@hotmail.com
حلول مضمونة وغير مكررة وغير متشابهة لجميع واجبات الجامعة
متوفرمدرسين ومدرسات لجميع المواد والتخصصات

حل واجبات الجامعة العربية المفتوحة اتصل : OO966544321455 واتس اب: 966544321455+ 2015 2016

shora2

Active Member

shora2

Active Member

shora2

Active Member

shora2

Active Member

shora2

Active Member

shora2

Active Member

shora2

Active Member

shora2

Active Member