Bicycle (BikeId, Rate, Maker, Model) Variety (BikeId, Type, Rate) Sold (BikeId, SellerId, DateSold, PriceSold) Seller (SellerId, SellerName, ContactNumber, DOB) Provide relational algebra for the following questions given below: i. List all road bicycles with a rate below 7000$. ii. List all seller name and contactNumber currently selling A-bike bicycles. iii. List all seller ids who sell A-bike bicycles and Fuji Bikes bicycles.” iv. List the variety rate and variety type of all mountain bicycles. v. List the bicycle details (id, rate, maker and model) of all bicycles sold from date 10-02-2021. vi. What are the models of bicycles that have not been bought? Each model should appear only once. vii. List all seller ids who sell mountain bicycles or are born in April. viii. List all seller ids in duos in a way that the seller with first id for a certain bicycle bills a reduced amount than the seller with second id. ix. List all seller ids who sell every bicycle. x. List all seller ids who sell A-bike or Fuji Bikes bicycle.
Bicycle (BikeId, Rate, Maker, Model)
Variety (BikeId, Type, Rate)
Sold (BikeId, SellerId, DateSold, PriceSold)
Seller (SellerId, SellerName, ContactNumber, DOB)
Provide relational algebra for the following questions given below:
i. List all road bicycles with a rate below 7000$.
ii. List all seller name and contactNumber currently selling A-bike bicycles.
iii. List all seller ids who sell A-bike bicycles and Fuji Bikes bicycles.”
iv. List the variety rate and variety type of all mountain bicycles.
v. List the bicycle details (id, rate, maker and model) of all bicycles sold from date 10-02-2021.
vi. What are the models of bicycles that have not been bought? Each model should appear only
once.
vii. List all seller ids who sell mountain bicycles or are born in April.
viii. List all seller ids in duos in a way that the seller with first id for a certain bicycle bills a
reduced amount than the seller with second id.
ix. List all seller ids who sell every bicycle.
x. List all seller ids who sell A-bike or Fuji Bikes bicycle.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
