Question: Using MS Access build a table and relationship, you can makeup values. Attribute Name Sample Value Sample Value Sample Value Sample Value EMP_NUM 1003 1018

Using MS Access build a table and relationship, you can makeup values.

Attribute Name

Sample Value

Sample Value

Sample Value

Sample Value

EMP_NUM

1003

1018

1019

1023

EMP_LNAME

Willaker

Smith

McGuire

McGuire

EMP_EDUCATION

BBA, MBA

BBA

BS, MS, Ph.D.

JOB_CLASS

SLS

SLS

JNT

DBA

EMP_DEPENDENTS

Gerald (spouse),

Mary (daughter),

John (son)

JoAnne (spouse)

George (spouse)

Jill (daughter)

DEPT_CODE

MKTG

MKTG

SVC

INFS

DEPT_NAME

Marketing

Marketing

General Service

Info. Systems

DEPT_MANAGER

Jill H. Martin

Jill H. Martin

Hank B. Jones

Carlos G. Ortez

EMP_TITLE

Sales Agent

Sales Agent

Janitor

DB Admin

EMP_DOB

23-Dec-1968

28-Mar-1979

18-May-1982

20-Jul-1959

EMP_HIRE_DATE

14-Oct-1997

15-Jan-2006

21-Apr-2003

15-Jul-1999

EMP_TRAINING

L1, L2

L1

L1, L3, L8, L15

EMP_BASE_SALARY

$38,255.00

$30,500.00

$19.750.00

$127,900.00

EMP_COMMISSION_RATE

0.015

0.010

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

Attribute Name Sample Value Sample Value Sample Value Sample Value EMP_NUM 1003 1018 1019 1023 EMP_LNAME Willaker Smith McGuire McGuire EMP_EDUCATION BBA, MBA BBA BS, MS, Ph.D. JOB_CLASS SLS SLS JNT...

Q:

The table structure below contains many unsatisfactory components and characteristics. For example, there are several multivalued attributes and some attributes are not atomic. Table: Sample EMPLOYEE...

Q:

It is 3 questions. If I need to post 3 times, let me know. The table structure shown below contains many unsatisfactory components and characteristics. For example, there are several multivalued...

Q:

The table structure below contains many unsatisfactory components and characteristics. For example, there are several multivalued attributes and some attributes are not atomic. Table: Sample EMPLOYEE...

Q:

The table structure shown in Table P6.6 contains many unsatisfactory components and characteristics. For example, there are several multivalued attributes, naming conventions are violated, and some...

Q:

First, identify a list of all the entities in the problem. And make an ERD is based on the top-down design. Then, using the concept of bottom-up design and normalization, design a database based on...

Q:

First, identify a list of all the entities in the problem. And make an ERD based on the top-down design concepts covered in CH4. Then, using the concept of bottom-up design and normalization covered...

Q:

Q1) Find 1NF, 2NF and 3NF for the following table ATTRIBUTE NAME STU NUM STU_LNAME STU MAJOR DEPT CODE DEPT_NAME DEPT PHONE COLLEGE NAME ADVISOR_LNAME ADVISOR OFFICE ADVISOR BLDG ADVISOR PHONE STU...

Q:

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Q:

** You can use EXCEL or any other software. ** You need to include your printout in your submissions. The layout and format of the paper should include the following sections: Title page, Abstract,...

Q:

The SarbanesOxley Act of 2002 created the Public Company Accounting Oversight Board (PCAOB) to oversee the work of public accounting firms performing financial statement audits for public filers,...

Q:

The investment center of BD Company has just report the following financial information for their division Operating profit The following adjustment must be considered: Non-current assets and...

Q:

An impairement loss should be recognized for a long - lived asset if the expected discounted net future cash flows from the use and the disposal of the asset are less than the

Q:

Hello, I don't understand how to do this exercise, help me please? A company has some idle manufacturing capacity and produces 2 products AB and MN, whose cost structure is as follows: Cost item...

Q:

4. Use social science theory to assign hypothesis values to group ID parameters. Place these values in group ID hypothesis parameter files.

Q:

3. Find the best set of ecosystem state values that can be reached by any change in group beliefs. Do this by iterating the following two steps. First, make a small change to qd as given in the...

Q:

2. Initialize (the values in ).