أسواق
24-03-2013, 12:00 PM
M359 Relational datas: theory and practice
TMA Spring 2013
Question 1
This question covers Sections 1 and 2 of Block 1. It assesses your understanding of various concepts covered in those sections and your ability to relate those concepts together.
Data quality issues are described in section 2.3 of Block 1. Briefly explain the problems could you face if each of the quality issues are not met in your SIS page.
(note: any relevant examples could be accepted)
Briefly describe the term “Geographic Information System (GIS)”. Also provide two uses of GIS. You will also need to check your e-library or external resources to provide an adequate answer to this question. Zero mark will be awarded for the answers without proper referencing. Harvard
reference style is required
Describe the importance of data warehousing and data mining in business organizations.
Question 2:
AOU is planning to create a conference management system to keep information about the conferences such as papers presented in the conference, d ate of conference, etc. The conferences are cond ucted in any of the seven branches. One branch may conduct several conferences. Each conference is id entified by a conference ID. Other d etails to be stored are , field, year, start date, end d ate and the branch cond ucting the conference. The branch d etails to be stored are the organizing d epartment, contact person, conference , email add ress, and telephone number. The contact person could be the branch director or the programme coord inator
A conference would receive lots of paper to be submitted to the conference, but only selected number of these papers will be accepted. Paper d etails are paper ID, title, author , and number of pages. The paper may have secondary authors. In ad d ition, each paper is given a type (for example S: Survey, B: Brief, F: Full). A paper can be submitted in only one conference and many papers may be submitted to the same conference. Once a paper is submitted in a conference, the system sends a
message to the author acknowledging the paper submission. If a paper is accepted , at least one author should attend the conference to present the paper. The system needs to keep information about the author who presented the paper in the conference. Each author is id entified by a unique author ID, Also has a , ad d ress, email ad dress, affiliation and contact telephone number of this affiliation. An author can write one or more research papers and a paper have one main author and one or more secondary authors.
The system should also store the number of papers submitted and accepted for each conference along with the paper ID, author ID, conference date, number of attend ees and the conference for archiving purpose.
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.
AOU is planning to create a conference management system to keep information about the conferences such as papers presented in the conference, d ate of conference, etc. The conferences are conducted in any of the seven branches. One branch may conduct several conferences. Each conference is identified by a conference ID. Other details to be stored are , field, year, start date, end d ate and the branch conducting the conference. The branch details to be stored are the organizing department, contact person, conference , email address, and telephone number. The contact person could be the branch director or the programme coordinator
A conference would receive lots of paper to be submitted to the conference, but only selected number of these papers will be accepted. Paper details are paper ID, title, author , and number of pages. The paper may have secondary authors. In addition, each paper is given a type (for example S: Survey, B: Brief, F: Full). A paper can be submitted in only one conference and many papers may be submitted to the same conference. Once a paper is submitted in a conference, the system sends a
message to the author acknowledging the paper submission. If a paper is accepted , at least one author should attend the conference to present the paper. The system needs to keep information about the author who presented the paper in the conference. Each author is identified by a unique author ID, Also has a , address, email ad dress, affiliation and contact telephone number of this affiliation. An author can write one or more research papers and a paper have one main author and one or more secondary authors.
The system should also store the number of papers submitted and accepted for each conference along with the paper ID, author ID, conference date, number of attend ees and the conference for archiving purpose.
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.
Question 3
Give an E-R diagram and the simplest possible representative occurrence diagram for each of the following situations; State any assumptions you made.
Relationship between AOU-ITC student and their graduation project (T471).
Relationship between AOU-ITC tutors and graduation project (T471).
Relationship between External Examiner and ITC graduation project (T471) in AOU
Relationship between assessment (MTA, TMA and Final Exam) and graduation project (T471) in AOU
Question 4
Assume the following relation R is taken from AOU data
R(StudentID,DepartmentID,TutorID,CourseID,Enrollme ntDate,StartDate, FinalExam)with the following FDs
StudentID, CourseID EnrollmentDate
DepartmentID TutorID
DepartmentID, EnrollmentDate StartDate
StudentID, StartDate FinalExam
1. What are the candidate keys of R?
2. Provide a BCNF lossless-join decomposition for R(StudentID,DepartmentID,TutorID,CourseID,Enrollme ntDate,StartDate,FinalExam). Show your steps.
Question 5
Given the following relational schema for part of a University data
Tutor(TutorID, Tutor, Position, Salary)
Course(CourseCode, CourseDeion, Credit)
CourseOffered(CourseCode, Semester, TutorID)
Assumption:
Each course has only one tutor in each semester. All tutors have different salaries, all tutors have different s, all courses have different deions, and position can take values FROM “Full”, “Part”, and “LabAssistant”.
Display those tutors’ ID who is a tutor for ‘M359’ but not for ‘M257’.
Display those courses whose tutors are only Part Time tutors.
List all the course s for Prof.Mark in Spring 2012.
Display those courses that have been offered in all semesters.
Display the s of full time tutors of ‘M105’ course.
Question 6
Write SQL queries, and run them using iSQL against the University data. Include in your answer BOTH the SQL query you wrote and the output table that results. You MUST use meaningful column s, which may require using column aliases in the SQL query.
Write a SQL query to list all staff ids and their s for all staff who are tutors for the course “C4”
Write a SQL query to find the ids for all students who achieved the lowest mark on the assignment among all students in the course ‘C2’, along with the course code and the assignment mark.
Write a SQL query to find the number of students attended the exam for the courses c2 and c4, your result should include the course codes also.
List the course code, number of students registered in each course along with their tutor.
Write a SQL query to list the student ID, student , email address whose email address is in ‘.com’ domain and registered for course with course code C4. Output should show the course code and the enrollment date.
السلام عليكم متوفر لدينا حلول رائعة جدا جدا لواجب m359 أهلا وسهلا بك إلى منتدي حل واجبات الجامعة العربية المفتوحة || tma4u,-00966544321455- 0544321455- حل واجب m359 TMA حل واجب m359 TMA01 AOU AOUA.COM 2013
متوفر لدينا حلول رائعة جدا جدا جدا لواجب m359 باشراف المهندس الخبير (مدرس لمادة m359( درجة الواجب لا تقل عن 98 من 100 ان شاء الله االحلول حل واجب m359 TMA حل واجب m359 TMA01
حل واجب m359 -2013 منتدي حل واجبات الجامعة العربية المفتوحة حل واجب m359 TMA حل واجب m359 TMA01
حل واجب m359 مدرس خاص m359 ايميل [email protected] او اتصل : 0544321455 - 00966544321455
حل واجب m359 مدرس خاص m359 ايميل [email protected] او اتصل : 0544321455 - 00966544321455 m359
مدرس خاص [email protected] او اتصل : 0544321455 - 00966544321455شرح مواد الجامعة العربية m359
حل واجب m359 TMA حل واجب m359 TMA01
مدرس خاص خصوصي [email protected] او اتصل : 0544321455 - 00966544321455 شرح المادة حل واجبات حل واجب الجامعة العربية m359
خدمات مجانية – حلول واجبات الجامعة - كل الجامعات الرياض الدمام جدة حائل جده الأحساء المدينة المنورة لبنان الكويت البحرين عمان مصر السعودية الأردن بيروت المنامة القاهرة مسقط
لجميع تخصصات الجامعة ولجميع فروع الجامعة
حلول واجبات – مشاريع تخرج – ملخصات هامة
حل واجب m359 tma
Mobile: 00966544321455 or 0544321455
[email protected] او اتصل : 0544321455 - 00966544321455
حلول مضمونة وغير مكررة وغير متشابهة لجميع واجبات الجامعة
متوفرمدرسين ومدرسات لجميع المواد والتخصصات
KSA-Kuwait-Bahrain-Oman-Jordon-Lebanon-Egypt
قسم خاص لواجبات التربية لجميع التخصصات ولجميع المستويات
حل واجب m359 tma
مهندس مدرس خاص ([email protected] او اتصل : 0544321455 - 00966544321455) حل واجب m359 الجامعة العربية المفتوحة
حل واجب m359 مدرس خاص خصوصي ([email protected] او اتصل : 0544321455 - 00966544321455)حل واجب الجامعةالعربية المفتوحة m359
مدرس خاص خصوصي m359 m حل واجب حلول واجبات شرح ([email protected] او اتصل : 0544321455 - 00966544321455)الجامعة العربية المفتوحة
حل واجب m359 حل واجب m359 حل واجب m359 حل واجب m359 حل واجب m359
مدرس خاص ([email protected] او اتصل : 0544321455 - 00966544321455)حل واجب الجامعة العربية المفتوحة m359
حل واجباتالجامعة العربية المفتوحة مع الشرح ج [email protected] او اتصل : 0544321455 - 00966544321455 مدرس خاص خصوصى - m359
للمفاهمة [email protected] او اتصل : 0544321455 - 00966544321455
حل واجب m359 حلول واجبات الجامعة العربية المفتوحة ([email protected] او اتصل : 0544321455 - 00966544321455) مدرس خصوصي مدرس خاص
مدرس خاص لطلاب الجامعة العربية المفتوحة
شرح مواد الجامعةالعربية المفتوحة
حل واجب m359 TMA m359 TMA m359 TMA
حل واجب حلول واجبات الجامعةالعربية المفتوحة m359 m359
مدرس خاص خصوصي [email protected] او اتصل : 0544321455 - 00966544321455شرح المادة حل واجبات واجب الجامعة العربية المفتوحة tma01 tma02 tma3 m359 m359 part m359 part1 part2 -
مدرس خاص خصوصي [email protected] او اتصل : 0544321455 - 00966544321455 شرح المادة حل واجبات حل واجب الجامعةالعربية المفتوحة tma01tma02 tma3 m359 m359 m359 part1 part2
السلام عليكم ورحمة الله وبركاته
متوفرمدرسين ومدرسات لجميع المواد والتخصصات حل واجب m359 tma
KSA-Kuwait-Bahrain-Oman-Jordon-Lebanon-Egypt
حلول واجبات ومشاريع الجامعة العربية المفتوحة حل واجب m359 tma
للحصول على حل الواجب المطلوب : ارسل بريد الكتروني الى:
[email protected] او اتصل : 0544321455 - 00966544321455
تسجيل صوتي لجميع المحاضرات وتسجيل للدروس الخاصة
خدمات مجانية رائعة لجميع المواد والتخصصات والفروع
لـ طلاب الجامعة العربية المفتوحة
حلول واجبات – مشاريع تخرج – ملخصات هامة
حلول واجبات الجامعة العربية المفتوحة لطلاب الكويت و طالبات
للحصول على حل الواجب المطلوب : ارسل بريد الكتروني الى
[email protected] او اتصل : 0544321455 - 00966544321455
حل واجب m359 TMA01 ايميل : [email protected] او اتصل : 0544321455 - 00966544321455 الكويت مدرس خاص لحلول الواجبات
TMA Spring 2013
Question 1
This question covers Sections 1 and 2 of Block 1. It assesses your understanding of various concepts covered in those sections and your ability to relate those concepts together.
Data quality issues are described in section 2.3 of Block 1. Briefly explain the problems could you face if each of the quality issues are not met in your SIS page.
(note: any relevant examples could be accepted)
Briefly describe the term “Geographic Information System (GIS)”. Also provide two uses of GIS. You will also need to check your e-library or external resources to provide an adequate answer to this question. Zero mark will be awarded for the answers without proper referencing. Harvard
reference style is required
Describe the importance of data warehousing and data mining in business organizations.
Question 2:
AOU is planning to create a conference management system to keep information about the conferences such as papers presented in the conference, d ate of conference, etc. The conferences are cond ucted in any of the seven branches. One branch may conduct several conferences. Each conference is id entified by a conference ID. Other d etails to be stored are , field, year, start date, end d ate and the branch cond ucting the conference. The branch d etails to be stored are the organizing d epartment, contact person, conference , email add ress, and telephone number. The contact person could be the branch director or the programme coord inator
A conference would receive lots of paper to be submitted to the conference, but only selected number of these papers will be accepted. Paper d etails are paper ID, title, author , and number of pages. The paper may have secondary authors. In ad d ition, each paper is given a type (for example S: Survey, B: Brief, F: Full). A paper can be submitted in only one conference and many papers may be submitted to the same conference. Once a paper is submitted in a conference, the system sends a
message to the author acknowledging the paper submission. If a paper is accepted , at least one author should attend the conference to present the paper. The system needs to keep information about the author who presented the paper in the conference. Each author is id entified by a unique author ID, Also has a , ad d ress, email ad dress, affiliation and contact telephone number of this affiliation. An author can write one or more research papers and a paper have one main author and one or more secondary authors.
The system should also store the number of papers submitted and accepted for each conference along with the paper ID, author ID, conference date, number of attend ees and the conference for archiving purpose.
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.
AOU is planning to create a conference management system to keep information about the conferences such as papers presented in the conference, d ate of conference, etc. The conferences are conducted in any of the seven branches. One branch may conduct several conferences. Each conference is identified by a conference ID. Other details to be stored are , field, year, start date, end d ate and the branch conducting the conference. The branch details to be stored are the organizing department, contact person, conference , email address, and telephone number. The contact person could be the branch director or the programme coordinator
A conference would receive lots of paper to be submitted to the conference, but only selected number of these papers will be accepted. Paper details are paper ID, title, author , and number of pages. The paper may have secondary authors. In addition, each paper is given a type (for example S: Survey, B: Brief, F: Full). A paper can be submitted in only one conference and many papers may be submitted to the same conference. Once a paper is submitted in a conference, the system sends a
message to the author acknowledging the paper submission. If a paper is accepted , at least one author should attend the conference to present the paper. The system needs to keep information about the author who presented the paper in the conference. Each author is identified by a unique author ID, Also has a , address, email ad dress, affiliation and contact telephone number of this affiliation. An author can write one or more research papers and a paper have one main author and one or more secondary authors.
The system should also store the number of papers submitted and accepted for each conference along with the paper ID, author ID, conference date, number of attend ees and the conference for archiving purpose.
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.
Question 3
Give an E-R diagram and the simplest possible representative occurrence diagram for each of the following situations; State any assumptions you made.
Relationship between AOU-ITC student and their graduation project (T471).
Relationship between AOU-ITC tutors and graduation project (T471).
Relationship between External Examiner and ITC graduation project (T471) in AOU
Relationship between assessment (MTA, TMA and Final Exam) and graduation project (T471) in AOU
Question 4
Assume the following relation R is taken from AOU data
R(StudentID,DepartmentID,TutorID,CourseID,Enrollme ntDate,StartDate, FinalExam)with the following FDs
StudentID, CourseID EnrollmentDate
DepartmentID TutorID
DepartmentID, EnrollmentDate StartDate
StudentID, StartDate FinalExam
1. What are the candidate keys of R?
2. Provide a BCNF lossless-join decomposition for R(StudentID,DepartmentID,TutorID,CourseID,Enrollme ntDate,StartDate,FinalExam). Show your steps.
Question 5
Given the following relational schema for part of a University data
Tutor(TutorID, Tutor, Position, Salary)
Course(CourseCode, CourseDeion, Credit)
CourseOffered(CourseCode, Semester, TutorID)
Assumption:
Each course has only one tutor in each semester. All tutors have different salaries, all tutors have different s, all courses have different deions, and position can take values FROM “Full”, “Part”, and “LabAssistant”.
Display those tutors’ ID who is a tutor for ‘M359’ but not for ‘M257’.
Display those courses whose tutors are only Part Time tutors.
List all the course s for Prof.Mark in Spring 2012.
Display those courses that have been offered in all semesters.
Display the s of full time tutors of ‘M105’ course.
Question 6
Write SQL queries, and run them using iSQL against the University data. Include in your answer BOTH the SQL query you wrote and the output table that results. You MUST use meaningful column s, which may require using column aliases in the SQL query.
Write a SQL query to list all staff ids and their s for all staff who are tutors for the course “C4”
Write a SQL query to find the ids for all students who achieved the lowest mark on the assignment among all students in the course ‘C2’, along with the course code and the assignment mark.
Write a SQL query to find the number of students attended the exam for the courses c2 and c4, your result should include the course codes also.
List the course code, number of students registered in each course along with their tutor.
Write a SQL query to list the student ID, student , email address whose email address is in ‘.com’ domain and registered for course with course code C4. Output should show the course code and the enrollment date.
السلام عليكم متوفر لدينا حلول رائعة جدا جدا لواجب m359 أهلا وسهلا بك إلى منتدي حل واجبات الجامعة العربية المفتوحة || tma4u,-00966544321455- 0544321455- حل واجب m359 TMA حل واجب m359 TMA01 AOU AOUA.COM 2013
متوفر لدينا حلول رائعة جدا جدا جدا لواجب m359 باشراف المهندس الخبير (مدرس لمادة m359( درجة الواجب لا تقل عن 98 من 100 ان شاء الله االحلول حل واجب m359 TMA حل واجب m359 TMA01
حل واجب m359 -2013 منتدي حل واجبات الجامعة العربية المفتوحة حل واجب m359 TMA حل واجب m359 TMA01
حل واجب m359 مدرس خاص m359 ايميل [email protected] او اتصل : 0544321455 - 00966544321455
حل واجب m359 مدرس خاص m359 ايميل [email protected] او اتصل : 0544321455 - 00966544321455 m359
مدرس خاص [email protected] او اتصل : 0544321455 - 00966544321455شرح مواد الجامعة العربية m359
حل واجب m359 TMA حل واجب m359 TMA01
مدرس خاص خصوصي [email protected] او اتصل : 0544321455 - 00966544321455 شرح المادة حل واجبات حل واجب الجامعة العربية m359
خدمات مجانية – حلول واجبات الجامعة - كل الجامعات الرياض الدمام جدة حائل جده الأحساء المدينة المنورة لبنان الكويت البحرين عمان مصر السعودية الأردن بيروت المنامة القاهرة مسقط
لجميع تخصصات الجامعة ولجميع فروع الجامعة
حلول واجبات – مشاريع تخرج – ملخصات هامة
حل واجب m359 tma
Mobile: 00966544321455 or 0544321455
[email protected] او اتصل : 0544321455 - 00966544321455
حلول مضمونة وغير مكررة وغير متشابهة لجميع واجبات الجامعة
متوفرمدرسين ومدرسات لجميع المواد والتخصصات
KSA-Kuwait-Bahrain-Oman-Jordon-Lebanon-Egypt
قسم خاص لواجبات التربية لجميع التخصصات ولجميع المستويات
حل واجب m359 tma
مهندس مدرس خاص ([email protected] او اتصل : 0544321455 - 00966544321455) حل واجب m359 الجامعة العربية المفتوحة
حل واجب m359 مدرس خاص خصوصي ([email protected] او اتصل : 0544321455 - 00966544321455)حل واجب الجامعةالعربية المفتوحة m359
مدرس خاص خصوصي m359 m حل واجب حلول واجبات شرح ([email protected] او اتصل : 0544321455 - 00966544321455)الجامعة العربية المفتوحة
حل واجب m359 حل واجب m359 حل واجب m359 حل واجب m359 حل واجب m359
مدرس خاص ([email protected] او اتصل : 0544321455 - 00966544321455)حل واجب الجامعة العربية المفتوحة m359
حل واجباتالجامعة العربية المفتوحة مع الشرح ج [email protected] او اتصل : 0544321455 - 00966544321455 مدرس خاص خصوصى - m359
للمفاهمة [email protected] او اتصل : 0544321455 - 00966544321455
حل واجب m359 حلول واجبات الجامعة العربية المفتوحة ([email protected] او اتصل : 0544321455 - 00966544321455) مدرس خصوصي مدرس خاص
مدرس خاص لطلاب الجامعة العربية المفتوحة
شرح مواد الجامعةالعربية المفتوحة
حل واجب m359 TMA m359 TMA m359 TMA
حل واجب حلول واجبات الجامعةالعربية المفتوحة m359 m359
مدرس خاص خصوصي [email protected] او اتصل : 0544321455 - 00966544321455شرح المادة حل واجبات واجب الجامعة العربية المفتوحة tma01 tma02 tma3 m359 m359 part m359 part1 part2 -
مدرس خاص خصوصي [email protected] او اتصل : 0544321455 - 00966544321455 شرح المادة حل واجبات حل واجب الجامعةالعربية المفتوحة tma01tma02 tma3 m359 m359 m359 part1 part2
السلام عليكم ورحمة الله وبركاته
متوفرمدرسين ومدرسات لجميع المواد والتخصصات حل واجب m359 tma
KSA-Kuwait-Bahrain-Oman-Jordon-Lebanon-Egypt
حلول واجبات ومشاريع الجامعة العربية المفتوحة حل واجب m359 tma
للحصول على حل الواجب المطلوب : ارسل بريد الكتروني الى:
[email protected] او اتصل : 0544321455 - 00966544321455
تسجيل صوتي لجميع المحاضرات وتسجيل للدروس الخاصة
خدمات مجانية رائعة لجميع المواد والتخصصات والفروع
لـ طلاب الجامعة العربية المفتوحة
حلول واجبات – مشاريع تخرج – ملخصات هامة
حلول واجبات الجامعة العربية المفتوحة لطلاب الكويت و طالبات
للحصول على حل الواجب المطلوب : ارسل بريد الكتروني الى
[email protected] او اتصل : 0544321455 - 00966544321455
حل واجب m359 TMA01 ايميل : [email protected] او اتصل : 0544321455 - 00966544321455 الكويت مدرس خاص لحلول الواجبات