Which of the following is the total number of entities in the credit card ERD?

The next seven (7) questions use the User and Login tables, where the NULLs in the Login table represent guest logins.

What will be returned from the following query?Hint: Do not count the NULLs SELECT COUNT(DISTINCT UserID) FROM Login WHERE LoginDTStamp BETWEEN ‘2030-02-01 10:00:00’    AND ‘2030-02-03 10:00:00’

_____ describe interactions between _____ that store data in a collection of _____.

The next four (4) questions use the following two tables (underline represents the primary key): Company (CompanyID, Name, Type, Location) and WorksIn (PersonID, CompanyID, Name, HourlyRate, AnnualSalary). The Company table describes different companies, the WorksIn table describes who works at which company and how much are they getting paid. HourlyRate is associated with hourly employees and AnnualSalary with full-time benefited employees. You can assume that people can have multiple jobs at the same time, but not at the same company.

Which of the following is the problem with the traditional flat-file based approach to databases?

Waiting times (in minutes) for 25 patients at a public health clinic are: 35        22        63        6          49        19        16        31        24        29 23        32        72        13        51        45        77        16        33        55 10        42        28        72        13 Create a frequency table with counts, relative frequencies, and cumulative relative frequencies (Use decimals)

Which type of study design is considered the gold standard?

The following data were collected in the above-mentioned study assessing the impact of gluten on Celiac Disease over twenty years Celiac Disease at 20 yrs No Celiac Disease at 20 yrs Baseline: Gluten Allergies 4,173 2,117 Baseline: No Gluten Allergies 2,324 3,605 Calculate the following and show all of your work: The cumulative incidence of Celiac disease in persons who had gluten allergies at baseline The cumulative incidence of Celiac disease in persons who were free of gluten allergies at baseline The odds ratio of Celiac Disease among persons who had gluten allergies at baseline, compared to those who did not have gluten allergies. 

Comparing the risk of developing cancer in those who smoke versus those who do not can be evaulated using an odds ratio