Advanced topics that require specific qualifications

Assignment Help Financial Accounting

Reference no: EM13926195

TEC has a file of candidates who are willing to work.

If the candidate has worked before, that candidate has a specific job history. (Naturally, no job history exists if the candidate has never worked.) Each time the candidate works, one additional job history record is created.

Each candidate has earned several qualifications. Each qualification may be earned by more than one candidate. (For example, it is possible for more than one candidate to have earned a BBA degree or a Microsoft Network Certification. And clearly, a candidate may have earned both a BBA and a Microsoft Network Certification.)

TEC offers courses to help candidates improve their qualifications.

Every course develops one specific qualification; however, TEC does not offer a course for every qualification. Some qualifications have multiple courses that develop that qualification.

Some courses cover advanced topics that require specific qualifications as prerequisites. Some courses cover basic topics that do not require any prerequisite qualifications. A course can have several prerequisites. A qualification can be a prerequisite for more than one course.

Courses are taught during training sessions. A training session is the presentation of a single course. Over time, TEC will offer many training sessions for each course; however, new courses may not have any training sessions scheduled right away.

Candidates can pay a fee to attend a training session. A training session can accommodate several candidates, although new training sessions will not have any candidates registered at first.

TEC also has a list of companies that request temporaries.

Each time a company requests a temporary employee, TEC makes an entry in the Openings folder. That folder contains an opening number, a company name, required qualifications, a starting date, an anticipated ending date, and hourly pay.

Each opening requires only one specific or main qualification.

When a candidate matches the qualification, the job is assigned, and an entry is made in the Placement Record folder. That folder contains an opening number, a candidate number, the total hours worked, etc. In addition, an entry is made in the job history for the candidate.

An opening can be filled by many candidates, and a candidate can fill many openings.

TEC uses special codes to describe a candidates qualifications for an opening. The list of codes is shown in Table P4.10.

TABLE P4.10 TEC QUALIFICATION CODES

CODE	DESCRIPTION
SEC-45	Secretarial work, at least 45 words per minute
SEC-60	Secretarial work, at least 60 words per minute
CLERK	General clerking work
PRG-VB	Programmer, Visual Basic
PRG-C++	Programmer, C++
DBA-ORA	Database Administrator, Oracle
DBA-DB2	Database Administrator, IBM DB2
DBA-SQLSERV	Database Administrator, MS SQL Server
SYS-1	Systems Analyst, level 1
SYS-2	Systems Analyst, level 2
NW-NOV	Network Administrator, Novell experience
WD-CF	Web Developer, ColdFusion

TECs management wants to keep track of the following entities:

COMPANY

OPENING

QUALIFICATION

CANDIDATE

JOB_HISTORY

PLACEMENT

COURSE

SESSION

Given that information, do the following:

Draw the Crows Foot ERDs for this enterprise.

Identify all possible relationships.

Identify the connectivity for each relationship.

Identify the mandatory/optional dependencies for the relationships.

Resolve all M:N relationships.

Provide Normalisation documents

Reference no: EM13926195

Questions Cloud

An appropriate internal control for cash receipts : Which of the following is not an appropriate internal control for cash receipts over the counter

Deducted from the balance per bank statement : What dollar amount should be deducted from the balance per bank statement?What dollar amount should be deducted from the balance per book?Which adjustment will you need to make to company books?

Maximize net income : If Runner Corp. can only sell a maximum of 6,000 units of each type of reel, how many of each reel should Runner Corp. make in order to maximize net income? Explain your answer fully and show your computations.

Accountant records the transaction : at Cadmia service , the cashier collects checks and cash from customer and the junior accountant records the transaction the journal entries and bank reconciliatins.the treasurer signs check and approves contract.

Advanced topics that require specific qualifications : Some courses cover advanced topics that require specific qualifications as prerequisites. Some courses cover basic topics that do not require any prerequisite qualifications. A course can have several prerequisites. A qualification can be a prerequis..

Risk assessment component of internal control : Which of the following describes the risk assessment component of internal control

Ture of internal control : Which of the following is ture of internal control

Profitability ratios of hershey for its years ending : Compute or identify the following profitability ratios of Hershey for its years ending December 31, 2009, and December 31, 2008. Interpret its profitability using the results obtained for these two years.

A personal service corporation : Delaine is a 90% shareholder in a personal service corporation (PSC). The corporation paid Delaine a salary of $353,300 during its fiscal year ending September 30, 2015.

User Account

All Pages