Convert the following relation into a relation or set of relations in at least 3NF: Name Address
Fantastic news! We've Found the answer you've been seeking!
Question:
Convert the following relation into a relation or set of relations in at least 3NF:
Name | Address | Contact | InvoiceNo | SaleDate | BookTitle | BookID | Year | Price | StoreID | StoreAddress |
Tony | King St. | 0412597 | 13p1 | 20-2-2015 | Don the Cat | P01 | 2014 | 25 | S1 | Holy St. |
Hassan | Joe St. | 0478956 | 58p5 | 12-9-2022 12-9-2022 | The ABC The Little Prince | R02 D56 | 2017 2016 | 99 25 | S2 S2 | Jason St. Jason St. |
Tony | King St. | 0456981 | 51p3 | 01-1-2021 | Winnie-the-Pooh | F25 | Twenty Twenty | 57 | S1 | Holy St. |
Audrey | Perth St. | 0425897 | No-Invoice | 9-9-9999 | NA | NA | 9999 | 0 | S1 | Holy St. |
*You should provide the solution in "relation schema" format
*Show the name of the relation along with its attributes, identify the PK and FK (Follow the appropriate guidelines as provided in the unit)
*No need to include "values"/ "records"/ "tuples" in the solution
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date: