Scribd Logo
Upload

Welcome to Scribd!

  • 46 views

    Consider An Example Relation 1. Create 3 Fragments of Approximately Equal Size by Horizontal Fragmentation. Describe The

    Uploaded by

    Saad Mohamed Saad
    This document contains a lab exam for a distributed data management course. The exam consists of 5 questions. Question 1 asks students to horizontally fragment a sample student relation into 3 equal fragments and describe the rules for fragmentation. Question 2 asks students to convert a sample appointment table to 3NF and identify the resulting number of tables. Question 3 asks students to graphically show the distributed database integration process. Question 4 asks students to explain translation, intermediate schema, and global conceptual schema. Question 5 asks students to calculate the data transfer for a join query on sample employee and department tables located across different sites, and to calculate the data transfer for the same query using a semi-join operation.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Consider An Example Relation 1. Create 3 Fragments of Approximately Equal Size by Horizontal Fragmentation. Describe The

    Uploaded by

    Saad Mohamed Saad
    46 views4 pages
    This document contains a lab exam for a distributed data management course. The exam consists of 5 questions. Question 1 asks students to horizontally fragment a sample student relation into 3 equal fragments and describe the rules for fragmentation. Question 2 asks students to convert a sample appointment table to 3NF and identify the resulting number of tables. Question 3 asks students to graphically show the distributed database integration process. Question 4 asks students to explain translation, intermediate schema, and global conceptual schema. Question 5 asks students to calculate the data transfer for a join query on sample employee and department tables located across different sites, and to calculate the data transfer for the same query using a semi-join operation.

    Original Title

    File (1)

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains a lab exam for a distributed data management course. The exam consists of 5 questions. Question 1 asks students to horizontally fragment a sample student relation into 3 equal fragments and describe the rules for fragmentation. Question 2 asks students to convert a sample appointment table to 3NF and identify the resulting number of tables. Question 3 asks students to graphically show the distributed database integration process. Question 4 asks students to explain translation, intermediate schema, and global conceptual schema. Question 5 asks students to calculate the data transfer for a join query on sample employee and department tables located across different sites, and to calculate the data transfer for the same query using a semi-join operation.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    46 views4 pages

    Consider An Example Relation 1. Create 3 Fragments of Approximately Equal Size by Horizontal Fragmentation. Describe The

    Uploaded by

    Saad Mohamed Saad
    This document contains a lab exam for a distributed data management course. The exam consists of 5 questions. Question 1 asks students to horizontally fragment a sample student relation into 3 equal fragments and describe the rules for fragmentation. Question 2 asks students to convert a sample appointment table to 3NF and identify the resulting number of tables. Question 3 asks students to graphically show the distributed database integration process. Question 4 asks students to explain translation, intermediate schema, and global conceptual schema. Question 5 asks students to calculate the data transfer for a join query on sample employee and department tables located across different sites, and to calculate the data transfer for the same query using a semi-join operation.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 4

    University of Sadat City

    Faculty of Computers and Artificial Intelligence (FCAI)


    Course: Distributed Data Management Lab Exam

    Student Name

    Answer all questions.


    Question No.#1

    Consider an example relation.


    STUDENT (StudNO, FirstName, LastName, Course, Grade)
    Containing 1.000 rows, where StudNO is the primary key ranging from 1 to 1.000.
    1. Create 3 fragments of approximately equal size by Horizontal Fragmentation. Describe the
    three fragments by using the appropriate relational algebra operation.
    2. Name the 3 Rules for Fragmentation and explain them based on the horizontal
    fragmentation.
    Question No.#2
    Appt Appt Appt Planned Appt Patient First Last Doctor Doctor
    No Date Time Duration Type ID Nm Nm Phone ID Nm
    1 12/1/2015 3:00 AM 1.00 Physical 466927 Lisa Garcia 562-3456 C678 Chapman
    2 12/1/2015 3:00 AM 0.25 Shot 456789 Sue Carey 432-1234 A528 Lopez
    3 12/1/2015 3:15 AM 0.50 Flu 194756 Brandon Pierre 432-7877 S626 Smith
    4 12/2/2015 10:00 AM 0.50 Migraine 329657 Marcus Schwartz 239-5502 A528 Lopez
    5 12/2/2015 10:15 AM 0.25 Shot 987453 Mike Jones 456-0202 G123 Gray
    6 12/2/2015 10:30 AM 0.25 Shot 384788 Tonya Johnson 432-8806 S626 Smith
    7 12/2/2015 10:45 AM 0.50 Flu 438754 Iliana Hnatt 823-4303 C678 Chapman
    8 12/2/2015 11:00 AM 1.00 Physical 345875 Carla Basich 857-5566 A528 Lopez
    9 12/3/2015 10:30 AM 1.00 Physical 466927 Lisa Garcia 562-3456 C678 Chapman
    10 12/3/2015 9:00 AM 0.50 Migraine 345875 Carla Basich 857-5666 C678 Chapman

    It’s already in 1NF, and 2NF …but you need to understand why!
    Convert this to 3NF. How many tables do you now have?

    Page 1 of 4
    University of Sadat City
    Faculty of Computers and Artificial Intelligence (FCAI)
    Course: Distributed Data Management Lab Exam

    Question No.#3
    Show Graphically Distributed database integration process.
    Question No.#4

    Page 2 of 4
    University of Sadat City
    Faculty of Computers and Artificial Intelligence (FCAI)
    Course: Distributed Data Management Lab Exam

    Explain the following:


    1. Translation
    2. Intermediate Schema
    3. GCS (Global Conceptual Schema)

    Question No.#5
    Consider the following table: the EMPLOYEE and DEPARTMENT.
    Site1: EMPLOYEE
    EID NAME SALARY DID
    EID- 10 bytes
    SALARY- 20 bytes
    DID- 10 bytes

    Page 3 of 4
    University of Sadat City
    Faculty of Computers and Artificial Intelligence (FCAI)
    Course: Distributed Data Management Lab Exam

    Name- 20 bytes
    Total records- 1000
    Record Size- 60 bytes
    Site2: DEPARTMENT
    DID DNAME
    DID- 10 bytes
    DName- 20 bytes
    Total records- 50
    Record Size- 30 bytes

    1. Find the name of employees and their department names. Also, find the amount of
    data transfer to execute this query when the query is submitted to Site 3.

    2. Find the amount of data transferred to execute the same query given in the above
    example using a semi-join operation.

    Page 4 of 4

    You might also like