aou حل واجبات الجامعه العربيه المفتوحه2017/2018
الرئيسيةالرئيسية  اليوميةاليومية  س .و .جس .و .ج  بحـثبحـث  الأعضاءالأعضاء  المجموعاتالمجموعات  التسجيلالتسجيل  دخول  

شاطر | 

  حل واجب M359 tma spring 2016

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

المساهمات : 153
تاريخ التسجيل : 22/08/2016

مُساهمةموضوع: حل واجب M359 tma spring 2016   الجمعة أغسطس 26, 2016 4:24 pm

حل واجب M359 tma spring 2016
TMA Total
Question 1 (16 marks)
Use the block notes and the supplied domain of discourse ******** for the Hospital data**** to answer the following questions:
i. What is a domain of discourse ******** and what is its purpose? Which enduring issue of data management does it relate to? (2 marks)
ii. Why can't we just add the information contained in the domain of discourse ******** to the scenario de******ions? (2 marks)
iii. Identify eight examples of useful pieces of information in the domain of discourse ******** for the Hospital data**** that could not be obtained from the scenario de******ions. (8 marks)
iv. How is the domain of discourse ******** organized? What is the purpose of the occurrence diagrams included in the second part of the domain of discourse ********? (4 marks)
Question 2 (16 marks)
Use the e-library and other resources to answer the following questions about Object Oriented Data**** Management Systems (OODBMs):
i. Explain the main idea of OODBMSs (3 marks)
ii. Explain the main differences between OODBMs and Relational Data**** Management Systems (RDBMSs) (3 marks)
iii. What are the advantages and disadvantages of OODBMS vs. RDBMSs? (3 marks)
i. What types of applications that would better fit the OOBDs than the Relational model (3 marks)
You must provide at least two references in the Harvard style of referencing, excluding your course materials and Wikipedia. At least one of the references should be a recent reference (within the last two years) (4 marks).
Question 3 (16 marks)
Develop a conceptual model for the following scenario. The data model should consist of the usual 5 components: E-R diagram, Entity Types (including entity type identifiers), assumptions, additional constraints, and limitations:
A travel agency arranges package tours for tourists. It is desired to build a data**** to keep track of branches, staff, tourists, bookings, tour groups, tour packages and package segments. Obviously, a branch can make many bookings. The travel agency has multiple
1. Each branch hires a number of staff members. A branch is identified by a unique branch number from 00 to 99, and has a ****, a ******** and a telephone number. Tourists can join package tour groups only through any one of the agency's branches and the booking branch should be recorded for each booking.
2. Each staff must be hired by exactly a single branch. A staff can be a package coordinator for a number of tour packages and may or may not be a tour guide for one or more tour groups at different times. Naturally, a staff cannot be a tour guide for more than one tour at the same time. The system must ensure that no staff is assigned to time-overlapping groups simultaneously. For each staff, the data**** should record the staff id, ****, address, telephone and email.
3. Each tourist is assigned a unique id and the travel agency will keep the following information about each tourist: id, ****, address, telephone, nationality and passport number. Each tourist can book a number of tour groups.
4. Each tourist booking must link a tourist with a package group and the branch at which the booking was made. For each booking, we also keep the date booked and the price charged.
5. Each group may have zero or more bookings. Each group must be guided by a single staff and must belong to a single package. Each group has a maximum capacity and the system must ensure that the number of bookings for a group does not exceed this maximum capacity. For each group, the data**** should record the unique group id, the start date, the maximum capacity and the group status. This status could be either open (meaning that tourists can make bookings in the group), closed (meaning that the group is full and not accepting anymore bookings) and cancelled (meaning that the tour group has been cancelled).
6. Each package must be coordinated by one staff. A package can have multiple groups
. Each package consists of a number (at least one) of package segments arranged in a certain order. This order could be indicated by a segment sequence number. Each package is identified by a unique package id consisting of three letters followed by three digits. In addition, the company will keep for each package a **** and a de******ion in the data****.
7. Each package segment has a segment id, a duration in hours, a starting ********, an ending ********, a type and a recommended price. A segment may be part of zero or more packages.
Note: you should expect about 8 entity types, 9 relationship types, 33 attributes, 8 additional constraints, 5 assumptions and 3 limitations in the CDM for this application.
The marks will be allocated as follows:
4 marks for producing correct entity types (including attributes and identifiers)
4 marks for producing correct relationships (including their degree and participation conditions)
4 marks for producing correct additional constraint
2.5 marks for producing reasonable and correct assumptions
1.5 marks for producing correct limitations
Question 4 (16 marks)
i. Convert the following relational representation back into a CDM using three relationships and four entity types. Include the ER diagram, the entity types and the additional constraint sections only. (8 marks)
relation customer
customer_Id: customer_Ids
****: ****s
primary key customer_Id
relation order
order_Id: order_Ids
customer_Id: customer_Ids
date: dates
primary key order_Id
foreign key customer_Id references customer
relation sale-item
order_Id: order_Ids
item_Id: item_Ids
quantity: integer
unit_price: decimal (5, 2)
primary key (order-Id, item-Id)
foreign key order_Id references order
foreign key item_Id references item
constraint ((project order over order_Id) difference (project sale-item over order-Id)) is empty
relation item
item_Id: Item_Ids
item_****: intem_****s
primary key item_Id
ii. use the 1NF relation schema below to answer the following questions: (4 marks)
R (A, B, C, D, E, F, G)
fd1: (A, B)  C, D, E, F, G
fd2: B  C
fd3: D  E
fd4: F  B
a. Normalize the relation R into a set of 2NF relations (1 mark). Show the primary keys. (1 mark)
b. Further normalize the result of the previous step into a set of 3NF relations (1 mark). Show the primary keys (1 mark).
c. Further normalize the results of the previous step into a set of BCNF relations and show the primary keys (2 marks). Are there any problems with your answer that would require further action? (2 marks)
Question 5 (16 marks)
You will need to refer to the Hospital data**** 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. You are required to include screenshots showing the actual output of your queries.
a) List the drug details for all Antibiotic drugs costing more than 1.
b) List the staff numbers of nurses who supervise by other nurses
c) List the patient id sand patient ****s for all female patients assigned to one of the wards (w2, w4 or w7).
d) return a list of patient ****s and the ****s of their treating doctors ordered by doctor ****s
e) get the ids and ****s of all patients not currently receiving any treatment
f) Write a query to get the number of patients treated by each doctor, ordered by doctor ****.
g) Write a query to get the ****s of all patients who have a weight that is higher than the average weight of all other patients who are under the responsibility of the same doctor.
h) Write a query to retrieve the ****s of the drugs with the highest prices for each drug type

الرجوع الى أعلى الصفحة اذهب الى الأسفل
معاينة صفحة البيانات الشخصي للعضو http://wagbat-123.a7larab.net
حل واجب M359 tma spring 2016
الرجوع الى أعلى الصفحة 
صفحة 1 من اصل 1
 مواضيع مماثلة
» خطط التحسن ونظم المتابعة لجميع المجالات2016/2017
» تسريب اقوى مراجعة ديناميكا بخط اليد بها كل اسئلة امتحان ديناميكا 3 ثانوى نظام حديث 2014

صلاحيات هذا المنتدى:لاتستطيع الرد على المواضيع في هذا المنتدى
wagbat.123 :: حل واجبات الجامعه العربيه المفتوحه whats.app: 00966542495275 :: حلول واجبات 2017/2018 AOU(يشاهدة الآن 3537 زائر)-
انتقل الى: