1. Create SQL code to create all the tables including primary and foreign keys 2. Create...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Create SQL code to create all the tables including primary and foreign keys 2. Create 3 queries and one must include a join. Some ideas include: A query to find all items that cost more than $10. A query to find all items with a name that begins with 'S' A query to find the average number of items on hand A query to find all items with low inventory A query to find all items in the Central region All suppliers from the North region All items supplied by Wallflower These are just some examples - feel free to create any queries you would like. The tables are below: Region RegionID 101 102 103 104 105 Supplier SuppID 2 RegionName North South East West Central SuppName Cost Company Wallflower SuppPhone 111-222-7895 222-333-1236 regionID 101 105 A query to find all items with low inventory A query to find all items in the Central region All suppliers from the North region All items supplied by Wallflower These are just some examples - feel free to create any queries you would like. The tables are below: Region RegionID 101 102 103 104 105 Supplier SuppID 1 2 3 4 Item ItemID 1001 1002 1003 1004 1005 RegionName North South East West Central SuppName Cost Company Wallflower Sam Central Glamazon Item Description Lamp Shoes Shirt Table Socks SuppPhone 111-222-7895 222-333-1236 333-444-4569 444-555-1597 ItemPrice 15.00 30.00 20.00 50.00 5.00 regionID 101 105 105 103 ItemOnHand 10 5 12 13 20 SuppID 1 3 2 4 2 1. Create SQL code to create all the tables including primary and foreign keys 2. Create 3 queries and one must include a join. Some ideas include: A query to find all items that cost more than $10. A query to find all items with a name that begins with 'S' A query to find the average number of items on hand A query to find all items with low inventory A query to find all items in the Central region All suppliers from the North region All items supplied by Wallflower These are just some examples - feel free to create any queries you would like. The tables are below: Region RegionID 101 102 103 104 105 Supplier SuppID 2 RegionName North South East West Central SuppName Cost Company Wallflower SuppPhone 111-222-7895 222-333-1236 regionID 101 105 A query to find all items with low inventory A query to find all items in the Central region All suppliers from the North region All items supplied by Wallflower These are just some examples - feel free to create any queries you would like. The tables are below: Region RegionID 101 102 103 104 105 Supplier SuppID 1 2 3 4 Item ItemID 1001 1002 1003 1004 1005 RegionName North South East West Central SuppName Cost Company Wallflower Sam Central Glamazon Item Description Lamp Shoes Shirt Table Socks SuppPhone 111-222-7895 222-333-1236 333-444-4569 444-555-1597 ItemPrice 15.00 30.00 20.00 50.00 5.00 regionID 101 105 105 103 ItemOnHand 10 5 12 13 20 SuppID 1 3 2 4 2
Expert Answer:
Answer rating: 100% (QA)
The images youve provided show the structure of three database tables Region Supplier and a table that isnt fully visible but seems to contain invento... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
what should I reply back to my peer question to add to the conversation? The differences is in profit anlysis is the changes that may occur when a provider operates with in a capital environment...
-
Due to entity incurring shipping costs as a result of importing machinery, there is a risk that the shipping costs have not been correctly capitalized to the cost of the machinery thereby affecting...
-
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...
-
Nancy has active modified adjusted gross income before passive losses of $75,000. She has a loss of $5,000 on a rental property she actively manages. How much of the loss is she allowed to take...
-
Equate Eqs. (1732) and (1733) to find the rotating speed n1 at which the power equates and marks the division between the pre-maximum and the post maximum power domains.
-
The state government administers a special revenue fund, the Fish and Game Fund. By legislation, revenue in this fund can be used only for the purpose of protection, propagation, and restoration of...
-
Debits and Credits is a public accounting firm specialising in auditing local medium-sized businesses. Fees charged for each audit are determined on the basis of identifiable hours worked on an audit...
-
If bicycle owners do not know whether they are high- or low-risk consumers, is there an adverse selection problem?
-
Different situation now. You re out in space, on a rotating wheel-shaped space station of radius 1085 m. You feel planted firmly on the floor , due to artificial gravity. The gravity you experience...
-
Richard McCarthy (born 2/14/64; Social Security number 100-10-9090) and Christine McCarthy (born 6/1/1966; Social security number 101-21- 3434) have a 19-year-old son (born 10/2/99 Social Security...
-
Hope everyone is doing well. Here in this email I am providing how you should calculate the percentage of yield in the PHASE TRANSFER CATALYSIS experiment. Initially every group took 2ml of reaction...
-
Regardless of their native language, around 6 - 8 months, babies can distinguish English " ra " and " la " sounds at equivalently moderate levels. Which process of the developing brain is thought to...
-
You have just completed technician training and are having a difficult time keeping pace with more senior teammates. You want to be able to do your share of the work to lighten the load of your...
-
A new English program project at the language teaching organization you are working and communicate the new product to the students and public. The report needs to address the followings: 1- Goal...
-
Prakash thinks it's important to ask team members how what's going on outside the team is affecting them. Carla thinks there should be a clear separation between the team and members' experiences...
-
1. Identify Learning Disabilities in your organization or one that you are familiar with. You must justify these disabilities by pointing to the actions, policies, practices, regulations that are...
-
Give the formal charge of the indicated atom. All hydrogens and lone pairs are shown. Review presentation H Click here (without captions) Click here (with captions) 3 www H H H Input format for...
-
Create a data model for one of the processes in the end-of-chapter Exercises for Chapter 4. Explain how you would balance the data model and process model.
-
Jim (age 50) and Martha (age 49) are married with three dependent children. They file a joint return for 2012. Their income from salaries totals $50,000, and they received $10,000 in taxable...
-
For each of the following cases, indicate the filing status for the taxpayer(s) for 2012 using the following legend: A - Single B - Married, filing a joint return C - Married, filing separate returns...
-
Clarita is a single taxpayer with two dependent children, ages 10 and 12. Clarita pays $3,000 in qualified child care expenses during the year. If her adjusted gross income (all from wages) for the...
-
Discuss each of the theoretical change models introduced in this chapter. How can we use them when planning an HRIS implementation to increase our chances of success?
-
The Grant Corporation is a financial services firm based in Chicago, Illinois. Its revenue exceeded \($1\) billion last year, producing a net income of \($530\) million. It has just over 1,000...
-
Analyze the main reasons for HRIS implementation failure. How can we prevent these from affecting us?
Study smarter with the SolutionInn App