Question: Question(2) Consider the following database Schema (primary keys are underlined) for a supermarket database. In the database, we store information about items, customers and their

Question(2) Consider the following database Schema (primary keys are underlined) for

Question(2) Consider the following database Schema (primary keys are underlined) for a supermarket database. In the database, we store information about items, customers and their purchases information. Item (No Name, PricePerUnit, Brand) Customer (ID. Name) Purchased items (PurchaselD, Item No, Customerid, Quantity, PurchaseDate) Write the following queries in relational Algebra 1. Display Customers' ID who have purchased at least one item of brand 'ABC'. 2. Increase the PricePerUnit for Item No-1 by 10%. 3. Display the name and brand of items that were never purchased

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!

The following relational schema (primary keys are underlined) are used by the security company, West Park, described in Assignment 1, with some minor modifications. Stores(sid, name, address, phone)...

Express each of the following queries in SQL against the relational schema defined above. Each query should be expressed using a single SQL statement. For each customer who has done at least one...

The Assignment Information The following relational schema (primary keys are underlined) are used by the security company, West Park, described in Assignment 1, with some minor modifications....

Database Fundamentals Consider the following database schema definition: Products(id: integer, title: string, price: float, quantity: integer, category: string, supplier: string) Customers(id:...

Write the SQL table for database 2 and 3 with proper primary key and attributes ? Fil: Ei Vi Windom Helo Home Tools sign In Database 2: Here is another database schema concerning World WarI capital...

Database Management Systems Assignment 1 - Deadline Submission TBA Consider the following database schema and example instance: 3. Find the students (sid and name) that have taken at least one of the...

SQL queries: 1. Returns all the employees and their average sales amount (of all the customers) for each of the products (query result: eid, pid and avg_sales). */ 2. Returns the name and unit price...

the shopping database For many query questions we refer to the following database schema for a website that keeps track of what people like to buy or actually buy in different on-line supermarkets....

Task 1 . 1 Task Description Problem specification: Design a data mart solution for the SUN hotel chain that has over 2 0 0 hotels of different categories all over the world. On a daily basis in the...

Repeat Prob. 527 using maximum shear stress

Assets against which there are no liens are referred to as _______________.

A ( n ) accounting unitcost centerinvestment centerresponsibility center is a segment of a business whose manager is accountable for specific sets of activities.

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

B Drinking on the job is frowned on in corporate America. But at workrelated lunches and dinners, businesspeople often run up considerable bar tabs. Why might alcohol be encouraged in one setting but...

Do you have any relationships that exist strictly online? Do you consider these relationships different from other ones in your life? Are they more intimate or less?

Do you rely on different relational partners for companionship, stimulation, or goal achievement? Do you have some relationships that provide all three functions?