assgn2 - Course: SE 4M03 Student: F. Franek Student No:...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Course: SE 4M03 Student: F. Franek Student No: 0000000 ------------------------------------------------------------------------------- EMPLOYEE(employeeno) PK=employeeno employeeno: string of length 6, all elements must be digits, may not be null MANAGER(employeeno) PK=employeeno, FK(EMPLOYEE)=employeeno Deficiency: this design does not guarantee that workers and managers are disjoint WORKER(employeeno,managerno) PK=employeeno, FK(EMPLOYEE)=employeeno FK(MANAGER:employeeno)=managerno HASPHONE(employeeno,area_code,number) PK=(employeeno,area_code,number), FK(EMPLOYEE)=employeeno area_code: string of length 3, all elements must be digits, may not be null number: string of length 6, all elements must be digits, may not be null HASNAME(employeeno,first,middle,last) PK=(employeeno,first,last), FK(EMPLOYEE)=employeeno first: variable string of length <=10, may not be null middle: variable string of length <=10, last: variable string of length <=20, may not be null Deficiency: this design does not guarantee that each employee
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/31/2010 for the course CAS SE4M03 taught by Professor Franek during the Winter '10 term at McMaster University.

Page1 / 2

assgn2 - Course: SE 4M03 Student: F. Franek Student No:...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online