Normalization%20inclass%20problem%20solutions

Normalization%20inclass%20problem%20solutions - Visit date...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
AIS in-class Normalization problem solutions Practice 1 (BusyB Co - Employee skills) Employee Table Skill Table Employee/Skill Table Employee # Skill # [Skill #] Employee name Skill name [Employee #] Date of birth Skill pay rate Date skill acquired Supervisor Date hired Practice 2: Veterinary practice Patient Table Service Table Visit Table Service/Visit Table Animal Table Zip Table Owner Table Patient ID Service Code Visit # Service Code Animal Code Zip Owner ID Patient Name Service desc.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Visit date Visit # Animal Desc. City First Name [Animal Code] Service charge [Patient ID] State Last Name [Owner ID] Address 1 Address 2 [Zip] Practice 3: Conceptual database Item Table Customer Table Invoice Table Invoice/Item Table Item # Customer # Invoice # Invoice # Description Customer Name Date Item # Price Shipping Address Terms Quantity Sold Quantity on hand Billing Address [Customer #] Cost Credit Limit...
View Full Document

This note was uploaded on 08/07/2011 for the course ACC 380 taught by Professor Harkness during the Spring '11 term at University of Michigan-Dearborn.

Ask a homework question - tutors are online