SELECT emp# FROM Salary_tbl
WHERE jobName = Sales AND
(IfNull(commission,0) + salary) > 30,000 –> E10 and E12

Weak relationship.
Customer(CustID*, CustName)
Order(OrderID*, CustID@, Date)

Strong relationship.
Course(CrsCode*, DeptCode, Description)
Class(CrsCode*@, Section*, ClassTime…)

1:M
employee(EID*, Salary, Address, Name, Birthdate, DeptId@)
department (DeptId*, Name, Office)

M:N
employee(EID*, Address, Name, Birthdate)
join(EID*@ Code*@, StartDate) I would name it employee_project instead of join.
project (Code*, Name, Budget)

Unary relationship

employee(EID*, Salary, Address, Name, Birthdate, Super-EID@[employee.EID])

Ternary relationship
supplier(SID*, Name, Address)
project (Code*, Name, Budget)
part(PartID*, PartName, Color)
supply(SID*@, Code*@, PartID*@, Quantity, Date)

What if the part came form a particular suplier?
supplier(SID*, Name, Address)
project (Code*, Name, Budget)
part(PartID*, SID@. PartName, Color)
supply(Code*@, PartID*@, Quantity, Date)


Fig 10.9 pp 67:
NOT NORMALIZED:
grades(StudentID*, StudentName, CourseID*, CourseName, 			Grade, CourseDate)
		1			John Smith	 2		   Programming Level 1	 75		1/5/2014
		2			Sandy Law	 2		   Programming Level 1	 61		1/5/2014
		3 			Sue Rogers	 3		   Business 			 81 	1/7/2014		If I delete Sue Rogers from the class, data about the Business class is also lost.
		4			Jim M		 2		   Prog 2				100		2/9/2021		Insertion anomoly. Allows Update anomoly.

NORMALIZED:
student(StudentID*, StudentName)
		1			John Smith
		2			Sandy Law
		3 			Sue Rogers
		4			Jim M

student_course(StudentID*@, CourseID*@, Grade)
				1			2		  	75		
				2			2		   	61
				3 			3		   	81
				4			2		   	100

course(CourseID*, CourseName,			CourseDate)
		2		   Programming Level 1	1/5/2014
		3		   Business				1/7/2014


15:30:01	Server: localhost   Database: bookinfo  -- phpMyAdmin SQL Dump -- version 3.2.0.1 --
 http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 21, 2010 at 05:08 AM -- 
 Server version: 5.1.36 -- PHP Version: 5.3.0  SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"	
 Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server 
 version for the right syntax to use near 'Server: localhost   Database: bookinfo  -- phpMyAdmin SQL Dump -- version 3.2.0.' at line 1	0.000 sec