The roysched table contains title id, royalty percentage, and other information about title royalties in the pubs3 table.
roysched is defined as follows:
create table roysched title_id tid not null references titles(title_id), lorange int null, hirange int null, royalty int null)
Its nonclustered index for the title_id column is defined as:
create nonclustered index titleidind on roysched (title_id)
