Question: in sql server . write a query that can extract mini-figures from your database(minifigs) in a way that, they can be named eg (Darth Vader

in sql server . write a query that can extract mini-figures from your database(minifigs) in a way that, they can be named eg (Darth Vader mini figure ), tie it to a specific set eg (#75183), and get a list of the specific parts that make up the mini figure: eg

Torso piece: 6077866 Leg piece: 6080459 Head piece: 6188222 Head accessory: 6112160 Accessory: 4124108 (light saber)

Group 1 Minifigs 9 minifigkey itemNumber pieceNumber minifigTypeskey minifigName Group1 MinifigTypes 8 minifigTypeskey type Description Group 1 Colors ? colorkey colorName hexCode redValue green Value blueValue Group 1 Set Pieces 9 itemNumber 8 pieceNumber Group 1 Pieces 8 piece Number shapeKey colorKey Group1 Themes themekey themeName themeDesc Group1 Sets 8 itemNumber setName pricePaid isOwned obtainedVia obtained Date setPieceCount theme Key Group1 Shapes shapeKey studWidth studLength shape Description Group 1 Minifigs 9 minifigkey itemNumber pieceNumber minifigTypeskey minifigName Group1 MinifigTypes 8 minifigTypeskey type Description Group 1 Colors ? colorkey colorName hexCode redValue green Value blueValue Group 1 Set Pieces 9 itemNumber 8 pieceNumber Group 1 Pieces 8 piece Number shapeKey colorKey Group1 Themes themekey themeName themeDesc Group1 Sets 8 itemNumber setName pricePaid isOwned obtainedVia obtained Date setPieceCount theme Key Group1 Shapes shapeKey studWidth studLength shape Description

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

there is a picture of the database attached . in sql server write a query that is able to extract mini-figures from your database but need to do so in a way that I can name the mini figure (Darth...

Database Security /* Q1. As an administrator of your SQL Server, write a DDL statement to create a new SQL Server login called 'shark' with a password 'Mid-Atlantic'. Do not enforce the Windows...

using SQL Server, write SQL queries for each problem in file below. you need to attach/create both Northwind & PVC databases using the instructions given Use Northwind database: 1. Write a query that...

The objective of this assignment is to assess your understanding of SQL queries, functional dependencies, and normalization. Academic Integrity Statement: This assignment must be completed...

Relational Database Design and SQL Using Microsoft SQL Server, write the SQL statements for each question necessary to generate the required result set. Answer the following three questions Entity...

Using the " Adventureworks2012" database schema in SQL Server, write a query for the following: 16. Write a query to find out how many people have a Seattle address. List the Address ID, Address...

Using Structured Query Language (in Microsoft SQL Server): Write the code that will create a table called tblPeople that will match and store the data from People.txt (inserted below) Write the code...

SQL Server Write script to create the tables for the following database diagram. Include Primary Key, Foreign Key, Unique, Null, not null, Datatype, constraints and other data validation tools when...

the database is above in sql server write A query that list of sets I currently owned (make the details up). Your query should return the theme, set name, set number, how many pieces, and when it was...

the database diagram is above . In sql server write A query that exports out a list of mini figures and their associated theme, set, and parts Group1_Minifigs PK minifigkey:Auto Number SIEK...

1) A hardware store in West Covina, CA, conducts a survey to estimate the average number of houseplants in people's houses. A sample of 40 people gives the following data: 13, 5, 18, 20, 0, 1, 3, 0,...

Find an example of a successful public-private-nonprofit partnership. What has made this partnership successful? What did the different parties do to structure the partnership to help it be...

In year 0 . Javers incorposated sold machinery with a fair market value of $ 4 2 0 , 0 0 0 to Chms . The machinery's original hasis was $ 3 3 6 , 0 0 0 and Jiven's accumalated depreciabion on the...

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

3. Assess the quality or value of communication by examining its six characteristics

5. Describe the visual representations, or models, of communication

4. Define what communication scholars consider to be competent communication