Consider the following two relational database tables to answer all the below questions. Smart Phone Table Sale Table Phone ID Brand Model Cost Date Sale Sale_ID Phone_ID of Galaxy Note Price P-001...



Please make sure the answer is correct 100%


Consider the following two relational database tables<br>to answer all the below questions.<br>Smart Phone Table<br>Sale Table<br>Phone ID<br>Brand<br>Model<br>Cost<br>Date<br>Sale<br>Sale_ID Phone_ID<br>of<br>Galaxy<br>Note<br>Price<br>P-001<br>Samsung<br>180.00<br>Sale<br>KD<br>10<br>REC<br>320.00<br>4-<br>P-003<br>Galaxy<br>S10-<br>April-<br>2021<br>101<br>KD<br>P-002<br>Samsung<br>160.00<br>KD<br>Lite<br>REC<br>11-<br>100.00<br>P-001<br>March-<br>2021<br>P-003<br>Apple<br>IPhone<br>250.00<br>102<br>KD<br>12<br>KD<br>IPhone<br>300.00<br>REC<br>5-<br>120.00<br>KD<br>P-004<br>Apple<br>P-001<br>12 Pro<br>KD<br>103<br>March-<br>2021<br>

Extracted text: Consider the following two relational database tables to answer all the below questions. Smart Phone Table Sale Table Phone ID Brand Model Cost Date Sale Sale_ID Phone_ID of Galaxy Note Price P-001 Samsung 180.00 Sale KD 10 REC 320.00 4- P-003 Galaxy S10- April- 2021 101 KD P-002 Samsung 160.00 KD Lite REC 11- 100.00 P-001 March- 2021 P-003 Apple IPhone 250.00 102 KD 12 KD IPhone 300.00 REC 5- 120.00 KD P-004 Apple P-001 12 Pro KD 103 March- 2021
3) Is it possible to add the below record to the<br>Sale table? Explain why?<br>REC 104<br>P-004<br>385.00 KD 20-April-2021<br>4) Is it possible to add the below record to the<br>Smart Phone table? Explain why?<br>P-<br>IPhone 12 Pro<br>1-March-<br>Apple<br>003<br>Маx<br>2021<br>

Extracted text: 3) Is it possible to add the below record to the Sale table? Explain why? REC 104 P-004 385.00 KD 20-April-2021 4) Is it possible to add the below record to the Smart Phone table? Explain why? P- IPhone 12 Pro 1-March- Apple 003 Маx 2021

Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here