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

  Database backup and restore practices relating to security

Database backup and restore practices relating to security

  Question accountants will use data flow diagrams dfds to

question accountants will use data flow diagrams dfds to depict the physical flows of data through an ais like document

  Find bcnf decomposition of relation schema

Consider a relation schema r(A,B,C,D,E, F) and a set of functional dependencies {A BCD,BCDE,BD,DA}.  Determine whether or not (A,E, F) is in BCNF and justify your answer. If (A,E, F) is not in BCNF,find a BCNF decomposition of it.

  Data mining tools predict future trends and behaviors

Data mining is the retrieval of information from databases, It is a powerful new technology designed to help companies focus on the most important information in their data warehouses. Data mining tools predict future trends and behaviors.

  The time to complete data modeling

How must a database designer balance the time to complete data modeling steps with the benefits the data modeling process offers in creating a database? Consider examples from your work place and class assignments.

  Draw e-r diagrams and state the relationship

Draw E-R diagrams demonstrating each of the following relationships (create three meaningful examples for each relationship): One-to-One, One-to-many, One-to-Optional Many, Optional Many-to-One, Optional Many-to-Optional Many

  What is the two-phase locking protocol

What is the two-phase locking protocol? How does it guarantee serializability and describe the wait-die and wound-wait protocols for deadlock prevention.

  What physical and logical topologies are recommend

Draw a simple floor plan for New Cenrury Wellness group and include the placement of all network nodes including the placement of a server, and network equipment. How many ports will your switch need to accommodate?

  How to design and create tables

Databases are powerful tools for storing, managing, manipulating, and accessing data. Most information systems in use today make use of some form of database. In this lesson you will learn about the Access user interface (UI), how to design and ..

  Order results by customers last name in ascending order

Only demonstrate those customers that have the word/partial word "mail" somewhere in the EmailAddress. Order the results by the customer's last name in ascending order.

  Implement in access database using check and unique

These comprise NOT NULL, CHECK, UNIQUE, REFERENTIAL INTEGRITY, and PRIMARY KEY constraints. Are these constraints which we are talking about easy to implement in Access Database?

  Create a view on the student database connecting student

Create a view on the student database connecting student and enrollment with a where statement so no criteria then try to us it to do

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