Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedin 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sybase Database Administrators Handbook

Authors: Brian Hitchcock

1st Edition

0133574776, 978-0133574777

More Books

Students also viewed these Databases questions

Question

Please help me evaluate this integral. 8 2 2 v - v

Answered: 1 week ago

Question

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

Answered: 1 week ago