Dye after 4 hours

MGMT 341 NAME_______________________

Practice Problem – Employee/Department Database design

Complete the entity relationship model to design a database storing records about employees and

the department in which they work. Each employee is assigned as a member of only one

department. Each department may have any number of employees.

Include indicators for any primary key(s) with a “#” and foreign key(s) with “*” needed. You

may or may not need to use every column or row in the table provided. Use appropriate column

headers (attribute names).

Table name __________

Table name _____________

After completing the ER model above, add a few sample records to the tables. On a separate

sheet of paper or on the bottom of this, test your design by creating the sample reports below.

Sample report # 1 - lists employees’: last name, first name, title and employee ID of all

employees working one specific department

Sample report # 2 – lists employees (from all departments) who have a specific title such as

Supervisor or Manager.