GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

Q14

Diocar Cruz 13 questions

Take the quiz

Questions in this quiz (13)

  1. 1What best matches with the Relational Database Terminologies A, B, and C depicted in the representation below?Image for question 1
    1. AA:Tuple, B:Relation, C:Attribute
    2. BA:Relation, B:Attribute, C:Tuple
    3. CA: Relation, B: Tuple C: Attribute
    4. DA:Tuple B: Attribute C: Relation
  2. 2Chris is trying to normalize the following table to the 3NF.

    Which of the following is not correct?    Image for question 2
    1. ABecause there is no muti-valued attribute in this table, it is already 1NF
    2. BBecause the primary key of the table (PrescriptionNumber) is not a composite key, there is no partial dependencies to remove; therefore it is already 2NF
    3. CBecause the two non-key attributes (CustomerName and CustomerAddress) are dependent on a non-key attribute (CustomerCellPhone), there is a transitive dependency to remove in order to to reach 3NF
    4. DBecause the three fields (CustomerName, CustomerCellphone, and CustomeerAddress) will be removed as a separate table, the remaining table will contain PrescriptionNumber, Date, Drug, and Dosage.
  3. 3Chris is trying to normalize the following table to the 3NF.
    The primary key of this table is a composite key(ProjectCode and EmployeeNo).


    In this table, it appears that HourlyRate for an employee differs depending on who he is and which project he works for.

    Which key is 'fully dependent' on the primary key (i.e., Full Dependency)?    Image for question 3
    1. AProject Title
    2. BProject Budget
    3. CEmployee Name
    4. DHourly Rate
  4. 4In this table, which is not showing a partial dependency?Image for question 4
    1. AProject Title
    2. BProject Manager
    3. CEmployee Name
    4. DEmployee No
  5. 5In this table, which is showing a transitive dependency?Image for question 5
    1. AProject Code
    2. BProject Budget
    3. CDepartment Name
    4. DHourly Rate
  6. 6The list below represents the name of the fields in each table after normalization is completed.
    Which is not a part of the final normalization results?
    1. AProjectCode-ProjectTitle-Project Manager- Project Budget
    2. BProjectCode-Employee No - Hourly Rate
    3. CEmployee No - Employee Name - Department No
    4. DEmployee Name - Department No - Hourly Rate
    5. EDepartment No - Department Name
  7. 7In order to normalize the employee table, Jay decomposed in into two tables as below.
    Which of the following is a correct statement about this results?    Image for question 7
    1. AThe results violate entity integrity
    2. BThe second table does not have a valid primary key
    3. Cthe three fields (Street, City, Salary) shows partial dependency
    4. DThe original table was a 3NF from the begining
  8. 8Which of the following is not one of the three(3) data anomalies?
    1. AInsertion Anomaly
    2. BUpdate Anomaly
    3. CDeletion Anomaly
    4. DModification Anomaly
  9. 9Which of the following represent Referential Integrity of relational database?
    1. AALL values of a data field should come from the same Domain
    2. BPrimary key can NOT be Null
    3. CEach foreign key value must match with a primary key value in other table
    4. DEvery table has to have a valid primary key
  10. 10In a distributed database , different parts of a single logical database are stored in different geographic locations. There are a variety of approaches to locating the different parts of the database, all with different associated advantages and disadvantages.

    Regardless of options, it requires sophisticated Concurrency Control , which refers to problems that can occur when two or more transactions or users attempt to update a piece of data simultaneously.
    1. Adistributed database
    2. BConcurrency Control

Information

Description
INFORMATION SYSTMS
Language
English
Views
11
Rating
No ratings yet
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?