design a relational database model using the ER-diagram (with 7 to 12 tables) and then create the DDL file for the database. The database to be designed and implemented is an online gaming store. The store sells and delivers Xbox One X, PlayStation 4, and Nintendo Switch games along with all types of consoles and accessories. The buyers need to sign-up with their emails in the system in order to complete their purchase(s). In order to have special discounts and sale emails from the store, the buyers may also choose to become members by paying the annual fees. Any buyer can make multiple orders, access his/her purchase history, and truck orders.

Designing & Creating Database The pupose of the class project is to implement a relational database, load it with data, and execute a collection of queries. For this project you need to use the DBMS you installed (or obtained access to) in the previous project task. For this part of the project, your team is required to design a relational database model using the ER-diagram (with 7 to 12 tables) and then create the DDL file for the database. The database to be designed and implemented is an online gaming store. The store sells and delivers Xbox One X, PlayStation 4, and Nintendo Switch games along with all types of consoles and accessories. The buyers need to sign-up with their emails in the system in order to complete their purchasels). In order to have special discounts and sale emails from the store, the buyers may also choose to become members by paying the annual fees. Any buyer can make multiple orders, access his/her purchase history, and truck orders sake, I would suggest you build this DDL file incrementally, i.e., one table at a time. In addition, the For simplicities order of the statements creating the tables must be consistent with foreign key references. Note declarations, adding "not null" constraints on every field, and even overuse of "check" constraint there are several things that may slow down data loading & querying: leaving out primary or foreign key Deliverables