slide1
Download
Skip this Video
Download Presentation
Has referential data integrity been violated between any of the tables? If so, name the orphans.

Loading in 2 Seconds...

play fullscreen
1 / 7

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


  • 155 Views
  • Uploaded on

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.

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

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


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
slide1

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

slide3

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.

slide4

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

slide5

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.

slide6

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.

slide7

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

ad