You are building a database for a local library that needs to manage its members and track the status of its media, such as books, magazines, etc., in physical and digital formats.

What database tables would you need to create?

What primary and foreign keys would you need for each table?

How are your tables related to each other?

Think about the properties for each table you created:

What properties would you include as required, must$-$have data?

What are some important properties you would include that might not always have data but are important in the design anyway?

Why is normalization important to this database design? Provide an example of normalization you would perform using your table and property design.

Include at least two supporting sources, including at least one from the course materials and at least one from sources external to the course materials, with appropriate inline citations and a reference list formatted following APA requirements.