Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need create all posibles querys i can use by this picture for give as example MySQL Recycle Table REC_Num Material_Type Material_QTY 1 User Table User_ID

Need create all posibles querys i can use by this picture for give as example MySQLimage text in transcribedimage text in transcribed

Recycle Table REC_Num Material_Type Material_QTY 1 User Table User_ID First_Name Last_Name Email Username Password Date_Birth Rew_Num Rec_Num Red_Num m Rewards Table Rew_Num Red_Vouchers_QTY Red_Donations_QTY Date_Register Redeem Table Red_Num Points_Balance Coupons User Type INT Varchar(20) Varchar(20) Varchar(20) Varchar(20) Varchar(20) Varchar(20) Redeem Rewards Attribute Type Red Num INT Points Balancel INT Coupons Varchar(20) Attribute User ID First Name Last Name Email Username Password Date Birth My Rewards Attribute Rew_Num Red Vouchers QTY Red Donations_OTY Date Rerister Recycle Material Attribute Type REC_Num INT Material Type Varchar(20) Material QTY INT Type INT INT INT DATE Username Attribute Constraint Redeem Rewards Attribute Constraint My Rewards Attribute Constraint Recycle Material Attribute Constraint User_ID Primary Key, No Null, Auto Increment Red_Num Primary Key, No Null Auto Increment Rew_Num Primary Key, No Null, Auto Increment REC_Num Primary key, No Null Auto Increment Points_Balance Coupons No Null No Null Material Type Material QTY No Null No Null Red Vouchers QTY Red Donations QTY Date Register User_ID No Null No Null No Null Foreing Key First Name Last Name Email Username Password Date_Birth Rew_Num Red Num Rec_Num No Null No Null No Null No Null No Null No Null Foreign Key Foreign Key Foreign Key I_

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

Step: 3

blur-text-image

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

More Books

Students also viewed these Databases questions