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?

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Write a recursive method that will calculate nth fibonacci

Fibonacci numbers are really fascinating and turn up in many unexpected places. They are also a good example of recursion. write a recursive method that will calculate the nth Fibonacci number. Now write a method that will do it iteratively.

  Track of business trips of salespersons

Consider the following relations for a database that keeps track of business trips of salespersons in a sales office:

  What is the purpose of the boot loader

What is the purpose of the boot loader during the boot-up process

  Determine and explain what type of leader steve jobs was

Determine and explain what type of leader Steve Jobs was

  What is the relevance of the result for a program

What is the relevance of the result for a program calling the system() function?

  Problem regarding radio frequency identification

VISA CARD RFID (Radio frequency identification) Cover the following.

  List the basic register/memory transfers and operations

List the basic register/memory transfers and operations that occur during each clock cycle for the following program

  Function count down

Function CountDown(count) { If (count

  What state should a go into immediately after the handoff

You may assume all parties will understand this new option. What state should A go into immediately after the handoff?

  Timberline technology manufactures membrane circuits

Timberline Technology manufactures membrane circuits

  The goods are substitutes

(Substitutes and Complements) For each of the following pair of goods, determine whether the goods are substitutes, complements, or unrelated: Peanut butter and jelly, Private and public transportation, coke and pepsi, alarm clocks and automobiles, g..

  Distinguish between software agents and pieces of software

How would you distinguish between software agents and other pieces of software? Is the electronic calendar like the one given by MS Office agent?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd