User Account

All Pages

Write the sql code that will create the table structure

Assignment Help Database Management System
Reference no: EM13899985

Case Description:

Bootup Computers assembles and sells several different computer-system packages. Bootup purchases a variety of parts from different manufacturers and then assembles them into complete computer systems. Due to the rapid growth of its business, Bootup is concerned about the rising costs of its parts inventory. Bootup's owners have asked you to create a simple inventory database to track the company's parts inventory.

Case problems:

1. Display all of the data in the SYSTEM table.

2. Display all of the data in the PART table.

3. Display all of the data in the COMPONENT table.

4. Display the PART_DESC and PART_PRICE for all of the parts in the PART table.

5. Display the PART_ID and total value of each part (PART_PRICE * PART_ONHAND) in the PART table. NOTE: Use the AS keyword to name the expression VALUE.

6. Display the total combined value(PART_PRICE * PART_ONHAND) of all of the parts in the PART table. NOTE: The query should return a single value.

7. Display the PART_ID and QTY_USED from the COMPONENT table for all rows where SYSTEM_ID is STU3419.

8. Display the SYSTEM_DESC and SYSTEM_PRICE for all of the systems in the SYSTEM table that have a price less than $1,000.

9. Display the SYSTEM_ID, SYSTEM_DESC, and SYSTEM_PRICE for all of the systems in the SYSTEM table that have a price between $1,000 and $2,000.

10. Display the PART_ID, PART_DESC and PART_PRICE for all of the parts in the PARTS table where PART_TYPE is CPU and PART_PRICE is greater than $75 and order the output in ascending order by PART_PRICE.

11. Display the PART_TYPE and total number of parts on hand for each part type in the PART table. NOTE: Each part type should appear on a separate line.

12. Display the PART_ID, PART_DESC and QTY_USED from the COMPONENT and PART tables for all of the parts used for SYSTEM_ID = 'STU3419'.

13. Write a subquery to display the SYSTEM_DESC of all systems for which any necessary components have a zero quantity on hand.

14. Write the SQL code that will create the table structure for a table named EMP_1. This Table is a subset of the EMPLOYEE table. The basic EMP_1 table structure is summarized in Table Q7.1. Note that the JOB_CODE is the KF to JOB.

1524_Untitled.png

Reference no: EM13899985

Questions Cloud

Discussing one aspect in romans : In my discussion group we are discussing one aspect in Romans 12-14 in which Paul's portrait of Jesus provides a way of bridging the gap between Christians who think and talk differently about their relationship with God than other Christians do.
List promotional mix elements used inrefresh campaign : List all the promotional mix elements used in the Pepsi Refresh campaign. What grade would you give PepsiCo on integrating these elements into an integration marketing communications campaign?
Identify organizational factors of organizational behavior : Describe the strategic role and purpose of organizational behavior for the company. Identify the organizational factors of organizational behavior for the company
Write the sql code that will create the table structure : Write the SQL code that will create the table structure for a table named EMP
List promotional mix elements used inrefresh campaign : List all the promotional mix elements used in the Pepsi Refresh campaign. What grade would you give PepsiCo on integrating these elements into an integration marketing communications campaign?
Identify the characteristics of the marketing plan : In developing a marketing plan, identify the characteristics of the marketing plan that P&G should implement to boost performance
Determine the amount of total revenue recorded in the ledger : Determine the Amount of total revenue recorded in the ledger and Amount of total expenses recorded in the ledger. Assuming that no adjustments are necessary, what is the amount of net income for March?
Discussing one aspect in romans : In my discussion group we are discussing one aspect in Romans 12-14 in which Paul's portrait of Jesus provides a way of bridging the gap between Christians who think and talk differently about their relationship with God than other Christians do.

Reviews

Write a Review

Database Management System Questions & Answers

  Analyze the database environment

Analyze the database environment. Describe the problems and constraints. Describe the objectives of the database environment.

  Return the empid firstname lastname for the employee

Return the empid, firstname, lastname, and city for the employee with empid 9. Return a list of employee id's, last names, and first names for employees hired on or after January 1, 2004. Retrieve the product name and unit price of all products that ..

  Evaluation team in order to meet sarbanes-oxley compliance

Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley compliance.

  Estimate the cost parameters from the given set of data

Estimate the cost parameters from the given set of data. Cost ¼ 3:8 * Size (KLOC) Estimate the cost parameters from the given set of data.

  Summary of normalizing database tables that it staff use

Suppose that you are the database developer for a local college. The Chief Information Officer (CIO) has asked you to provide a summary of normalizing database tables that the IT staff will use in the upcoming training session

  Write and execute a variety of queries

Write and execute a variety of queries, based on the introduction to SQL in this to test the functionality of the database. Provide a document listing the SQL query statement and a screenshot of the results. Submit a minimum of 8 queries and the r..

  Create scripts of sql statements

Create scripts of SQL statements

  Explain what is the method that you use to store files

What is the method that you use to store files on your computer for your classes

  Explain the relationship between er diagrams and uml

Explain the following terms brie?y: UML, use case diagrams, statechart dia-grams, class diagrams, database diagrams, component diagrams, and deployment diagrams.

  Design an er diagram to capture the given requirements

Design an ER diagram to capture the requirements. State any assumptions you have that affects your design and three-level schema architecture for the Gyan Gurukul Company that provide better security also design a data abstraction for his client ka..

  What do you mean by data base scheme

Database Questions:  What do you mean by data base scheme?  What do you mean by cardinality ratio?   What do you mean by degree of relation?

  Identify the data types and sizes for all attributes

Select database management system (Oracle, SQL Server, MYSQL, etc) and identify the data types and sizes for all attributes

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd