In this assignment, you will take the following requirements and create an ER diagram. The Game-n-Chill...

Transcribed Image Text:

In this assignment, you will take the following requirements and create an ER diagram. The Game-n-Chill video game rental store wants to design a relational database to store information about their customers and their games. They hope the database will improve their ability to market to and provide enhanced service to their customers. Among the things they would like to be able to do, once the database is up and running are: • Search for customers by last name or phone number • When entering new customers, enter a zip code and the database will find the city and state Keep track of which games their customers rented, on what dates, and how much they spent on each date and in total • Be able to send letters to their customers, addressing them by first name • Search for games by game name or type of game. • Search for games that have a certain character (note that some games will have more than one charcters worth searching on) • Games rent for $3-$5 each, plus a 10% entertainment tax • The possible types of games are "Action," "Adventure," "Sports," "RPGs," "Racing", "Fighting," and "Real-time Strategy(RTS)," and "First Person Shooters (FPS)." • The possible type of platforms are "PS4," "Xbox One," and "Nintendo Switch." In this assignment, you will take the following requirements and create an ER diagram. The Game-n-Chill video game rental store wants to design a relational database to store information about their customers and their games. They hope the database will improve their ability to market to and provide enhanced service to their customers. Among the things they would like to be able to do, once the database is up and running are: • Search for customers by last name or phone number • When entering new customers, enter a zip code and the database will find the city and state Keep track of which games their customers rented, on what dates, and how much they spent on each date and in total • Be able to send letters to their customers, addressing them by first name • Search for games by game name or type of game. • Search for games that have a certain character (note that some games will have more than one charcters worth searching on) • Games rent for $3-$5 each, plus a 10% entertainment tax • The possible types of games are "Action," "Adventure," "Sports," "RPGs," "Racing", "Fighting," and "Real-time Strategy(RTS)," and "First Person Shooters (FPS)." • The possible type of platforms are "PS4," "Xbox One," and "Nintendo Switch."

Answer rating: 100% (QA)

Customer custID firstName lastName zipCode integer10 varc... View the full answer