Tour Operator Agency Database

Tour Operator Agency Database

Sales Person Table with their Project Titles

*EmployeeID

LastName

FirstName

*ProjectNumber

ProjectTitle

EN1-26

O'Brien

Sean

30-452-T3

STAR manual

EN1-26

O'Brien

Sean

30-457-T3

ISO procedures

EN1-26

O'Brien

Sean

31-124-T3

Employee handbook

EN1-33

Guya

Amy

30-452-T3

STAR manual

EN1-33

Guya

Amy

30-482-TC

Web Site

EN1-33

Guya

Amy

31-241-TC

New catalog

EN1-35

Baranco

Steven

30-452-T3

STAR manual

EN1-35

Baranco

Steven

31-238-TC

STAR prototype

EN1-36

Roslyn

Elizabeth

35-152-TC

STAR pricing

EN1-38

Schaaf

Carol

36-272-TC

Order system

EN1-40

Wing

Alexandra

31-238-TC

STAR prototype

EN1-40

Wing

Alexandra

31-241-TC

New catalog

Second Normal Form of Sales Person Table with their Project Titles

SalesPerson

*EmployeeID

First Name

EN1-26

O'Brien

Sean

EN1-33

Guya

Amy

EN1-35

Baranco

Steven

EN1-36

Roslyn

Elizabeth

EN1-38

Schaaf

Carol

EN1-40

Wing

Alexandra

SalesPerson_PROJECTS

*EmployeeID

*ProjectNum

EN1-26

30-452-T3

EN1-26

30-457-T3

EN1-26

31-124-T3

EN1-33

30-328-TC

EN1-33

30-452-T3

EN1-33

32-244-T3

EN1-35

30-452-T3

EN1-35

31-238-TC

EN1-36

35-152-TC

EN1-38

36-272-TC

EN1-40

31-238-TC

EN1-40

31-241-TC

PROJECTS

*ProjectNum

ProjectTitle

30-452-T3

STAR manual

30-457-T3

ISO procedures

30-482-TC

Web site

31-124-T3

Employee handbook

31-238-TC

STAR prototype

31-238-TC

New catalog

35-152-TC

STAR pricing

36-272-TC

Order system

The table is now in second normal form since there are no repeating values in the non-key fields, and each of the non-key fields is determined with the help of the key values and key fields. As a result of this there are no repeated values in the table, which existed before.

ERM of the Sales Person ...