This sounds like homework. Designing a DB is a lot of work and you should go step by step with the design.

You have a good example with the AdventureWorks databases, but you shouldn't copy it as it is (anyone with SQL Server experience would notice).

Try to keep it simple, identify entities and their attributes and relationships. Everything comes from there.