Schema Practice homework

Use a Schema Designer to create schemas for the following problems:

1) City Library System

• a user can check out books
• books have one or more authors
• books belong to a library branch
• a book can be reserved by a user

2) Movie Showtimes

• a movie has many showtimes at various theaters
• a theater has many showtimes for various movies
• a user can purchase a ticket for a specific showtime

3) Flash Cards

• a deck has many cards
• a user can play a round
• a user has a response to each card
• a user can see his/her score for each round played

4) Social Media App

• a user can post statuses
• a user can post pictures
• a user can comment on statuses
• a user can comment on pictures
• a user can have many friends (need help with self-referential association?or this blog post)

5) Survey App

• a user can create one or more surveys
• a survey has many questions
• each question has many choices
• a user can take a survey
• a user can choose a response to a question