Question

The consulting company wants to store an estimated total amount of time that an employee will...

The consulting company wants to store an estimated total amount of time that an employee will work on a project. Where would that data be stored in your database?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

the data will be stored in the "wroks on" table where the attributes are

EmployeeID (Foreign key), ProjectID(Foreign key), TotalTime

*****************************************************************************
PLEASE DO UPVOTE IF THE ANSWER IS HELPFUL , AS IT GIVES CONFIDENCE TO HELP MORE STUDENTS. There can be a chance that we can misunderstand each other.So before down voting please do reach out to me. Chegg allows me to answer specific no of questions including the sub parts , so please do post the rest of the questions as a separate query as per Chegg Guidelines. Thank you :)
*****************************************************************************

Add a comment
Know the answer?
Add Answer to:
The consulting company wants to store an estimated total amount of time that an employee will...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The BusyB Company wants to store data about its employee skills. Each employee may possess one...

    The BusyB Company wants to store data about its employee skills. Each employee may possess one or more specific skills, and several employees may have the same skill. Include the following facts in the database: date hired date of birth date skill acquired employee name employee number pay rate skill name skill number supervisor Design a set of relational tables to store these data. Identify the primary key for each table, and identify any needed foreign keys

  • 4. The president of a consulting firm wants to minimize the total number of hours it...

    4. The president of a consulting firm wants to minimize the total number of hours it will take to complete four projects for a new client. Accordingly, she has estimated the time it should take for each of her top consultants -- Charlie, Gerald, Johnny, and Rick - to complete any of the four projects, as indicated in the table below. Consultant Charlie Gerald Johnny Rick Project Chours) A B 15 16 13 15 15 21 17 19 с 12...

  • 4. The president of a consulting firm wants to minimize the total number of hours it...

    4. The president of a consulting firm wants to minimize the total number of hours it will take to complete four projects for a new client. Accordingly, she has estimated the time it should take for each of her top consultants -- Charlie, Gerald. Johnny, and Rick -- to complete any of the four projects, as indicated in the table below. Consultant Charlie Gerald Johnny Rick Project (hours) A B 15 16 13 15 15 21 17 19 с 12...

  • 4. The president of a consulting firm wants to minimize the total number of hours it...

    4. The president of a consulting firm wants to minimize the total number of hours it will take to complete four projects for a new client. Accordingly, she has estimated the time it should take for each of her top consultants -- Charlie, Gerald, Johnny, and Rick -- to complete any of the four projects, as indicated in the table below. Consultant Charlie Gerald Johnny Rick Project (hours) А B 15 16 13 15 15 21 17 19 с 12...

  • employee(employee-id, employee-name, street, city) works(employee-id, company-id, salary) company(company-id, company-name, city) manages(employee-id, manager-id) Consider the data base...

    employee(employee-id, employee-name, street, city) works(employee-id, company-id, salary) company(company-id, company-name, city) manages(employee-id, manager-id) Consider the data base above where the primary keys are in bold For each of the questions give the following. (NOTICE the Relations on the given database it isn't like the ones that are commonly posted they are slightly different) (1) a relational algebra expression, (2) a tuple relational calculus expression, and (3) a domain relational calculus expression. f. Find all employees in the database who do not...

  • A company has a contract to build a bridge for $100,000 with an estimated time to...

    A company has a contract to build a bridge for $100,000 with an estimated time to completion of three years. A reliable total cost estimate for the project would be $60,000. In the first year of the project, the company incurred a cost of $24,000. (a) Assume that the contractor bases the degree of completion on the percentage of total costs incurred to date. Under the percentage-of-completion method, what amount of gross profit the company will report in the first...

  • 4. The president of a consulting firm wants to minimize the total number of hours it...

    4. The president of a consulting firm wants to minimize the total number of hours it will take to complete four projects for a new client. Accordingly, she has estimated the time it should take for each of her top consultants -- Charlie, Gerald, Johnny, and Rick -- to complete any of the four projects, as indicated in the table below. Press hours! Consultan ABCD Charlie 1516 EUR Gerald 13151GE Johnny US 2120 LS Rick 0719 1222 (a) Find the...

  • 4. The president of a consulting firm wants to minimize the total number of hours it...

    4. The president of a consulting firm wants to minimize the total number of hours it will take to complete four projects for a new client. Accordingly, she has estimated the time it should take for each of her top consultants -- Charlie, Gerald, Johnny, and Rick -- to complete any of the four projects, as indicated in the table below. Press hours! Consultan ABCD Charlie 1516 EUR Gerald 13151GE Johnny US 2120 LS Rick 0719 1222 (a) Find the...

  • The president of a consulting firm wants to minimize the total number of hours it will...

    The president of a consulting firm wants to minimize the total number of hours it will take to complete four projects for a new client. Accordingly, she has estimated the time it should take for each of her top consultants -- Charlie, Gerald, Johnny, and Rick -- to complete any of the four projects, as indicated in the table below. (a) Find the optimal assignment such that the total number of hours is minimized. (Show your table in each step)...

  • A local financial consulting firm employs 20 full-time staff. The estimated compensation per employee is $50838...

    A local financial consulting firm employs 20 full-time staff. The estimated compensation per employee is $50838 for 2049 hours. All direct labour costs are charged to clients. Any other costs are included in a single indirect-cost pool, allocated according to labour-hours. If the total cost of a job that will take 23 hours is $2447 using a job order cost system, what is the budgeted indirect costs for the coming year? Select one: a. $1876 b. $3343156 c. $3997143 d....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT