I have the following requirements shown below.
What i require is the proper table design with relationships(PK and FK). Aprreciate your help.