Create the erd containing all primary keys

Assignment Help Basic Computer Science

Reference no: EM131190540

AVANTIVE Corporation has five departments: administration, marketing, sales, shipping, and purchasing. Each department employs many employees. Each employee has an ID, a name, a home address, a home phone number, and a salary and tax ID (Social Security number). Some employees are classified as sales representatives, some as technical support, and some as administrators. Sales representatives receive a commission based on sales. Technical support employees are required to be certified in their areas of expertise. For example, some are certified as drivetrain specialists; others, as electrical systems specialists. All administrators have a title and a bonus. Given that information, create the ERD containing all primary keys, foreign keys, and main attributes.

Reference no: EM131190540

Questions Cloud

Conclude about personal investment preferences : What would you conclude about your personal investment preferences, and how would you assess a client who shares your personal investment preferences?

Amount of benefits other policy provisions : What would you advise John regarding his potential need for additional disability insurance, including the type, amount of benefits, or other policy provisions?

How the different categories of sound are being used in film : Describe each of the three basic categories of sound (dialogue, sound effects, and music). Explain how the different categories of sound are being used in your chosen film.

Determine the total earnings : The initial salary of Mr. Kiptum is Sh. 42,000 per annum. His salary increases by 13% each year. Determine his total earnings after 15 years. Give your answer to the nearest thousands

Create the erd containing all primary keys : For example, some are certified as drivetrain specialists; others, as electrical systems specialists. All administrators have a title and a bonus. Given that information, create the ERD containing all primary keys, foreign keys, and main attribute..

Which problem with lindahl pricing is demonstrated : Americans stated that they were willing to pay $70 billion to protect all endangered species and also stated that they were willing to pay $15 billion to protect a single species.- Which problem with Lindahl pricing is demonstrated?

Determining the parliamentary election : In 2007 parliamentary election, only 55% of the voters in a constituency of 85,000 cast their votes. Of the votes cast, A received 48%, B received 32% and C received the remainder. How many votes did C receive.

Why do you think that given statement is true : The preference revelation problem associated with Lindahl pricing becomes more severe as the number of people in society increases.- Why do you think this is true?

What is the aftertax cost of debt : A bond with a $1,000 par value sells for $895. The coupon rate is 7%, the bonds mature in 20 years, and coupon interest is paid semi-annually. The tax rate is 35%. What is the aftertax cost of this debt?

User Account

All Pages