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?
-
Two different types of alloy, A and B, have been used to manufacture experimental specimens of a small tension link to be used in a certain engineering application. The ultimate strength (ksi) of...
-
Discuss the importance of emerging economies in the global economy. Use current news.
-
Explain the importance of the idea of a "civilizing mission" to both people living under colonialism and people in the colonizing countries.
-
Grand Lips produces a lip balm used for cold- weather sports. The balm is manufactured in a single processing department. No lip balm was in process on May 31, and Grand Lips started production on...
-
Discuss the role of daemon processes and background services in operating systems. How do these processes differ from regular user processes, and what best practices are followed to ensure their...
-
Lewis Company reports the following fixed budget and actual results for May. Prepare a flexible budget performance report showing variances between budgeted and actual results. (Indicate the effect...
-
1. Angie Silva has recently opened The Sandal Shop in Brisbane, Australia, a store that specializes in fashion sandals. Eventually, she hopes to open a chain of sandal stores. As a first step, you...
-
University Car Wash built a deluxe car wash across the street from campus. The new machines cost $231,000 including installation. The company estimates that the equipment will have a residual value...
-
Crane Corporation sells three different models of a mosquito "zapper." Model A12 sells for $52 and has unit variable costs of $36. Model B22 sells for $104 and has unit variable costs of $73. Model...
-
Think of a time when you had to make an ethical decision. Describe the context, the decision you made, and the reasons for making that decision at the time. From learning about King IV, GACP and ISO...
-
What racial issues do you believe are facing sports today? Do you believe Title VII has resulted in progress regarding racial discrimination in sports? Title IX Mary Williams was an outstanding...
-
You and your partner will imagine a situation in which your business has entered into a contract with a supplier or a customer, and the supplier/customer has breached the contract. Please answer the...
-
The diagram shows the process of making clay pots. Describe the process of making clay pots. You are advised to write between 200 and 250 words if you select this topic to write.
-
(a) Bright Sdn Bhd (BSB) is a tax resident manufacturing company in Johor, which involves in ceramic tiles. Currently, BSBs annual sales turnover has been forecasted to be around RM 300,000 for the...
-
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.
-
The following thermal decomposition occurs at \(400 \mathrm{~K}\) : \[ A(\mathrm{~s}) ightarrow B(\mathrm{~s})+C(\mathrm{~g}) \] The standard Gibbs free energy of the reaction, \(\Delta...
-
The hydrate of sodium carbonate decomposes according to the following equation: \[ \mathrm{Na}_{2} \mathrm{CO}_{3} \cdot \mathrm{H}_{2} \mathrm{O}(\mathrm{s}) ightarrow \mathrm{Na}_{2}...
-
In a steel reactor, steam is passed over a bed of red-hot carbon at \(875 \mathrm{~K}\) and 1 bar. At these conditions, the equilibrium constant for the reaction is 0.514 . Calculate the equilibrium...
Study smarter with the SolutionInn App