Apex domains cannot have CNAME records.
Question and response
Question
dig royce.web.myhostingspace.co.uk. NS
Answer
royce.web.myhostingspace.co.uk. 5 NS merlin.ns.myhostingspace.co.uk.
royce.web.myhostingspace.co.uk. 5 NS juliet.ns.myhostingspace.co.uk.
Authority
The response has no authority records.
Additional
juliet.ns.myhostingspace.co.uk. 5 A 78.141.235.222
merlin.ns.myhostingspace.co.uk. 5 A 80.240.20.232
juliet.ns.myhostingspace.co.uk. 5 AAAA 2001:19f0:7402:1fe0:5400:5ff:fe20:8cc1
merlin.ns.myhostingspace.co.uk. 5 AAAA 2001:19f0:6c01:18b:5400:3ff:fe9b:9758
. 0 OPT ; payload 1232, xrcode 0, version 0, flags 0