First page Back Continue Last page Image

Don’t Abandon What you learn in Subsequent Assignments

?????? Table
ID	PK	NN	int
fName
lName
email
phone
street
city
state
zip

Where ?????? is Customer, Employee, Vendor, Supplier

Is this a good SQL table design?

?????? Table
???ID	PK	NN	int
fName
lName
title
cust-since

Email Table
emailID	PK
???ID	FK
email

Phone Table
phoneID	PK
???ID	FK
PhoneNbr

Address Table
addrID	PK
???ID	FK
street
city
state
zip