Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following relational schemas: Book (ISBN, Category, BTitle, Quantity) Sales (Sales No, Month_Year, TotalSales, ISBN) Shop (RegNo, Location, Sales No) Customer (CID, CName, TelNo,
Consider the following relational schemas: Book (ISBN, Category, BTitle, Quantity) Sales (Sales No, Month_Year, TotalSales, ISBN) Shop (RegNo, Location, Sales No) Customer (CID, CName, TelNo, Age) Formulate the Relational Algebra statements for the following questions: (i) Where is the location of the shop whose sales number ends with "A000"? (4 Marks) (ii) What was the title and category of the book that the customer Emeka bought? (4 Marks) (iii) Who purchased the book in the Coding category, or the quantity is greater than two? (4 Marks) (iv) What is the total sales and location of the shop with the registration number "REG KL 100" in the month of April 2021? (4 Marks) (v) Display the identification number, name, age together with the total sales of the customers who purchased the Computer Fundamentals title book. (4 Marks)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started