QUESTION 4 (15 MARKS)

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