1 / 7

# Has referential data integrity been violated between any of the tables? If so, name the orphans. - PowerPoint PPT Presentation

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.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about 'Has referential data integrity been violated between any of the tables? If so, name the orphans.' - ivy

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

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

3. Using the tables? If so, name the orphans.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. Create the tables? If so, name the orphans.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. 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. 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. 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. Create 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. 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.)