Which of these is a reason to relate tables in Power BI

Produce a list of information about all existing constraints on the STORE_REPS table.

What is the rationale for normalising first and then denormalizing?

Explain the characteristics data tables need to have in order to conduct normalization

How do you query JSON data stored in SQL databases?

Convert the table above to a relation in first normal form. Illustrate the relation with the sample data in the table.

Explain what check digits are and how they are used for validation. Please give three real-world applications.

Table name: EMPLOYEE EMP_NUM EMP_LNAME 215 Smith 216 Romero 217 Randall 218 Aarden Table name: EMP_EDUC EMP_NUM EDU_CODE EE_YEAR 2002 1991 1994 1989 2004 2002 1985 1992 2000 1990 2000 2005 1984 1995 215 84 215 HS 215 JC 216 B4 216 CDP 216 CNP 216 HS 217 HS 217 JC 218 B4 218 CDP 218 CNP 218 HS 218 M2 Table name: EDUCATION EDU_CODE EDU_DESCRIPTION 34 CDP CNP CPA DR HS JC M2 Bachelor's degree Certified data Processing Certified Network Professional Certified Public Accountant Earned Doctorate degree Highschool diploma Junior College degree Master's degree

A company makes four kinds of products. Each product has a size code, a weight code, and a shape code. The following table shows these codes: Size Code Weight Code Shape Code #1 42 27 42 #2 27 38 13 #3 13 12 27 #4 42 38 38 Which code(s) is(are) a primary key for this table? Explain your answer why that(those) codes are primary keys, and the others (if any) are not.

Table name: EMPLOYEE EMP_NUM EMP_LNAME 215 Smith 216 Romero 217 Randall 218 Aarden Table name: EMP_EDUC EMP_NUM EDU_CODE EE YEAR 2002 1991 1994 1989 2004 2002 1985 1992 2000 1990 2000 2005 1984 1995 215 84 215 HS 215 JC 216 B4 216 CDP 216 CNP 216 HS 217 HS 217 JC 218 B4 218 CDP 218 CNP 218 HS 218 M2 Table name: EDUCATION EDU_CODE EDU_DESCRIPTION 34 CDP CNP CPA DR HS JC M2 Bachelor's degree Certified data Processing Certified Network Professional Certified Public Accountant Earned Doctorate degree Highschool diploma Junior College degree Master's degree