Given the diagram (entities, relationships, and cardinalities) and the table below (at the end of the assignment ) the diagram, determine which tables the foreign keys go in and determine the primary key of the relationship table.

Then, create, in Access, non-redundant relational database in access to include:

Table Structure consistent with the information needs and database design issues. Tables and fields defined as suggested below and populated with limited data (< 3 records in each table will do, relationship tables may have more records).

Helpful Hints:

All table names should begin with "table" followed by the name (i.e. tblcash)

All attribute names and table names should contain no spaces

Choose appropriate data types for each attribute.Only numbers used in calculations should be given a "number" data type.

If you choose a data type of "text", you need to change the field size to an appropriate length

Every table needs a primary key

All foreign keys need to have the same data type as the primary key, with one exception.If a primary key has an a "auto_number" data type, the foreign key should have a data type of a "number"

Create the tables (and enter data into your tables) with no foreign keys first (data reduction tables, followed by resource and agent tables, followed by event tables and then relationship tables)

After you create your tables, draw the relationship lines and enforce referential integrity.

Finally, each table needs to have a minimum of 3 rows of data entered each attribute.Make up appropriate information.

Table Name

Table Type

Primary Key(s)

Foreign Key(s)

Attributes

Cash

Resource

Cash Account #

location

Service type

Resource

Service Name

Hourly Billing Rate

Service Engagement

Event

Invoice #

Total Charge

Number of Employees

Cash Receipt

Event

RA #

Employee

Agent

Employee SSN

Hourly Wage Rate

Highest Degree

Client

Agent

Client #

Name

Cashier

Agent

SSN

Phone Number

Many-to-many

Employee time

TOTAL