Considering the above E-R diagram; (DIAGRAM IN UPLOAD) provide SQL statements for the following cases:
Create above relations for the E-R diagram above
After creating each relation, insert at least 6 rows (tuples) for each relation (table) with data that you invented
SALE_ITEM relation should include at least two same SaleID
Update a “Price” value of a row in the ITEM relation
Updated ITEM (ItemID) should be in SALE_ITEM
Post your solution to the discussion forum and compare with the solutions of your peers. Your solution should include the screenshots of your relations with data. Discuss issues while solving above problems and any assumptions that you made.
ALSO: Facebook is big on PHP, so what is your favorite social media platform?
