حل واجبات الجامعة العربية المفتوحة
حل واجبات الجامعه العربية المفتوحه مع الشرح
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
اتصل : 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
Course Code: M359
Course Title: Relational Databases: theory and practice
Tutor Marked Assignment
Cut-Off Date: 27, November 2014 Total Marks:100
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
ates
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
حل واجبات الجامعة العربية المفتوحة
حل واجبات الجامعه العربية المفتوحه مع الشرح
(.turnitin./ ) فحص التشابه وفقا لنظام الجامعة عن طريق موقع كشف التشابه
اتصل : 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
