Database Design Download the Cyberdyne Invoice from the website and design a database to store the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Database Design Download the Cyberdyne Invoice from the website and design a database to store the invoice. Orders are assigned a department. The same rep does all the orders that are in their department. All tables should be in 3NF. Type your answers into a text file in DBDL format. Be sure to label PKs and FKs. SQL Querying Download the resource for this exam from the website. You will need to import the data from the CSVS provided. Give the answer to the question, then tell me the query or queries you took to find it. Screenshot any queries you used. It is possible to answer each step in a single query :) NOTE: Be sure your name and the date is included in your MySQL prompt in any screenshots you take! Command: \R username[\d]: 1. The Region Name, First Name, Last Name, and Salary of each Head Manager 2. The Total amount we are paying employees in each region 3. ID number of employees with 3 or more evaluations 4. Number of employees in each region outside their salary range 5. Highest paid employee of each Rank 6. Total number of each rank at each region 7. Temps should never be more than 20% of the Full-Time Staff in a region. Show the percentage Rank 1/Rank 2 in each region 8. All evaluation comments that mention Johnson The following is the data for the rank and region tables: Rank 1. Temps $0-$12000 2. Full-time $20000-$25000 3. Assistant Manager $30000-$36000 4. Head Manager $45000-$55000 5. President $60000- No max Region 1. Northwest 2. SouthEast 3. Central 4. Two Rivers Database Design Download the Cyberdyne Invoice from the website and design a database to store the invoice. Orders are assigned a department. The same rep does all the orders that are in their department. All tables should be in 3NF. Type your answers into a text file in DBDL format. Be sure to label PKs and FKs. SQL Querying Download the resource for this exam from the website. You will need to import the data from the CSVS provided. Give the answer to the question, then tell me the query or queries you took to find it. Screenshot any queries you used. It is possible to answer each step in a single query :) NOTE: Be sure your name and the date is included in your MySQL prompt in any screenshots you take! Command: \R username[\d]: 1. The Region Name, First Name, Last Name, and Salary of each Head Manager 2. The Total amount we are paying employees in each region 3. ID number of employees with 3 or more evaluations 4. Number of employees in each region outside their salary range 5. Highest paid employee of each Rank 6. Total number of each rank at each region 7. Temps should never be more than 20% of the Full-Time Staff in a region. Show the percentage Rank 1/Rank 2 in each region 8. All evaluation comments that mention Johnson The following is the data for the rank and region tables: Rank 1. Temps $0-$12000 2. Full-time $20000-$25000 3. Assistant Manager $30000-$36000 4. Head Manager $45000-$55000 5. President $60000- No max Region 1. Northwest 2. SouthEast 3. Central 4. Two Rivers
Expert Answer:
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these databases questions
-
Design a database by analysing the requirements for the scenario detailed on the following pages. State any assumptions/notes you have made regarding your database design at the beginning of the...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
What are the possible sources of error in this project?
-
Obtain or compute the following quantities: a. F.05,5,8 b. F.05,8,5 c. F.95,5,8 d. F.95,8,5 e. The 99th percentile of the F distribution with v1 = 10, v2 = 12 f. The 1st percentile of the F...
-
What is your opinion of the value of experience in team sports for becoming a good team player in the workplace?
-
Renkas Heaters selected data for October 2017 are presented here (in millions): Calculate the following costs: 1. Direct materials inventory 10/31/2017 2. Fixed manufacturing overhead costs for...
-
Lyman Company bottles and distributes Livit, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2012,...
-
The GRE (Graduate Record Exam) scores for both verbal and quantitative reasoning are approximately normally distributed and scaled to have mean 150 with standard deviation of 8.75. 1) Below what...
-
A keen math student has invented the new card game Cardle, which requires a special pack of cards to be purchased on Amazon.ca. The company currently sells 1000 packs of cards per day at a price of...
-
Which type of control, preventive or detective, is usually a more efficient control type to test?
-
Why are internal controls important to an auditor?
-
Why does the auditor consider the entitys overall control environment when performing controls testing?
-
Why are internal controls important to an organization?
-
As a resource manager, what information do you need from your resources daily or weekly in order to keep the Critical Chain database up to date?
-
(a) Mr. Bill wants to buy a house at the price of $2,000,000 which will be settled by regular payments of $10,000 at the end of each month for as long as necessary, if a drop payment is made. The...
-
The Place-Plus real estate development firm in Problem 24 is dissatisfied with the economists estimate of the probabilities of future interest rate movement, so it is considering having a financial...
-
Design a survey form of your own. Fill it out as it might have been completed during the database design forHenry Books. For any questions you have too little information to answer, make a reasonable...
-
Write the SQL command to revoke user Stetsons privilege.
-
Describe the purpose of the SELECT command in relational algebra.
-
See Table 2.5 showing financial statement data and stock price data for Mydeco Corp. a. Compute Mydecos PE ratio each year from 2019 to 2023. In which year was it the highest? b. What was Mydecos...
-
See Table 2.5 showing financial statement data and stock price data for Mydeco Corp. a. Compute Mydecos ROE each year from 2019 to 2023. b. Compute Mydecos ROA each year from 2019 to 2023. c. Which...
-
In early 2018, United Airlines (UAL) had a market capitalization of \($25.14\) billion, debt of \($12.73\) billion, and cash of \($5.59\) billion. United also had annual revenues of \($38.72\)...
Study smarter with the SolutionInn App