Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following schemas for a database used by a share price information system. Table shares ISIN symbol name issuedate date char(12) varchar(6) varchar(25)

Consider the following schemas for a database used by a share price information system. Shares are traded on stock market usi 

Consider the following schemas for a database used by a share price information system. Table shares ISIN symbol name issuedate date char(12) varchar(6) varchar(25) Table prices symbol varchar(6) date date price integer volume integer Shares are traded on stock market using a "ticker symbol" (the symbol attribute). But the actual share is identified by an ISIN number. The ISIN number can change from time to time (due to share splits etc.). The prices table gives the number of shares of a particular ticker symbol traded on each day and the average price. (a) Write a relational algebra expression for the following problem: Find the ISIN's of stocks that traded over 1,000 shares in any single day in 2021. [4 marks] (b) Write a relational algebra expression for the following problem: Find the ISIN's of stocks that traded over 1,000 shares everyday in 2021. [5 marks] Hint: You may find the following logical equivalence useful in devising your solution: for all x, P not (exists x such that not P) (c) Define precisely what it means for a decomposition of a table into two tables to be lossless decomposition. [1 mark]

Step by Step Solution

3.44 Rating (151 Votes )

There are 3 Steps involved in it

Step: 1

a Find the ISINS of stocks that traded over 1000 shares in any single day in 2021 ISIN ... 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

Introduction to Operations Research

Authors: Frederick S. Hillier, Gerald J. Lieberman

10th edition

978-0072535105, 72535105, 978-1259162985

More Books

Students also viewed these Law questions

Question

How much is $102 after a decrease of 2%?

Answered: 1 week ago

Question

How much is $150 after an increase of 150%?

Answered: 1 week ago