company database

customer (customerId*, custName)

department(departmentId*, deptName, office)

degree (degreeId, code)
1	BSc
2	MIT
3	PhD

employee (EID*, firstName, lastName, SSN, address, phone, DOB, salary, departmentId@, boss)
1	Jim	Martinson

employee_degree (EID@*, degreeId@*)
1	1
1	2

employeephone (EID@*, Phone*, phoneType)
1	320-234-8546	work
1	320-583-8490	cell

employeework (EID@*, projectId@*, date*, hours)
1	2	2023-09-20	3
1	2	2023-09-21	4
1	1	2023-09-21	1

order (orderId*, customerId@, date)

product  ()

project(projectId*, title, budget)
1	Chairs	25
2	Table	100

spouse (EID*@, firstName, lastName, SSN)