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

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

شاطر | 
 

 Course Code: M359

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


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

مُساهمةموضوع: Course Code: M359   الأحد أكتوبر 12, 2014 5:28 pm

Faculty of Computer Studies
Course Code: M359
Course Title: Relational Databases: theory and practice
Tutor Marked Assignment

Cut-Off Date: 27, November 2014 Total Marks:100

Contents
Question 1……………………..………………………………………..……… 2
Question 2……………………………..………………..……………………… 2
Question 3………………………………..………………..…………………… 2
Question 4………………..……………………………………..……………… 3
Question 5 ……………………………………………………………………… 4
Question 6 ……………………………………………………………………… 4
Question 7 ……………………………………………………………………… 4

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 provide all references in case you use and quote 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:

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. What is meant by cloud database? Briefly describe the challenges to develop cloud databases.
2. Analyse the industry practices in cloud databases. Write your conclusions after proper analysis
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.

A health club database keeps track of the health club’s employees, members, activities and special events. Suppose that after the requirements collection and analysis phase, the database designers provided the following description of the part of the health cub to be represented by the database. The health club is organized into departments such as administration, finance, training, recreation etc. Each department has a unique name a unique number and a particular employee who manages the department. The system keeps track of the start date when that employee began managing the department. A department controls a number of activity sessions, each of which has a description, a unique number and a single location. The database stores each employees name, ID number, address, salary, gender and birth date. An employee is assigned to one department but may work on several activities, which are not necessarily controlled by the same department. The system keeps track of the number of hours per week that an employee works on each activity session. The system also keeps track of the direct supervisor of each employee. It also keeps track of the members of the club. Each member is identified by a unique Id. Other details to be stored are the first name, last name, gender, date of birth, height, weight and medical condition. The health club conducts medical seminars and workshops time to time, the seminar ID, topic, date of seminar and the speaker information to be stored in the system. The members can join for special offer package program or regular one or they can just attend only seminar/workshops.

Question 3 (10 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.
An insurance firm has been operating with a large market share and a good profit for the last 10 years. The business includes Co-insurance for risks shared between insurers, Dual insurance for risks having two or more policies with same coverage, Self-insurance for situations where risk is not transferred to insurance companies and solely retained by the entities or individuals themselves and Reinsurance for situations when Insurer passes some part of or all risks to another Insurer called Reinsurer. The firm is now faced with the e-commerce revolution and there is a need to implement new technology in order to restore the market position in the competitive environment.
1. Outline what would an Information System (IS) strategy need to address in order to restore the firm’s market position and increase revenues?
2. Outline the issues that would be addressed by an Information Management (IM) strategy to complement your IS strategy above.
3. Briefly outline an Information Technology (IT) strategy to meet the requirements of the IS strategy within the IM structure?
Question 4 (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


Convert the following relational representation back into a CDM using two relationships and three entity types.

relation Customer
NationalID:NationalIDs
CustomertName: CustomerNames
primary key NationalID

relation Approved
NationalID:NationalIDs
LoanNo: LoanNos
primary key LoanNo
foreign key NationalID references Customer
foreign key LoanNo references Loan
constraint ((project Loan over LoanNo) difference (project Approved over LoanNo)) is empty

relation Loan
LoanNo: LoanNos
LoanType:LoanTypes
DateofLoan:Dates
primary key LoanNo


Question 5 20 Marks
This question assesses your understanding of normal forms as discussed in Section 5 of Block 2. Kindly note, it is mandatory to write the answers using your own words, if any quoted text is used to support your answer it should be written with proper referencing.
4.1 Describe the concept of functional dependency.
4.2 How is the concept of functional dependency associated with the process of normalization?
4.3 Describe how a database designer typically identifies the set of functional dependencies associated with a relation.
4.5 Relation R is given with the following functional dependencies. Prove that R is in 1NF and normalize R into higher level normal forms upto 3NF.

StaffContract (NIN, ContractNo, hours, EmployeeName, CompanyID, CompanyLocation)

NIN, ContractNo  hours
NIN  Employee Name
ContractNo  CompanyId, CompanyLocation
ContractNo  CompanyID.
CompanyID  CompanyLocation.

Question 6 10 Marks
This question assesses your understanding of manipulating relations and constraints as discussed in Sections 3-5 of Block 2. Students are required to use the attached database for answering this part of the TMA
Given the following relational schema for part of the University database, Region (RegionNumber, Address, Telephone, EmailAddress)
Student (StudentId, Name, Address, EmailAddress, RegistrationDate)
Staff (StaffNumber, Name, Address, EmailAddress, Telephone)
Course (CourseCode, Title, Credit)
Enrolment (StudentId, CourseCode, EnrolmentDate)
Assignment (StudentId, CourseCode, AssignmentNumber, Mark)
Examination (StudentId, CourseCode, ExaminationLocation, Mark)

Solve the following questions using Relation Algebra.

List all student details who are registered in Region ‘2’
List the course title of the courses taught by tutor ‘XYZ’
List students submitted assignment and not attended the examination
List the student name and email address of students registered after ‘10/10/2010’
List the staff names who are teaching the course ‘TU170’

Question 7 20 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 MySQL against the University 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 University Database for answering this part of the TMA
6.a. To list the total number of students submitted the assignment for the course ‘C4’
6.b. To list all students’ ID and names who have enrolled before January 2005
6.c. To list first three characters of the student names along with total number of characters in each name
6.d. To list the names of tutors who is teaching ‘Syntax’ course
6.e. To list the names and mark of the students whose examination mark is greater than 60

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

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






خدمات مجانية – حلول واجبات الجامعة العربية المفتوحة
لجميع تخصصات الجامعة ولجميع فروع الجامعة
حلول واجبات – مشاريع تخرج – ملخصات هامة
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
 
Course Code: M359
استعرض الموضوع السابق استعرض الموضوع التالي الرجوع الى أعلى الصفحة 
صفحة 1 من اصل 1
 مواضيع مماثلة
-
» kaspersky anti virus 9.0.0736+code d activation arjo arade
» برنامجréussire son code de la route رائع لمن يريد تعلم السياقة ألي مش راح يدخل لن يستطيع قيادة
» كل ما يتعلق بكارت التيستر بالصورة
» لفتح الرقم السرى لاى جهاز نوكيا !!!!
» جميع اكود ارقام هواتف دول العالم

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