Has referential data integrity been violated between any of the tables if so name the orphans
This presentation is the property of its rightful owner.
Sponsored Links
1 / 7

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


  • 60 Views
  • Uploaded on
  • Presentation posted in: General

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.

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.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


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

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


Has referential data integrity been violated between any of the tables if so name the orphans

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.


Has referential data integrity been violated between any of the tables if so name the orphans

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.)


Has referential data integrity been violated between any of the tables if so name the orphans

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.


Has referential data integrity been violated between any of the tables if so name the orphans

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.


Has referential data integrity been violated between any of the tables if so name the orphans

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.)


  • Login