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

حل واجبات الجامعة العربية المفتوحة 00966542495275بأعلى درجات الثقة بالنفس ومعدل عالي لكل الواجبات 20/20 , حل واجب , حلول واجبات الجامعة العربية المفتوحة في فترة زمنية قصيرة تقنية المعلومات لذلك اعتبر نفسك طالب مميز بالجامعة العربية المفتوحة
 
الرئيسيةاليوميةس .و .جبحـثالأعضاءالمجموعاتالتسجيلدخول

شاطر | 
 

 حل واجب m359 ------- m359 النموذجي

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


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

مُساهمةموضوع: حل واجب m359 ------- m359 النموذجي   الخميس ديسمبر 06, 2012 5:58 am

Question 1 (20 marks): This question covers Sections 1 and 2 of Block 1. It assesses your understanding of the concepts covered in those sections.
(a) Explain the difference between productive and unproductive maintenance and how it relates to the concept of data independence.(4 marks)
(b) Can the use of multiple copies of data files eliminate the need to perform unproductive maintenance? Why? (4 marks)
(c) What other problems occur in the file processing approach? (4 marks)
(d) Explain how does the Data Base Management System (DBMS) approach overcome the problems of unproductive maintenance while ensuring a maximum sharing of stored data? (4 marks)
(e) Explain how the terms "data" and "information" are used in M359? And how they relate to each other? Give examples of each. (4 marks)
Question 2 (20 marks): This question covers Sections 1.3 and 1.4 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. Imagine that you are a well-established automobile dealer and that you have been operating with a large market share and a good profit for the last 20 years. Your business includes selling and buying new and used automobiles. It also includes a maintenance shop that also sells spare parts. You are now faced with the Internet revolution and the rise of online buying and
selling. Consequently, your market share and profits have been dropping.
a. Outline what would an Information System (IS) strategy need to address in order to restore your market position and increase revenues? (4 marks)
b. Outline the issues that would be addressed by an Information Management (IM) strategy to complement your IS strategy above. (4 marks)
c. Briefly outline an Information Technology (IT) strategy to meet the requirements of the IS strategy within the IM structure? (4 marks)
d. Explain what problems could you face if each of the data quality issues in section 2.3 of Block 1 is not met? Give examples (8 marks)
Question 3 (20 marks)
This question tests your knowledge and understanding of normal forms as presented in Unit 5 of Block 2.
Given the following relation and functional dependencies, answer questions (a) – (d), then answer question (e).
(a) Show that the relation T above is only in 1NF and does not conform to any higher normal forms. Given that the primary key is (A,B), determine any alternate keys. (4Marks)
(b) Normalize the relation T up to 2NF relations only. Indicate the primary key of each relation. (4marks)
(c) Further normalize the result of (b) above up to 3NF only. Indicate the primary key of each relation. (4marks)
(d) Further normalize the result of (c) above up to BCNF only. Indicate the primary key of each relation. (4 marks)
(e) State two further problems that can occur in BCNF relations requiring further normalization beyond BCNF. (4 marks)
Question 4 (20 marks)
This question is based on Section 2 of Block 3. It assesses your ability to write and understand simple SQL queries (as defined in Section 2). To answer this question, you should use the Hospital database as it is provided in the course software and as summarized in the Hospital database cards.
Write SQL queries, and run them using iSQL 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.
The Hospital relational headings:
Team (TeamCode, TelephoneNo, StaffNo)
ConsistsOf (StaffNo, TeamCode)
Doctor (StaffNo, DoctorName, Position)
Specialist (StaffNo, Specialism)
Patient (PatientId, PatientName, Gender, Height, Weight, StaffNo, WardNo)
Ward (WardNo, WardName, NumberOfBeds)
Nurse (StaffNo, NurseName, WardNo)
Supervises (StaffNo, Supervisor)
Treatment (StaffNo, PatientID, StartDate, Reason)
Prescription (PrescriptionNo, Quantity, DailyDosage, StaffNo, PatientId, StartDate, DrugCode)
Drug (DrugCode, DrugName, Type, Price)
a. Give a list of all drug types without repetition in alphabetical order. (4 marks)
b. Give a list of patient names in ward no. 1 with their gender and height over weight ratio converted from lb/in to kg/m (note: 1kg = 2.20462 lb, and 1m = 39.37008 in). give the name: hwKgPerM to the height over weight ration column. (4 marks)
c. For each Nurse, give a list of his/her StaffNo and the name of his/her supervisor. (4 marks)
d. Write a SQL query to retrieve the names of all female patients and the names of the wards they occupy if the ward has less than 8 beds. (4 marks)
e. Write a SQL query to retrieve for each patient, the Patient’s name, the name of the Doctor who is responsible for him/her and the Name of his/her ward. Do not use the key word join; rather, put all your join conditions in the where clause. (4 marks)
Question 5 (20 marks)
This question tests your knowledge and understanding of the data analysis topics in Block 4 and the topics of block 5. It also requires you to check your e-library.
a- Explain what weak entity types are and how you can identify them in the Conceptual Data Model (CDM). (4marks)
b- Explain the differences between the XML data model and the relational data model. (4 marks)
c- Referring to your course learning materials and the e-library and/or other references, compare the following approaches to define XML documents: DTD, XML Schema, Relax NG and Schematron. (8 marks)
d- Explain what ODBC is and why it is needed. (4 marks)
Reference sheet
Properties of Functional Dependencies:
Property 1: combining functional dependencies
If A B and A C, then A B, C
Property 2: extending determinants
If A C and A is a subset of B, then B C
Property 3: transitivity
If A B and B C then A C
Property 4: augmentation
If A B, then A, C B, C
Normal Forms:
1NF: A relation is in first normal form (1NF) if and only if it has no duplicate tuples and in each tuple, each value of every attribute is a single value.
2NF: A relation is in second normal form (2NF) if and only if every non-primary key attribute is fully functionally dependent on the primary key.
3NF: A relation is in third normal form (3NF) if and only if it is in 2NF and no nonprimary key attribute is transitively dependent on the primary key.
Definition:
An attribute A is transitively dependent (TD) on a set of attributes X in a relation R if there is a set of attributes Y such that all the following properties hold:
TD(i) X Y and Y A.
TD(ii) It is not true that Y X.
TD(iii) A is not an attribute of either X or Y.
We included TD(ii) to rule out the situation where Y is an alternate key.
BCNF: A relation is in Boyce–Codd normal form (BCNF) if and only if each irreducible determinant of a non-trivial FD is a candidate key.
Definitions:
A determinant A in A B is irreducible if there is no proper subset S of A such that S B
A trivial FD is one in which the right hand side is a subset of the left hand side

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

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






خدمات مجانية – حلول واجبات الجامعة العربية المفتوحة
لجميع تخصصات الجامعة ولجميع فروع الجامعة
حلول واجبات – مشاريع تخرج – ملخصات هامة
http://tutor.123.st/
Mobile: 00966542495275  or
Watsapp: 00966542495275
smsm.hamdy66@yahoo.com
حلول مضمونة وغير مكررة وغير متشابهة لجميع واجبات الجامعة
متوفرمدرسين ومدرسات لجميع المواد والتخصصات
KSA-Kuwait-Bahrain-Oman-Jordon-Lebanon-Egypt
الرجوع الى أعلى الصفحة اذهب الى الأسفل
معاينة صفحة البيانات الشخصي للعضو http://tutor.123.st
 
حل واجب m359 ------- m359 النموذجي
الرجوع الى أعلى الصفحة 
صفحة 1 من اصل 1

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