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

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

شاطر | 
 

 Spring 2015_M359_TMA Cut-Off Date: Contents Question # Question 1 Question Question Question Question Question Question Plagiarism Warning: As per AOU rules and regulations, all students are required to submit their own TMA work and avoid plagiarism. The

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


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

مُساهمةموضوع: Spring 2015_M359_TMA Cut-Off Date: Contents Question # Question 1 Question Question Question Question Question Question Plagiarism Warning: As per AOU rules and regulations, all students are required to submit their own TMA work and avoid plagiarism. The    الأحد مارس 29, 2015 4:45 am

Spring 2015_M359_TMA
Cut-Off Date:
Contents
Question #
Question 1
Question
Question
Question
Question
Question
Question
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
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:
Course Title
30, April 2015
Green Database
2 Block
3 Block
4 Block
5 Block
6 Block
7 Block
h ure:
Faculty of Computer Studies
Title: Relational Databases: theory and practice
Tutor Marked Assignment
(Searching and Analysis)
Block-1 Conceptual Data Modeling
Block-1 Data Quality Issues
Block-1 Normalization
Block-2 Relational Represenation
Block-2 Relational Algebra
Block-3 Structure
Course Code:
Covered Topics
tructured Query Language
provide all refer
1
anguage
M359
Total Marks:
references in case you use and quote
Max Mark
10
20
10
10
10
10
30
ences 100
Marks Page #
2
2
3
3
3
4
5
Spring 2015_M359_TMA 2
Question 1 10 Marks
This question analyses the students’ general knowledge in database management system
concepts. Students need to check e-library or external resources to provide an adequate answer
to this question with proper referencing.
1.1 What do you mean by ‘Green Database’? Briefly define the steps to build a Green
Database
1.2 Analyse the industry practices in implementing Green Databases in data centres.
Summarize your findings in your own words.
Question 2 20 Marks
This question assesses your understanding of the Conceptual Data Model (CDM) presented in
section 5 of Block 1.
Give a conceptual data model (CDM) for the following given scenario using the Entity-
Relationship model, including the complete E-R diagram, the entity types, attributes, any
required constraints, assumptions and limitations.
AOU is planning to create a student recruitment system to keep information about the graduate
students from all faculties, details of the companies registered, available job vacancies,
available trainings etc. All seven branches graduate students’ data need to be stored. Each
student is identified by their student ID and other details to be stored are name, DOB, major,
year graduated, GPA, email address and the branch name. The branch details to be stored are
the branch name, contact person, email address, and telephone number. The contact person
could be the head of student affairs. AOU would receive lots of job offering from different
companies contracted with. There is dedicated staff in AOU to contact with the companies, the
staff details are Staff_ID, name and email Address. The company details to be stored are
Company ID, name, sector (such as banking, oil and gas, insurance etc.), country, contact
person, email address and telephone. The job vacancies are identified by Job_ID and other
details are description, contract type and remuneration. Companies also announce the training
availability for students, the details to be stored are TrainingID, description, StartDate and
EndDate. Students can apply for available training one at a time. Students can apply for more
than one job at a time based on their specialization. If a job or training is applied by a student,
the system should keep track of the updates and alert through email to the AOU’s assigned
recruitment staff and the applicant. The update details to be stored are Date of application,
job_ID, TrainingID, student ID and branch name. Duration of the training sessions are for less
than six months. Only the assigned person is allowed to contact with the students and
companies regarding the application and registration.
Give a conceptual data model (CDM) for this application using the Entity-Relationship model,
including the complete E-R diagram, the entity types and any required constraints and assumptions.
Give all degree and participation conditions details. Your ER diagram should be based on your
assumptions.
Spring 2015_M359_TMA 3
Question 3 10 Marks
This question covers Sections 2.3 of Block 1. It assesses your understanding of the concepts
covered in those sections. You will also need to check your e-library to provide an adequate answer
to this question.
3.1 Section 2.3 of Block-1 is discussing about the qualities of data must encompass to
satisfy its intended use. Briefly describe those qualities by providing your own
examples.
3.2 Briefly describe the data cleaning techniques applied in large enterprises.
Question 4 10 Marks
This question assesses your understanding of normal forms as discussed in Section 5 of Block 2.
Consider the following relation:
AOUConference(ConferenceID, ConferenceTitle, ConferenceDate, SpeakerName,AuthorID,
PaperTitle, Charge)
Assume that an author can submit multiple papers, and therefore conferenceID and AuthorID are
the primary keys. Given below are the additional functional dependencies:
ConferenceID ConferenceDate
ConferenceID Charge
ConferenceDate SpeakerName,
AuthorID PaperTitle
4.1 Based on the given primary key, is the relation in 1NF, 2NF, 3NF?
4.2 Why or why not?
4.3 How would you successively further normalize it completely?
Question 5 10 Marks
This question assesses students’ understanding of E-R conceptual modeling as discussed in Section
5 of Block 1 and assesses students’ knowledge of Block 2, Sections 2 and 4, and in particular,
students’ understanding of the relational representations. Questions a and b assess your ability to
transform a simple E-R fragment into a corresponding relational representation and questions c
and d assess your ability to transform relational representation into corresponding E-R fragment
Spring 2015_M359_TMA
5.1 Give a relational representation for the following E
required constraint declaration.
Staff (Staff_ID
Committee
5.2 Give a relational representation for the following E
required constraint declaration.
Department
Staff (Staff_ID
Question 6
This question assesses your understanding of manipulating relations and constraints as discussed in
Sections 3
for answering this part of the TMA
6.1
6.2
6.3
6.4
6.5
ID, StaffName, Department, ContactNo)
(CommitteeID
(DeptID
ID, StaffName)
3-5 of Block 2.
Find all drug codes and names for
Find the ward number and ward name of the nurse ‘Brown’
List the name of every male patient whose weight is greater than 60 and height is less
than 170.0 cm
Find the names and positions for all doctors who head at le
Find the names of doctors and patient IDs who treat all the patients with IDs p38 and
p88.
CommitteeID, Description, purpose, DateFormed)
DeptID, DeptName, Type)
, Students are required to use the
, , 4
EStaffName,
EThis
Antibiotics with price greater than 1.0
-R diagram fragments,
-R diagram fragments,
Hospital Database Summary
including any
including any
least one team.
10 Marks
ast
Spring 2015_M359_TMA 5
Question 6 30 Marks
This question is based on Section 1, 2, 3 and 4 of Block 3. It assesses your ability to write and
understand simple SQL queries (as defined in the sections).
Write SQL queries, and run them using iSQL/MySQL against the Hospital database.
Include in your answer BOTH the SQL query you wrote and the output table that results.
You MUST use meaningful column names, which may require using column aliases in the
SQL query
Students are required to use the Hospital Database for answering this part of the TMA
7.1. List the name of every male patient whose weight s greater than 60 and height is less than
170.0 cm.
7.2. Find the average number of daily dosage prescribed for patient p38
7.3. Find the total number of nurses working in ward w3
7.4. Find all drug codes and names for painkillers starting with ‘a’ with price lower than 0.5.
7.5. Find the ward number and ward name of nurse Brown
7.6. Find the names and positions for all doctors who head at least one team.
7.7. Find the names of doctors and patient IDs who treat the patients with ID p38 and p88.
7.8. Find the names of all Doctors who treat for pain relief.
7.9. Find the average price of Painkillers
7.10. List the prescriptions for which the daily dosage falls within the range 5 to 20 (inclusive)
7.11. Find patients whose name starts with a ‘B’ and whose last letter ‘l’
7.12. Find out the total number of patients are admitted in each ward.
7.13. For each treatment except treated by the doctors with IDs 603 and 156, list the number of
patients who is undergoing treatment.
7.14. List all female patients admitted in ward ‘w2’treated by consultants.
7.15. For each male patient with more than two prescriptions, list the patient id, number of
prescriptions, and the reason for the treatment.

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

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






خدمات مجانية – حلول واجبات الجامعة العربية المفتوحة
لجميع تخصصات الجامعة ولجميع فروع الجامعة
حلول واجبات – مشاريع تخرج – ملخصات هامة
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
 
Spring 2015_M359_TMA Cut-Off Date: Contents Question # Question 1 Question Question Question Question Question Question Plagiarism Warning: As per AOU rules and regulations, all students are required to submit their own TMA work and avoid plagiarism. The
استعرض الموضوع السابق استعرض الموضوع التالي الرجوع الى أعلى الصفحة 
صفحة 1 من اصل 1
 مواضيع مماثلة
-
» شرح ال Yes\No Question
» كيفية تكوين سؤال فى اللغه الانجليزيه
» How to feel confident on your first date
» دروس علوم الطبيعة والحياة بشكل عروض تقديمية
» قواعد الترجمة – Rules of Translation

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