{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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 has at least one name HASADDRESS(employeeno,strno,street,city,province)
Background image of page 1

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

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

{[ snackBarMessage ]}