How many records would the following SQL query produce as a result? SELECT User.UserID, NameFROM User INNER JOIN Login ON User.UserID = Login.UserIDWHERE LoginDTStamp   BETWEEN ‘2030-02-01 12:00:00’ AND ‘2030-02-02 12:00:00’

Which of the following is the best answer about the PersonID and CompanyID keys in the WorksIn table?

Decisions related to improving database pefromance are part of which one of the development phases?

In an ERD, the maximum cardinality of one is represented by which of the following?

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?