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. 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. 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. 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. 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,

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

## 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

Nov,06,2018

Nov,06,2018

Nov,06,2018

### 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
Reviews: 5

### A masterpiece of assignment by Mike , 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 Thomson, 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.