Description
Convert the following ERD to 3rd Normal Form. Indicate primary keys by underlining them, list foreign keys and the relations they are fks
into, include all the attributes on the diagram (you may make up others as necessary but give them meaningful names). List the functional
dependencies that are obvious from the ERD – don’t assume any of these.
employee Sells to
supplier
customer
hardware
Works with buys
supplies
empId fname
lname
address
phone
email
custId fname
lname
address
phone
email
email
email
phone
phone
hardwareId
address
supplierId
onhand
description
cost
quantity
pricePaid
1
1
1
m
m
n
m n
quantity
date
