We're Open
+44 7340 9595 39
+44 20 3239 6980

ROWS WITH COMMON VALUES IN THEIR COMMON ATTRIBUTE

  100% Pass and No Plagiarism Guaranteed

ROWS WITH COMMON VALUES IN THEIR COMMON ATTRIBUTE

QUESTION 1. A (n) ________ links tables by selecting only the rows with common values in their common attribute(s).                (0.25 points)

 

  1. Foreign join

 

  1. Outer join

 

  1. natural join

 

  1. equijoin

 

QUESTION 2. A (n) ________ links tables by selecting only the rows with common values in their common attribute(s).                (0.25 points)

 

  1. foreign join

 

  1. outer join

 

  1. natural join

 

  1. equijoin

 

QUESTION 3. A table that is in 2NF and contains no transitive dependencies is said to be in ________.   (0.25 points)

 

  1. 1NF

 

  1. 2NF

 

  1. 3NF

 

  1. 4NF

 

QUESTION 4. The normalization process involves assigning ________ to tables based on the concept of determination.                (0.25 points)

 

  1. attributes

 

  1. relations

 

  1. data

 

  1. files

 

QUESTION 5. Lower normalization forms occur (and are even required) in specialized databases known as ________.                (0.25 points)

 

  1. data dumps

 

  1. operational databases

 

  1. data warehouses

 

  1. historical databases

 

QUESTION 6. Each table is perceived as a ________.      (0.25 points)

 

  1. two-dimensional structure

 

  1. graph

 

  1. linked structure

 

  1. three-dimensional structure

 

QUESTION 7. Nulls, if used improperly, can create problems because they can represent ________.      (0.25 points)

 

  1. a known, but missing, attribute value

 

  1. zero

 

  1. an unsortable value

 

  1. a default value

 

QUESTION 8. A(n) ________ attribute is not part of a key.           (0.25 points)

 

  1. nonprime

 

  1. composite

 

  1. prime

 

  1. assigned

 

QUESTION 9. An attribute (or combination of attributes) that uniquely identifies each entity in a table is called a ________.                (0.25 points)

 

  1. candidate key

 

  1. superkey

 

  1. secondary key

 

  1. primary key

 

QUESTION 10. Data redundancy produces ________.    (0.25 points)

 

  1. robust design

 

  1. slower lookups

 

  1. data integrity problems

 

  1. efficient storage use

 

QUESTION 11. A table can be logically connected to another table by defining a ________.          (0.25 points)

 

  1. primary key

 

  1. superkey

 

  1. hyperlink

 

  1. common attribute

 

QUESTION 12. A ________ functionally determines all of the row`s attributes.   (0.25 points)

 

  1. combined key

 

  1. foreign key

 

  1. primary key

 

  1. superkey

 

QUESTION 13. Given the following table definition, how many tables would be produced by the conversion to 2NF? 1NF (PROJ_NUM, EMP_NUM, PROJ_NAME, EMP_NAME, JOB_CLASS, CHG_HOURS, ASSIGN_HOURS)           (0.25 points)

 

  1. one

 

  1. two

 

  1. three

 

  1. four

 

QUESTION 14. In a normalized database, what is represented by each table?      (0.25 points)

 

  1. an entire application

 

  1. a single subject

 

  1. a functional area

 

  1. one attribute

 

QUESTION 15. The use of a(n) ________ relationship ensures that two entity sets are not placed in the same table when they should not be.        (0.25 points)

 

  1. 1:1

 

  1. 1:M

 

  1. M:1

 

  1. M:N

 

QUESTION 16. Date attributes contain calendar dates stored in a special format known as the ________ date format.                (0.25 points)

 

  1. Julian

 

  1. Augustan

 

  1. Jamesian

 

  1. Gregorian

 

QUESTION 17. In an ideal (database design) world, the level of desired granularity is determined at the ________ design or at the requirements gathering phase.    (0.25 points)

 

  1. functional

 

  1. data

 

  1. conceptual

 

  1. external

 

QUESTION 18. A table that has all key attributes defined, no repeating groups, and an identified primary key is said to be in ________.         (0.25 points)

 

  1. 1NF

 

  1. 2NF

 

  1. 3NF

 

  1. 4NF

 

QUESTION 19. A ________ key is an artificial PK introduced by the designer with the purpose of simplifying the assignment of primary keys to tables.             (0.25 points)

 

  1. candidate

 

  1. foreign

 

  1. surrogate

 

  1. composite

 

QUESTION 20. A relational operator that yields all values for selected attributes is known as the ________ operator.                (0.25 points)

 

  1. select

 

  1. difference

 

  1. project

 

  1. product

 

QUESTION 21. A relational operator that yields all rows in one table that are not found in the other table is the ________ operator.             (0.25 points)

 

  1. difference

 

  1. union

 

  1. product

 

  1. intersect

 

QUESTION 22. A table that is in 2NF and contains no transitive dependencies is said to be in ________. (0.25 points)

 

  1. 1NF

 

  1. 2NF

 

  1. 3NF

 

  1. 4NF

 

QUESTION 23. The normalization process involves assigning ________ to tables based on the concept of determination.                (0.25 points)

 

  1. attributes

 

  1. relations

 

  1. data

 

  1. files

 

QUESTION 24. Lower normalization forms occur (and are even required) in specialized databases known as ________.                (0.25 points)

 

  1. data dumps

 

  1. operational databases

 

  1. data warehouses

 

  1. historical databases

 

QUESTION 25. Each table is perceived as a ________.    (0.25 points)

 

  1. two-dimensional structure

 

  1. graph

 

  1. linked structure

 

  1. three-dimensional structure

 

QUESTION 26. Nulls, if used improperly, can create problems because they can represent ________.    (0.25 points)

 

  1. a known, but missing, attribute value

 

  1. zero

 

  1. an unsortable value

 

  1. a default value

 

QUESTION 27. A(n) ________ attribute is not part of a key.        (0.25 points)

 

  1. nonprime

 

  1. composite

 

  1. prime

 

  1. assigned

 

QUESTION 28. An attribute (or combination of attributes) that uniquely identifies each entity in a table is called a ________.         (0.25 points)

 

  1. candidate key

 

  1. superkey

 

  1. secondary key

 

  1. primary key

 

QUESTION 29. Data redundancy produces ________.    (0.25 points)

 

  1. robust design

 

  1. slower lookups

 

  1. data integrity problems

 

  1. efficient storage use

 

QUESTION 30. A table can be logically connected to another table by defining a ________.          (0.25 points)

 

  1. primary key

 

  1. superkey

 

  1. hyperlink

 

  1. common attribute

 

QUESTION 31. A ________ functionally determines all of the row`s attributes.   (0.25 points)

 

  1. combined key

 

  1. foreign key

 

  1. primary key

 

  1. superkey

 

QUESTION 32. Given the following table definition, how many tables would be produced by the conversion to 2NF? 1NF (PROJ_NUM, EMP_NUM, PROJ_NAME, EMP_NAME, JOB_CLASS, CHG_HOURS, ASSIGN_HOURS)           (0.25 points)

 

  1. one

 

  1. two

 

  1. three

 

  1. four

 

QUESTION 33. In a normalized database, what is represented by each table?      (0.25 points)

 

  1. an entire application

 

  1. a single subject

 

  1. a functional area

 

  1. one attribute

 

QUESTION 34. The use of a(n) ________ relationship ensures that two entity sets are not placed in the same table when they should not be.        (0.25 points)

 

  1. 1:1

 

  1. 1:M

 

  1. M:1

 

  1. M:N

 

QUESTION 35. Date attributes contain calendar dates stored in a special format known as the ________ date format.                (0.25 points)

 

  1. Julian

 

  1. Augustan

 

  1. Jamesian

 

  1. Gregorian

 

QUESTION 36. In an ideal (database design) world, the level of desired granularity is determined at the ________ design or at the requirements gathering phase.    (0.25 points)

 

  1. functional

 

  1. data

 

  1. conceptual

 

  1. external

 

QUESTION 37. A table that has all key attributes defined, no repeating groups, and an identified primary key is said to be in ________.         (0.25 points)

 

  1. 1NF

 

  1. 2NF

 

  1. 3NF

 

  1. 4NF

 

QUESTION 38. A ________ key is an artificial PK introduced by the designer with the purpose of simplifying the assignment of primary keys to tables.             (0.25 points)

 

  1. candidate

 

  1. foreign

 

  1. surrogate

 

  1. composite

 

QUESTION 39. A relational operator that yields all values for selected attributes is known as the ________ operator.                (0.25 points)

 

  1. select

 

  1. difference

 

  1. project

 

  1. product

 

QUESTION 40. A relational operator that yields all rows in one table that are not found in the other table is the ________ operator.             (0.25 points)

 

  1. difference

 

  1. union

 

  1. product

 

  1. intersect
 

100% Plagiarism Free & Custom Written,
Tailored to your instructions


International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120


100% Pass Guarantee

STILL NOT CONVINCED?

View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains

View Our Samples

We offer a £ 2999

If your assignment is plagiarised, we will give you £ 2999 in compensation

Recent Updates

Details

  • Title: ROWS WITH COMMON VALUES IN THEIR COMMON ATTRIBUTE
  • Price: £ 109
  • Post Date: 2018-11-09T10:49:43+00:00
  • Category: Assignment
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

ROWS WITH COMMON VALUES IN THEIR COMMON ATTRIBUTE ROWS WITH COMMON VALUES IN THEIR COMMON ATTRIBUTE
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

My order went 3 hours late and I also went mad. Then the customer support team calmed me down and offered me a flat discount of 50%. However, I did get my order and chilled out as the work was exactly what I requested. Next time I would place my order a bit sooner to save any trouble.
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

CIPD assignment is not my cup of tea. That’s the reason I sought out this place suggested by my friend. I would say that the writers of this site are really admiring. I was assigned the best CIPD writer that solved all my issues. He explained to me the difficult topics so well that now I am able to talk on those topics eloquently. I owe my writer a huge thanks and praise! And yes, I would recommend other students as well to come to instaresearch.co.uk for the top CIPD assignment help.