1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
s2008m [1.1K]
3 years ago
12

Given the following business scenario, create a Crow's Foot ERD using a specialization hierarchy if appropriate. Granite Sales C

ompany keeps information on employees and the departments in which they work. For each department, the department name, internal mail box number, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried, hourly, or work on contract. All employees are assigned an employee number, which is kept along with the employee's name and address. For hourly employees, hourly wages and target weekly work hours are stored; for example, the company may target 40 hours/week for some employees, 32 for others, and 20 for others. Some salaried employees are salespeople who can earn a commission in addition to their base salary. For all salaried employees, the yearly salary amount is recorded in the system. For salespeople, their commission percentage on sales and commission percentage on profit are stored in the system. For example, John is a salesperson with a base salary of $50,000 per year plus a 2 percent commission on the sales price for all sales he makes, plus another 5 percent of the profit on each of those sales. For contract employees, the beginning date and end date of their contracts are stored along with the billing rate for their hours.

Computers and Technology
1 answer:
Scilla [17]3 years ago
5 0

Answer:

See explaination

Explanation:

Please kindly go to attachment for Crow Foot Notation image representation.

From the attachment Crow Foot Notation, the relationship between Super class and Sub class is shown clearly, that is;

Employee is super class, also the different types of employees are represented by specialization of three types, there are Salary, Hourly and Contract based. Again the Salary based employee is super class of Sales Employee, representing partially participation.

From the attachment notation, "d" represents distinct that is, distinct employees of type Salary, Hourly and contract.

And "O" represents, Overlapped, means same object is aggregating two specific outcomes which are overlapped.

They are Salary based and Sale wages based employee.

You might be interested in
It is unlawful in the State of Florida for any person, ______________________, to be a passenger in the front seat of a motor ve
Komok [63]
In florida, if you're sitting in the front seat, you always need to wear a seatbelt regardless of age. So D
5 0
3 years ago
The purpose of a function that returns "void" is:_________. A) To satisfy compiler warnings B) To package a repeated task as a f
galben [10]

Answer:

B) To package a repeated task as a function even though the task does not yield a value

Explanation:

The purpose of a function that returns "void" is to package a repeated task as a function even though the task does not yield a value. Since the function does not return any value, it control returns to the caller.

5 0
3 years ago
Which of the following are benefits of designing a scalable system? choose 3 options.
ollegr [7]
I asked my brother since he’s kinda of tech geek and he said

The 1st, 3rd, and 5th answers are correct

Hope this helps and I hope my brother is not wrong.
7 0
3 years ago
The command to delete all the files that have filenames that starts with letter c or c and ends with a letter z or z is
dimaraw [331]
The command is : <span>rm [Aa]*[Zz] </span>
4 0
3 years ago
8.5 question 2 edhesive
dangina [55]

Answer:

Please check the attachment.

Explanation:

Please check the attachment for the program in python.

Download txt
5 0
3 years ago
Other questions:
  • When pasting an object which has been copied from a different slide, where on the slide does the object paste, assuming nothing
    15·1 answer
  • Multiple users report that the network printer, which is connected through the print server, is not printing. Which of the follo
    12·1 answer
  • "When you can control devices and appliances by apps installed on your smartphone or tablet, you are said to have"
    6·1 answer
  • PLEASE HELP ME ANSWER AS MUCH AS YOU CAN I ONLY HAVE 3 POINTS LEFT AND IM TIMED. PLEASE TELL ME THE NUMBER AND LETTER. THANK YOU
    5·1 answer
  • Implement a class Product. A product has a name and a price, for example new Product("Toaster", 29.95). Supply methods getName,
    14·2 answers
  • What is a multipurpose network device?
    10·1 answer
  • The ____ attribute can be used only with input boxes that store text. Group of answer choices type pattern required value
    9·1 answer
  • Which of the following statements is true of San serif fonts?
    12·2 answers
  • Where can formatting features be found ?! Need help asp !‍♀️
    9·1 answer
  • Compare gigabytes GB, kilobytes and terabytes.​
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!