Business situation

Your company has a Microsoft Access Contacts database. Your company wants to create an in-house Oracle version of this database. You can get familiar with an Access Contacts database from this video or download a copy by opening Microsoft Access and then search for Contacts.

Review the information that follows to determine the data requirements for the Oracle database. Use your findings to create an ERD, and the relational schema using Oracle Data Modeler.

The business analyst provided following details about company and the new database requirements

The company has more than one department

An employee is assigned to only one department

A department has at least one employee

Warehouse "Order assembler" team members share the same mobile phone

Each employee has a job title

Employees have a sequential employee ID number that isn't shown on the sample output

Each Sales employee is assigned his own office and mobile phone number

The business analyst proposed following sample output from the new Contacts database:

Name	Mike Jones
Department	Warehouse
Title	Order assembler
Email	MJones@company.com
Office Phone	111-333-1222
Mobile Phone	111-333-1444

Name	Marion Davidson
Department	Warehouse
Title	Manager
Email	MDavidson@company.com
Office Phone	111-333-1222
Mobile Phone	111-333-1450

Name	John Smith
Department	Sales
Title	Account representative
Email	JSmith@company.com
Office Phone	111-111-1111
Mobile Phone	111-123-1234

Name	Sally Miles
Department	Sales
Title	Manager
Email	SMiles@company.com
Office Phone	222-223-1111
Mobile Phone	111-123-1266

Name	Joe Harris
Department	Warehouse
Title	Order assembler
Email	JHarris@company.com
Office Phone	111-333-1222
Mobile Phone	111-333-1444