database - representing play in relational db -

i run project deals plays, shakespeare. right now, storage, parse them out json array formatted this:

[0: {"title": "hamlet", "author": ["shakespeare", "william"], "noacts": 5}, | info   1: [null, ["scene 1 setting", "stage direction", ["character", ["char line 1", "2"]] | act 1  ...] 

and save them file.

we'd move relational database variety of reasons (foremost search) have no idea how represent things.

i'm looking outline of best way things?

the topic 'normalization'

begin identifying main classifications, such play, author, act, scene

then add attributes - specifically, primary key play_id, act_id, etc.

then add still more attributes name or other identifying information.

then finally, add relationships between these object bby creating more tables play_author includes play_id , author_id.