1 / 7

Has referential data integrity been violated between any of the tables? If so, name the orphans.

1. 1. 1. 1. ∞. ∞. 1. ∞. Has referential data integrity been violated between any of the tables? If so, name the orphans. Yes, referential data has been violated because EmployeeID 000000000 on the timesheet table is an orphan.

ivy
Download Presentation

Has referential data integrity been violated between any of the tables? If so, name the orphans.

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 1 1 1 1 ∞ ∞ 1 ∞

  2. Has referential data integrity been violated between any of the tables? If so, name the orphans. Yes, referential data has been violated because EmployeeID 000000000 on the timesheet table is an orphan

  3. 3. Using the query design view below, construct a query to list the names of all the Houston residents in alphabetical order by last name, then first name.

  4. 4. Create a list of employees who worked at least 20 hours in January 2001. List their SSN, Last Name, and the hours worked. (The list should be sorted alphabetically by last name.)

  5. 5. The carpenters’ union has been complaining that you have been working them too many hours each day. Calculate the average, maximum, and minimum number of hours that the carpenters spend working each day.

  6. 6. Create a pay sheet for the week of January 29, 2001, through February 4, 2001. For each employee, list his or her Employee ID, their hourly rate, the number of days worked that week, the total number of hours worked, and the total amount to be paid on that week’s paycheck. This list should be sorted by SSN; highest to lowest.

  7. 7. Create a pay sheet for the week of January 29, 2001, through February 4, 2001. For each employee, list his or her Employee ID and their gross pay. (Do not use the previous query as a table for this query.)

More Related